| 1 |
Introduction Database Concepts |
3 |
| 1.1 |
Introduction, Characteristics of databases, File system v/s Database system,
Data abstraction and data Independence, DBMS system architecture,
Database Administrator |
|
| 2 |
Entity–Relationship Data Model |
6 |
| 2.1 |
The Entity-Relationship (ER) Model: Entity types: Weak and strong entity
sets, Entity sets, Types of Attributes, Keys, Relationship constraints:
Cardinality and Participation, Extended Entity-Relationship (EER) Model:
Generalization, Specialization and Aggregation |
|
| 3 |
Relational Model and relational Algebra |
8 |
| 3.1 |
Introduction to the Relational Model, relational schema and concept of keys.
Mapping the ER and EER Model to the Relational Model, Relational
Algebra-operators, Relational Algebra Queries. |
|
| 4 |
Structured Query Language (SQL) |
6 |
| 4.1 |
Overview of SQL, Data Definition Commands, Integrity constraints: key
constraints, Domain Constraints, Referential integrity , check constraints,
Data Manipulation commands, Data Control commands, Set and string
operations, aggregate function-group by, having, Views in SQL, joins,
Nested and complex queries, Triggers |
|
| 5 |
Relational-Database Design |
6 |
| 5.1 |
Pitfalls in Relational-Database designs, Concept of normalization, Function
Dependencies, First Normal Form, 2NF, 3NF, BCNF. |
|
| 6 |
Transactions Management and Concurrency and Recovery |
10 |
| 6.1 |
Transaction concept, Transaction states, ACID properties, Transaction
Control Commands, Concurrent Executions, Serializability-Conflict and
View, Concurrency Control: Lock-based, Timestamp-based protocols,
Recovery System: Log based recovery, Deadlock handling |
|
