Syllabus
|
Course Code: BCA-307 Course Name: DATA BASE MANAGEMENT SYSTEM – I |
||
| MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
|---|---|---|
| 1 | Basic Concepts – Data, Information, Records, Files, Schema and Instance etc. Limitations of File Based Approach, Characteristics of Database Approach, Database Management System (DBMS), Components of DBMS Environment, DBMS Functions and Components, Database Interfaces, Advantages and Disadvantages of DBMS. | |
| 2 | Database Users: Data and Database Administrator, Role and Responsibilities of Database Administrator, Database Designers, Application Developers etc. Database System Architecture – 1-Tier, 2-Tier & Three Levels of Architecture, External, Conceptual and Internal Levels, Schemas, Mappings and Instances, Data Independence – Logical and Physical Data Independence. Data Models: Hierarchical, Network and Relational Data Models. | |
| 3 | Entity-Relationship Model: Entity, Entity Sets, Entity Type, Attributes: Type of Attributes, Keys, Integrity Constraints,
Domain and Tuple Constraint, Relationship: Role Names, Recursive Relationship, Types/ Degree, Cardinality Ratios,
Relationship Constraints. Designing of ER Diagram, Symbolic Notations for Designing ER Diagram, Design Issues, and Reduction of ER diagram into Relational Tables. Making ER Diagrams for Inventory, Book Store, Library and Flight Management System etc. |
|
| 4 | SQL: Meaning, Purpose and Need of SQL, Data Types, SQL Components: DDL, DML, DCL and DQL, Basic Queries,
Join Operations and Sub-queries, Views, Specifying Indexes. Constraints and its Implementation in SQL. Relational Algebra: Basic Operations: Select, Project, Join, Union, Intersection, Difference, and Cartesian Product etc. Relational Calculus: Tuple Relational and Domain Relational Calculus. Relational Algebra Vs. Relational Calculus. |
|
