B.E (Engineering) Computer Science (CSE) free download

File name CSE-V-DATABASE MANAGEMENT SYSTEMS [10CS54]-NOTES.pdf

Data Base Management System(10CS54) DATABASE MANAGEMENT SYSTEMS Subject Code: 10CS54 Exam Hours: 03 I.A. Marks : 25 Total Hours : 52 Hours/Week : 04 Exam Marks: 100 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 ependencies; Normal Forms Based on Primary Keys; General Definitions of Second and Third Normal Forms; Boyce-Codd Normal Form CI TS 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. TU D 8 Hours UNIT ­ 3 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- to-Relational Mapping. EN 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 degreehigher than two. CITSTUDENTS.IN TS .IN PART - A 6 Hours UNIT ­ 1 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; Threeschema architecture and data independence; Database languages and interfaces; The database system environment; Centralized and client-server architectures; Classification of Database Management systems. Page 1 Data Base Management System(10CS54) 6 Hours UNIT ­ 7 Database Design -2: Properties of Relational Decompositions; Algorithmsfor Relational Database Schema Design; Multivalued Dependencies andFourth Normal Form; Join Dependencies and Fifth Normal Form; Inclusion Dependencies; Other Dependencies and Normal Forms 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 CI TS TU D EN Text Books: 1. Elmasri and Navathe: Fundamentals of Database Systems,5th Edition, Pearson Education, 2007.(Chap