231
Page views
6
Files
2
Videos
3
R.Links

Icon
Syllabus

UNIT
1
Database System Architecture - Basic Concepts

Data System, Operational Data, Data Independence, Architecture for a Database System, Distributed Databases, Storage Structures : Representation of Data. Data Structures and Corresponding Operators: Introduction, Relation Approach, Hierarchical Approach, Network Approach.

UNIT
2
Relational Approach :

Relational Data Structure : Relation, Domain, Attributes, Key Relational Algebra - Introduction, Traditional Set Operation. Attribute,Attribute names for derived relations - Special Relational Operations

UNIT
3
Embedded SQL: Introduction

Operations not involving cursors, involving cursors – Dynamic statements, Query by Example – Retrieval operations, Built-in Functions, update operations - QBE Dictionary. Normalization : Functional dependency, First, Second, Third normal forms, Relations with more than one candidate key, Good and bad decomposition.

UNIT
4
Hierarchical Approach

IMS data structure - Physical Database, Database Description- Hierarchical sequence - External level of IMS : Logical Databases, the program communication block IMS Data manipulation : Defining the Program communication Block : DL / 1 Examples.

UNIT
5
Network Approach

Architecture of DBTG System. DBTG Data Structure : The set construct, Singular sets, Sample Schema, the external level of DBTG – DBTG Data Manipulation.

Reference Book:

1. Abraham Silberschatz, Henry F Korth- Database Systems Concepts, fifth Edition 2006 2.Bipin C Desai - An introduction to Database Systems,galgotia publication 7th edition,1991

Text Book:

C.J.Date - An introduction to Database Systems, Seventh Edition 2007.

 

Print    Download