Objective:
The course is designed with an objective to
Construct simple and moderately advanced database queries using Structured Query
Language (SQL)
Apply logical database design principles, including E-R diagrams and database
normalization
Learning Outcome:
On completion of the course, students will be able to
Describe the principles of the relational database Access
Define and manipulate data using SQL
Construct and normalize conceptual data models.
Unit I: 10L
Introduction to Database Management Systems: Characteristics of database approach, data
models, DBMS architecture and data independence.
Unit II: 15L
Entity Relationship and Enhanced ER Modeling: Entity types, relationships, SQL-99: Schema
Definition, constraints, and object modeling.
Unit III: 15L
Relational Data Model: Basic concepts, relational constraints, relational algebra, SQL queries.
Unit IV: 20L
Database design: ER and EER to relational mapping, functional dependencies, normal forms up
to third normal form.
Books Recommended:
1. R. Elmasri, S.B. Navathe, Fundamentals of Database Systems 6th Edition, Pearson
Education, 2010.
2. R. Ramakrishanan, J. Gehrke, Database Management Systems 3rd Edition, McGrawHill, 2002.
3. A. Silberschatz, H.F. Korth, S. Sudarshan, Database System Concepts 6th Edition,
McGraw Hill, 2010.
4. R. Elmasri, S.B. Navathe Database Systems Models, Languages, Design and application
Programming, 6th Edition, Pearson Education, 2013.
Computer Lab Based on Database Management Systems:
Describe the principles of the relational database Access
Define and manipulate data using SQL
Construct and normalize conceptual data models.
The course is designed with an objective to
Construct simple and moderately advanced database queries using Structured Query
Language (SQL)
Apply logical database design principles, including E-R diagrams and database
normalization
Learning Outcome:
On completion of the course, students will be able to
Describe the principles of the relational database Access
Define and manipulate data using SQL
Construct and normalize conceptual data models.
Unit I: 10L
Introduction to Database Management Systems: Characteristics of database approach, data
models, DBMS architecture and data independence.
Unit II: 15L
Entity Relationship and Enhanced ER Modeling: Entity types, relationships, SQL-99: Schema
Definition, constraints, and object modeling.
Unit III: 15L
Relational Data Model: Basic concepts, relational constraints, relational algebra, SQL queries.
Unit IV: 20L
Database design: ER and EER to relational mapping, functional dependencies, normal forms up
to third normal form.
Books Recommended:
1. R. Elmasri, S.B. Navathe, Fundamentals of Database Systems 6th Edition, Pearson
Education, 2010.
2. R. Ramakrishanan, J. Gehrke, Database Management Systems 3rd Edition, McGrawHill, 2002.
3. A. Silberschatz, H.F. Korth, S. Sudarshan, Database System Concepts 6th Edition,
McGraw Hill, 2010.
4. R. Elmasri, S.B. Navathe Database Systems Models, Languages, Design and application
Programming, 6th Edition, Pearson Education, 2013.
Computer Lab Based on Database Management Systems:
Describe the principles of the relational database Access
Define and manipulate data using SQL
Construct and normalize conceptual data models.
No comments:
Post a Comment