Software Lab-VII (Database Management Systems) Notes
Subject Overview
The practical companion to Database Management Systems, building familiarity with MS Access — creating databases and tables, running SQL queries, and using forms/
Subject at a glance
1
Units
7
Topics
2
Credits
1
Infographics
Unit-wise Syllabus
1 units — open any unit for detailed topic-wise notes, diagrams and important exam questions
- MS Access features
- elements and window components
- creating and saving databases and tables
- running DDL and DML commands via SQL
- creating views
- using forms and reports
- introductory practicals on Crystal Reports
DDL
Define structure
CREATE, ALTER, DROP
DML
Change data
INSERT, UPDATE, DELETE
DQL
Query data
SELECT
DCL
Control access
GRANT, REVOKE
TCL
Manage transactions
COMMIT, ROLLBACK
Study guide
In this lab you work with MS Access: its features and window elements, creating and saving databases and tables, running DDL and DML commands through SQL, creating views, using forms and reports and introductory practicals on Crystal Reports. Design tables with correct data types and keys before entering data.
Why Software Lab-VII (Database Management Systems) Matters
Hands-on database practice builds the SQL and design skills needed for development and data roles.
How to Prepare for Software Lab-VII (Database Management Systems)
- Create a complete small database such as student or library records.
- Practise queries, forms and reports on the same data.
- Learn the difference between a table, a query and a view.
Software Lab-VII (Database Management Systems): Frequently Asked Questions
What is covered in the DBMS lab?
Creating tables and databases in MS Access, SQL commands, views, forms and reports.