DBSQL- Leson Guidelines.docVIP

LESSON 1 INTRODUCTION TO DATABASE MANAGEMENT SYSTEM TRANSPARENCY TITLE NO. DBSQL1-3 WHAT IS DATA AND INFORMATION? DBSQL1-5 FILE-BASED SYSTEM DBSQL1-8 DATABASE MANAGEMENT SYSTEM DBSQL1-12 HISTORY OF DBMS DBSQL1-13 ANSI/SPARC ARCHITECTURE DBSQL1-17 COMPONENTS OF DATABASE DBSQL1-20 DATABASE ARCHITECTURE LECTURER TO NOTE THE LECTURER MUST DISCUSS THE GENERAL CONCEPT OF DATA, INFORMATION, DATABASE AND FILE-BASED. THE ADVANTAGES AND DISADVANTAGES OF A FILE-BASED AND DATABASE SYSTEM SHOULD ALSO BE STRESSED OUT THE LECTURER NEEDS TO LET THE STUDENT UNDERSTAND THE ANSI/SPARC ARCHITECTURE AS WELL THE DATABASE ARCHITECTURE LESSON 2 ENTITY RELATIONSHIP MODEL TRANSPARENCY TITLE NO. DBSQL2-3 ENTITY RELATIONSHIP DIAGRAM DBSQL2-9 REDUCING DIAGRAMS INTO TABLES DBSQL2-13 ENHANCED ERD DBSQL2-14 SPECIALIZATION GENERALIZATION DBSQL2-16 ISA RELATIONSHIP DESIGN DBSQL2-18 E-R MODELLING DBSQL2-19 INTRODUCTION TO RELATIONAL DB LECTURER TO NOTE THE LECTURER MUST DISCUSS THOROUGHLY THE DIFFERENT ER SYMBOLS AND THE ER MODELLING PROCESS ITSELF THE LECTURER NEED TO DESCRIBE PROPERLY ON HOW A TABLE IS TO BE REDUCED AND TO APPLY ALSO THE CONCEPT OF ENHANCE ENTITY DIAGRAM THE IMPORTANCE OF SPECIALIZATION AND GENERALIZATION MUST BE STRESSED OUT ACCORDINGLY