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 Constrai |