DBMS (DATABASE MANAGEMENT SYSTEMS)

DCRUST SYLLABUS

CSE303C   DATABASE MANAGEMENT SYSTEMS

CATEGORY : ENGINEERING SCIENCE COURSE

Course Objectives:

  1. To understand the different issues involved in the design and implementation of a database system.
  2. To study the physical and logical database designs, database modeling, relational, hierarchical, and   network models
  3. To understand and use data manipulation language to query, update, and manage a Database
  4. 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:

  1. “Database System Concepts”, 6th Edition by Abraham Silberschatz, Henry F. Korth, S. Sudarshan, McGraw-Hill.
  2. “Principles of Database and Knowledge – Base Systems”, Vol 1 by J. D. Ullman, Computer Science Press.
  3. “Fundamentals of Database Systems”, 5th Edition by R. Elmasri and S. Navathe, Pearson Education
  4. “Foundations of Databases”, Reprint by Serge Abiteboul, Richard Hull, Victor Vianu, Addison-Wesley

Course Outcomes:  After successful completion of the course:-

  1. Understand basic concepts of database system and data models for relevant problems.
  2. Understand the basic elements of a relational database management system.
  3.  Design entity relationship model and convert entity relationship diagrams into RDBMS and   formulate SQL queries on the data.
  4. Apply normalization for the development of application software.
error: You can only copy the programs code and output from this website. You are not allowed to copy anything else.