8/6/2019 Bs14 Database Management System

1/2

BSCIT 1st Semester

Subject Code : BS14

Subject Name : Database Management Systems

Block 1 Introduction to Database System

Unit 1- Introduction To Data Base System: Introduction, Objectives,

Traditional file oriented approach, Motivation for database approach,

Database basics, Three views of data, The three level architecture of

DBMS, External level or subschema, Conceptual level or conceptual

schema, Internal level or physical schema, Mapping between different

levels, Database management system facilities, Data definition

language, Data manipulation language, Elements of a database

management system, DML precompiled, DDL compiler, File manager,

Database manager, Query processor, Database administrator, Data

dictionary, Advantages and disadvantages of DBMS.

Unit 2- Database Models: Introduction, Objectives,File management system,

Entity-relationship (e-r) diagram, Intrdoction of erd, Entity-relationship

diagram, Generalization and aggregation, Aggregation, The

hierarchical model, The network model, The relational model,Advantages and disadvantages of relational approach, An example of

a relational model.

Unit 3- File Organisation For DBMS: Introduction, Objectives, File

organization, Sequential file organisation, Index-sequential file

organization, Types of indexes, B-trees, Advantages of b-tree indexes,

Direct file organization, Need for the multiple access path.

BLOCK 2 Relational model and Normalisation

Unit 1- Representing Data Elements: Data Elements and Fields,

Representing Relational Database Elements, Records, Representing

8/6/2019 Bs14 Database Management System

2/2

BSCIT 1st Semester

Subject Code : BS14

Subject Name : Database Management Systems

Block and Record Addresses, Client-Server Systems, Logical and

Structured Addresses, Record Modifications, Index Structures, Indexes

on Sequential Files, Secondary Indexes, B-Trees, Hash Tables.

Unit 2- Relational Model: Introduction, Objectives, Concepts of a relational

model, Formal definition of a relation, The codd commandments

Unit 3- Normalization: Functional dependency, Normalization, First normal

form, Second normal form, Third normal form, Boyce-codd normal

form, Multi-valued dependency, Fifth normal form.

BLOCK 3 Introduction to SQL

Unit 1- Structured Query Language: Introduction of SQL, DDL statements,

DML statements, View definitions, Constraints and triggers, Keys and

foreign keys, Constraints on attributes and tuples, Modification of

constraints, Cursors, Dynamic SQL

Unit 2- Relational Algebra: Basics of relational algebra, Set operations on

relations, Extended operators of relational algebra, Constraints on

relations.

Unit 3- Management Considerations: Introduction, Objectives, Organisational

resistance to DBMS tools, Conversion from an old system to a new

system, Evaluation of a DBMS, Administration of a database

management system