The course introduces the concepts of database management systems to students, focusing on basics such as the importance and significance of a database, data model, schema creation and normalization.
At the end of the course, students should be able to:
Unit 1
Introduction: Introduction to database, relational data model, DBMS architecture, data independence and data abstraction, DBA, database users, end users, front end tools.
Unit 2
Data Modelling: Entity types, entity set, attribute and key, relationships, relation types, ER diagrams, database design using ER diagrams.
Unit 3
Relational Data Model: Relational model concepts, relational constraints, primary and foreign key, candidate key, alternate, composite, super-key.
Unit 4
Data redundancy, Normalization: 1NF, 2NF, 3NF.
Unit 5
Structured Query Language: Introduction to SQL, concepts of Data Definition Language (DDL) and Data Manipulation Language (DML), DDL queries like create a data base, drop a database, create table, drop table, alter table, DML queries like inserting data in a table, update in a table, delete data from a table, filter data.
Unit 6
Structured Query Language (continued..): Create relationships between database tables, auto increment, check, Null values, aggregate functions – min, max, count, average, sum, nested sub-queries, group by, having, exists, case, order by. Join operations – inner, left join, right join, natural join and Cartesian product. Overview of forms and reports.
Bayross, I. (2010) SQL, Pl/SQL the Programming Language of Oracle. 4th edition. BPB Publications.
Elmsasri, R., & Navathe, S.(2017). Fundamentals of Database Systems. 7th edition. Pearson Education.
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2011), Database System Concepts. 6th edition. Tata McGraw-Hill Education.
Date, C.J., Kanman, A. & Swamynathan, S. (2006). An Introduction to Database Systems.8th edition. Pearson Education.
Ramakrishnan, R. Gehrke, J. (2014), Database Management Systems. 3rd edition. Tata McGraw Hill Education.
MWidenius, M., Axmark, D., Cole, J., Lentz, A., & Dubois, P. (2002). MySQL Reference Manual. O’Reilly Community Press.
Use of ICT tools in conjunction with traditional class room teaching methods
Interactive sessions
Class discussions
Written tests, assignments, quizzes, presentations as announced by the instructor in the class
Databases, E-R diagrams, normalization, structured query language.
Disclaimer: Details on this page are subject to change as per University of Delhi guidelines. For latest update in this regard please refer to the University of Delhi website here.
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |