DBMS - CST-227
DBMS - CST-227
DBMS - CST-227
Version: Systems
2019 Apply to Programs:Common to all 3 0 0 0 3
Specializations of CSE 2nd Year
Total Marks: 100
Internal Marks: 40 External Marks: 60
Course Pre-requisite: Total hours =45
Code
CST-227 Course Objective
To have good understanding of database system concepts and design
databases for different applications.
To learn how to use a DBMS and RDBMS.
To implement and understand different types of DDL, DML and DCL
statements.
To understand transaction concepts related to databases and
recovery/backup techniques required for the proper storage of data.
Course Outcomes
1 Designing database
UNIT-I [15h]
Overview of Databases: Database concepts, DBMS, Data Base System Architecture (Three
Level ANSI-SPARC Architecture), Advantages and Disadvantages of DBMS, Data
Independence, DBA and Responsibilities of DBA, Relational Data Structure, Keys,
Relations, Attributes, Schema and Instances, Referential integrity, Entity integrity, data
models Relational Model, Network Model, Hierarchical Model, ER Model: Design, issues,
Mapping constraints, ER diagram, Comparison of Models. .
UNIT-III [15h],.
Reference Books: