Scribd
Upload
160 views

1.syllabus 10cs54 Dbms

The document provides details about the course DATABASE MANAGEMENT SYSTEMS including subject code, hours per week, total hours, marks distribution, exam hours and marks. It describes 8 units that make up the course covering topics like data models, entity-relationship model, relational model, relational algebra, SQL, database design, transaction management.

Uploaded by

naguananth
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
160 views

1.syllabus 10cs54 Dbms

The document provides details about the course DATABASE MANAGEMENT SYSTEMS including subject code, hours per week, total hours, marks distribution, exam hours and marks. It describes 8 units that make up the course covering topics like data models, entity-relationship model, relational model, relational algebra, SQL, database design, transaction management.

Uploaded by

naguananth
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

DATABASE MANAGEMENT SYSTEMS

Subject Code: 10CS54


Hours/Week : 04
Total Hours : 52

I.A. Marks : 25
Exam Hours: 03
Exam Marks: 100

PART - A
UNIT 1
6 Hours
Introduction: Introduction; An example; Characteristics of Database approach; Actors on the screen;
Workers behind the scene; Advantages of using DBMS approach; A brief history of database
applications; when not to use a DBMS.
Data models, schemas and instances; Three-schema architecture and data independence; Database
languages and interfaces; The database system environment; Centralized and client-server architectures;
Classification of Database Management systems.
UNIT 2
6 Hours
Entity-Relationship Model: Using High-Level Conceptual Data Models for Database Design; An
Example Database Application; Entity Types, Entity Sets, Attributes and Keys; Relationship types,
Relationship Sets, Roles and Structural Constraints; Weak Entity Types; Refining the ER Design; ER
Diagrams, Naming Conventions and Design Issues; Relationship types of degree higher than two.
UNIT 3
8 Hours
Relational Model and Relational Algebra : Relational Model Concepts; Relational Model Constraints
and Relational Database Schemas; Update Operations, Transactions and dealing with constraint
violations; Unary Relational Operations: SELECT and PROJECT; Relational Algebra
Operations from Set Theory; Binary Relational Operations : JOIN and DIVISION; Additional Relational
Operations; Examples of Queries in Relational Algebra; Relational Database Design Using ER- toRelational Mapping.
UNIT 4
6 Hours
SQL 1: SQL Data Definition and Data Types; Specifying basic constraints in SQL; Schema change
statements in SQL; Basic queries in SQL; More complex SQL Queries.
PART - B
UNIT 5
6 Hours
SQL 2 : Insert, Delete and Update statements in SQL; Specifying constraints as Assertion and Trigger;
Views (Virtual Tables) in SQL; Additional features of SQL; Database programming issues and
techniques; Embedded SQL, Dynamic SQL; Database stored procedures and SQL /
PSM.
UNIT 6
6 Hours
Database Design 1: Informal Design Guidelines for Relation Schemas; Functional Dependencies;
Normal Forms Based on Primary Keys; General Definitions of Second and Third Normal Forms; BoyceCodd Normal Form
UNIT 7
6 Hours
Database Design -2: Properties of Relational Decompositions; Algorithms for Relational Database
Schema Design; Multivalued Dependencies and Fourth Normal Form; Join Dependencies and Fifth
Normal Form; Inclusion Dependencies; Other Dependencies and Normal Forms
UNIT 8
8 Hours
Transaction Management: The ACID Properties; Transactions and Schedules; Concurrent Execution of
Transactions; Lock- Based Concurrency Control; Performance of locking; Transaction support in SQL;
Introduction to crash recovery; 2PL, Serializability and Recoverability; Lock Management; Introduction
to ARIES; The log; Other recovery-related structures; The write-ahead log protocol; Checkpointing;
Recovering from a System Crash; Media Recovery; Other approaches and interaction with concurrency
control.
Text Books:
1. Elmasri and Navathe: Fundamentals of Database Systems, 5th Edition, Pearson Education, 2007.
(Chapters 1, 2, 3 except 3.8, 5, 6.1 to 6.5, 7.1, 8, 9.1, 9.2 except SQLJ, 9.4, 10)
2. Raghu Ramakrishnan and Johannes Gehrke: Database Management Systems, 3rd Edition, McGrawHill, 2003. (Chapters 16, 17.1, 17.2, 18)
Reference Books:
1. Silberschatz, Korth and Sudharshan: Data base System Concepts, 6th Edition, Mc-GrawHill, 2010. 2.
C.J. Date, A. Kannan, S. Swamynatham: An Introduction to Database Systems, 8th Edition, Pearson
Education, 2006.

You might also like