MODULE DESCRIPTOR
| Learning Outcomes | The 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 / Topics | 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 | |
| Resources: Equipment, Tools & Materials | a. Software – VISIO, My SQL, SQL Server, Freeware, Oracle(optional), CASE TOOLS, UML Hardware – Client-server system with network environment |