-
INTRODUCTION TO
DATA BASE SYSTEMS: Overview and History of DBMS. File System Vs
DBMS. Advantages of DBMS. Describing and Storing Data in a DBMS.
Queries in DBMS. Transaction management and Structure of a DBMS.
-
ENTITY
RELATIONSHIP MODEL: Overview of Data Design, Entities, Attributes
and Entity Sets, Relationship and Relationship Sets. Features of the
ER Mode! -Key Constraints, Participation Constraints, Weak Entities,
Class Hierarchies, Aggregation. Conceptual Data Base Design with ER
Mode! - Entity vs Attribllte. Entity vs Relationship. Binary vs
Ternary Relationship and Aggregation vs ternary Relationship.
Conceptual Design for a Large Enterprise.
-
RELATIONAL-ALGEBRA
AND CALCULUS: Relational Algebra Selection and Projection, Set
Operations, Renaming, Joins, Division, Relational Calculus, Expressive
Power of Algebra and Calculus.
-
SQL QUERIES,
PROGRAMMING AND TRIGGERS: The Forms of a Basic SQL Query, Union,
Intersect and Except, Nested Queries, Correlated Nested Queries,
Set-Comparison Operations. Aggregate Operators, Null Values and
Embedded SQL. Dynamic SQL, ODBC and JDBC. Triggers and Active
Databases.
-
SCHEMA
REFINEMENT AND NORMAL FORMS: Introduction to Schema Refinement,
Functional Dependencies. Boyce Codd Normal Forms, Third Normal Form,
Normalization- Decomposition into BCNF, Decomposition into 3-NF.
-
INTERNET
DATABASES: Databases and the Web. Architecture- Application.
Server and Server Side Java, XML-DTDs, XML-QL.
-
OBJECT ORIENTED
DATABASE SYSTEMS: Object. Object Identity and Reference Types.
Inheritance and Data Base Design for ORDBMS. '
Recommended Books:
-
Raghu
Rama Krishnan': Database Management Systems, 2nd ed:, Tata Mc-Graw
Hill.
-
Elmasari
-Fundamentals of Data Base Systems, pearson Education.
-
Silverschatz
KOl1h and Sudarshan -Database System Concepts, 4th ed. Tata Mc-Graw
Hill.
- Gordon C. Everest -Database Management Objectives,
System Functions and Administration. Tata Mc-Graw Hill.
|