DCRUST SYLLABUS
CSE303C DATABASE MANAGEMENT SYSTEMS
CATEGORY : ENGINEERING SCIENCE COURSE
Course Objectives:
- To understand the different issues involved in the design and implementation of a database system.
- To study the physical and logical database designs, database modeling, relational, hierarchical, and network models
- To understand and use data manipulation language to query, update, and manage a Database
- To develop an understanding of essential DBMS concepts such as: database security, integrity, concurrency, distributed database, and intelligent database, Client/Server (Database Server), Data Warehousing.
Unit I
Database system architecture: – Data Abstraction, Data Independence, DataDefinition Language (DDL), Data Manipulation Language (DML).
Data models: – Entity-relationship model, network model, relational and objectoriented data models, integrity constraints, data manipulation operations.
Click on any topic to read about the topic.
Unit II
Relational query languages:- Relational algebra, Tuple and domain relationalcalculus, SQL3, DDL and DML constructs, Open source and Commercial DBMS – MYSQL, ORACLE, DB2, SQL server.
Relational database design: – Domain and data dependency, Armstrong’s axiom,Normal forms, Dependency preservation, Lossless design.
Query processing and optimization: – Evaluation of relational algebra expressions,Query equivalence, Join strategies, Query optimization algorithms.
Click on any topic to read about the topic.
Unit III
Concurrency control, ACID property, Serializability of scheduling, Locking and timestamp based schedulers, Multi-version and optimistic Concurrency Control schemes, Database recovery.
Click on any topic to read about the topic.
Unit IV
Authentication, Authorization and access control, DAC, MAC and RBAC models, Intrusion detection, SQL injection. Advanced topics: Object oriented and object relational databases, Logical databases, Web databases, Distributed databases, Data warehousing and data mining.
Click on any topic to read about the topic.
TEXT /REFERENCE BOOKS:
- “Database System Concepts”, 6th Edition by Abraham Silberschatz, Henry F. Korth, S. Sudarshan, McGraw-Hill.
- “Principles of Database and Knowledge – Base Systems”, Vol 1 by J. D. Ullman, Computer Science Press.
- “Fundamentals of Database Systems”, 5th Edition by R. Elmasri and S. Navathe, Pearson Education
- “Foundations of Databases”, Reprint by Serge Abiteboul, Richard Hull, Victor Vianu, Addison-Wesley
Course Outcomes: After successful completion of the course:-
- Understand basic concepts of database system and data models for relevant problems.
- Understand the basic elements of a relational database management system.
- Design entity relationship model and convert entity relationship diagrams into RDBMS and formulate SQL queries on the data.
- Apply normalization for the development of application software.