GOVERNMENT POLYTECHNIC COLLEGE PURASAWALKAM, CHENNAI - 12 DEPARTMENT OF COMPUTER ENGINEERING III YEAR / V SEM / FIRST SHIFT 35252- RELATIONAL DATABASE MANAGEMENT SYSTEMS Subject handled by: C Designation : Part Time / Guest Lecturer CHAPTER HOURS PORTIONS COVERED DATE NO UNIT - I Database Systems and data modelling (14 HRS) Introduction to database 1 Database systems: Database Management System , Characteristics of 11.06.18 1.1 Database Components of Database , Functions of Database , 2 Understanding database model, Evolution 3 1.1 12.06.18 Types of database models: Hierarchical Database Model, Network 4 Database Model, Relational Database Model. 5 Transactional Databases, Decision Support Databases and Hybrid 1.2 12.06.18 Databases , Open Source databases 6 7 14.06.18 Relational data model: CODD’s rules ,Components of RDBMS Table structure,Records,rows, tuples , attributes. Keys : Primary, Foreign , ` 8 14.06.18 Composite, unique keys 1.3 9 Meta Data, Data Dictionary. Data Integrity - Data Constraints and 15.06.18 validation : Types of Constraints Difference between SQL and MYSQL 10 ER Diagram and Normalization: Methodologies of Designing 11 18.06.18 Database,Entities-Relationships (1:1, 1 : many and many : many) 12 1.4 19.06.18 ER Diagram Samples . – Normalization : Benefits ,Normal Forms , 1st Normal Form, 2nd Normal 13 21.06.18 Form , 3rd Normal Form . Database Administration : Server/client And Distributed concept: 14 22.06.18 DBA Tasks ,DBA Tools 1.5 15 22.06.18 Data Base Maintenance Backup and Recovery – CHAPTER HOURS PORTIONS COVERED DATE NO UNIT-II MySQL Administration & Database Design 15 HOURS Installation of MySQL:Features of MySQL,Download, Installing, 2.1 16 26.06.18 Starting & Stopping connections to the MySQL server
GOVERNMENT POLYTECHNIC COLLEGE PURASAWALKAM, CHENNAI - 12 DEPARTMENT OF COMPUTER ENGINEERING III YEAR / V SEM / FIRST SHIFT 35252- RELATIONAL DATABASE MANAGEMENT SYSTEMS Subject handled by: C Designation : Part Time / Guest Lecturer HOURS CHAPTER NO PORTIONS COVERED DATE UNIT - I Database Systems and data modelling (14 HRS) 1 1.1 Introduction to database Database systems: Database Management System , Characteristics of Database Components of Database , Functions of Database , Understanding database model, Evolution 11.06.18 2 3 1.1 Types of database models: Hierarchical Database Model, Network Database Model, Relational Database Model. 12.06.18 4 5 1.2 Transactional Databases, Decision Support Databases and Hybrid Databases , Open Source databases 12.06.18 6 7 1.3 Relational data model: CODD’s rules ,Components of RDBMS 14.06.18 ` 8 Table structure,Records,rows, tuples , attributes. Keys : Primary, Foreign , Composite, unique keys 14.06.18 9 Meta Data, Data Dictionary. Data Integrity - Data Constraints and validation : Types of Constraints Difference between SQL and MYSQL 15.06.18 10 11 1.4 ER Diagram and Normalization: Methodologies of Designing Database,Entities-Relationships (1:1, 1 : many and many : many) 18.06.18 12 ER Diagram – Samples . 19.06.18 13 Normalization : Benefits ,Normal Forms , 1st Normal Form, 2nd Normal Form , 3rd Normal Form . 21.06.18 14 1.5 Database Administration : Server/client And Distributed concept: DBA Tasks ,DBA Tools 22.06.18 15 Data Base Maintenance – Backup and Recovery 22.06.18 HOURS CHAPTER NO PORTIONS COVERED DATE UNIT-II MySQL Administration & Database Design 15 HOURS 16 2.1 Installation of MySQL:Features of MySQL,Download, Installing, Starting & Stopping connections to the MySQL server 26.06.18
RDBMS_II_shift_3year_2shift.docx