Learning OutcomesThe student will be able to:
• Explain the basic concepts of DBMS
• Explain database architecture & modeling
• Design Entity Relationship models
• Use normalization process
• Design a database
• Manipulate data using SQL
• Manipulate data using relational algebra
• Implement a database using suitable DBMS
• IPerform database maintenance and troubleshooting.
Learning Content /
Introduction to DBMS
1.1 The evolution of database technology
1.2 Characteristics of the database approach
1.3 Components of a DBMS
1.4 Advantages of using the DBMS approach
Database architecture and modeling
2.1 Three-Schema architecture
2.1 Categories of data models
Database design process
3.1 Database system development life cycle
3.2 Database design stages
Relational Data model
4.1 Relational Model terminology
4.2 Keys
4.3 Constraints
4.4 Relational algebra
Entity-Relationship model
5.1 ER concept & terminology
5.2 Entities, Relationship & Attributes
5.3 ER Diagrams
5.4 Mapping conceptual model in to relational schema
5.5 Introduction to EER modeling
Data Normalization process and the normal forms
6.1 Introduction to data normalization
6.2 1st Normal Form ( 1st NF )
6.3 2nd Normal Form (2nd NF)
6.4 3rd Normal Form ( 3rd NF )
6.5 Boyce-Codd Normal Form
Data manipulation using SQL
7.1 Introduction to SQL
3.2. DDL
3.3. DML
Physical database design
8.1 File structures
8.2 Storage devices
Equipment, Tools &
a. Software – VISIO, My SQL, SQL Server, Freeware, Oracle(optional), CASE TOOLS, UML
Hardware – Client-server system with network environment

Copyright@ 2021. All rights reserved. -NVQ Project-

Don`t copy text!