Database Management System
Grade: X Time: 4 hours/week
Total Time: 32 weeks Theory: 51 hours (40%)
Practical: 77 hours (60%)
Course objectives:
After the completion of this course students will be able to:
1. Understand the fundamentals of database design and database systems development
2. Provide the analysis, design and generation of a simple inquiry and update system, using standard RDBMS
3. Give the need for adequate documentation of the system and management of data to ensure that the information
produced is relevant, accurate and maintainable.
4. Use conceptual data analysis methods to produce a logical data model.
Course Contents:
Unit 1: Introduction to Database System Architecture [3 Hours]
1.1. Introduction to Database System, Data Independence, Three Levels of Architecture: External,
Conceptual and Internal, Mappings, Database Administration, DBMS, Data Communication,
Manager, Client-Server Architecture, Distributed Processing, E-R Model, Data Dictionary
Unit 2: Relational Algebra and Relational Calculus [9 Hours]
2.1 Relational Calculus: Introduction, Operators, Syntax, Semantics, Examples, Additional Operators,
Grouping and Ungrouping, Relational Comparisons,
2.2 Relational Algebra: Introduction, Tuple Calculus, Relational Calculus vs. Relational Algebra,
Computational Efficiency, Domain Calculus.
42
Unit 3: Introduction to Relational Database, SQL and Relational Model Basics [9 Hours]
3.1 Relational Database: Introduction, Relational Model and Relations, Optimization. The Catalog, Views,
Transactions
3.2 SQL: Overview, The Catalog, Views, Transactions, Embedded SQL, Relational Model Basics:
Introduction, Domains. Relation Value. Relation Variables. SQL Features
Unit 4: Data Integrity and Views [8 Hours]
4.1 Data Integrity: Introduction, Type constraints, Attribute Constraints, Relvar Constraints, Database
Constraints, State vs. Transition Constraints.
4.2. Views: Introduction, Retrieval and Updates of Views, Snapshots.
Unit 5: Database Design [9 Hours]
5.1 Functional Dependencies: Introduction, Trivial and Non-trivial Dependencies, Closure of a Set of
Dependencies, Closure of a Set of Attributes.
5.2 Data Normalization: Introduction, Non-Loss Decomposition and Functional Dependencies, MVD,
JD, INF, 2NF and 3NF, BCNF, 4NF, 5NF, PJNF, Trigger.
Unit 6: Recovery and Concurrency [9 Hours]
6.1 Transaction Recovery: Introduction, Transaction, Transaction Recovery, System Recovery, Media
Recovery, Two-Phase Commit Protocol.
6.2 Transaction Concurrency: Introduction. Locking Deadlock, Serializability, Isolation Levels, Intent
Locking
Unit 7: Security [4 Hours]
7.1 Introduction, Discretionary Access Control. Mandatory Discretionary Access Control, Statistical
Database, Data Encryption.
43
PRACTICAL
Unit 3: Introduction to Relational Database, SQL and Relational Model Basics [17 Hours]
3.1. Design a Database and create required tables. For e.g. Bank, College Database
3.2. Apply the constraints like Primary Key, Foreign key, NOT NULL to the tables.
3.3. Write a sql statement for implementing ALTER, UPDATE and DELETE
3.4. Write the queries to implement the joins
3.5. Write the query for implementing the following functions: MAX(),MIN(),AVG(),COUNT()
Unit 4: Data Integrity and Views and Unit 5: Database Design [20 Hours]
4.1. Write the query to implement the concept of Intergrity constrains
4.2. Write the query to create the views
4.3. Perform the queries for triggers
4.4. Perform the following operation for demonstrating the insertion, updating and deletion using the
referential integrity constraints
4.5. Write the query for creating the users and their role.
Unit 5: Project work [40 Hours]
The course will be supplemented by project work. The project can involve the design of a schema for a realistic application, and the implementation and coding of the entire application using SQL (and other development tools such as graphical user interfaces or forms packages) on a relational database system (say Oracle)
Reference books:
1. Abraham Silberschatz, Henry F. Korth and S. Sudarshan- “Database System Concepts”, Fourth Edition,
McGraw-Hill, 2002.
2. Ramez Elmasri and Shamkant B. Navathe, “Fundamental Database Systems”, Third Edition, Pearson
Education, 2003.
3. Raghu Ramakrishnan, “Database Management System”, Tata McGraw-Hill Publishing Company, 2003.
4. Hector Garcia–Molina, Jeffrey D.Ullman and Jennifer Widom- “Database System Implementation”- Pearson
Education- 2000.
5. Peter Rob and Corlos Coronel- “Database System, Design, Implementation and Management”, Thompson
Learning Course Technology- Fifth edition, 2003.
6. Date, C.J., An Introduction to Database, 7th Edition, Addison Wesley . 2010
Grade: X Time: 4 hours/week
Total Time: 32 weeks Theory: 51 hours (40%)
Practical: 77 hours (60%)
Course objectives:
After the completion of this course students will be able to:
1. Understand the fundamentals of database design and database systems development
2. Provide the analysis, design and generation of a simple inquiry and update system, using standard RDBMS
3. Give the need for adequate documentation of the system and management of data to ensure that the information
produced is relevant, accurate and maintainable.
4. Use conceptual data analysis methods to produce a logical data model.
Course Contents:
Unit 1: Introduction to Database System Architecture [3 Hours]
1.1. Introduction to Database System, Data Independence, Three Levels of Architecture: External,
Conceptual and Internal, Mappings, Database Administration, DBMS, Data Communication,
Manager, Client-Server Architecture, Distributed Processing, E-R Model, Data Dictionary
Unit 2: Relational Algebra and Relational Calculus [9 Hours]
2.1 Relational Calculus: Introduction, Operators, Syntax, Semantics, Examples, Additional Operators,
Grouping and Ungrouping, Relational Comparisons,
2.2 Relational Algebra: Introduction, Tuple Calculus, Relational Calculus vs. Relational Algebra,
Computational Efficiency, Domain Calculus.
42
Unit 3: Introduction to Relational Database, SQL and Relational Model Basics [9 Hours]
3.1 Relational Database: Introduction, Relational Model and Relations, Optimization. The Catalog, Views,
Transactions
3.2 SQL: Overview, The Catalog, Views, Transactions, Embedded SQL, Relational Model Basics:
Introduction, Domains. Relation Value. Relation Variables. SQL Features
Unit 4: Data Integrity and Views [8 Hours]
4.1 Data Integrity: Introduction, Type constraints, Attribute Constraints, Relvar Constraints, Database
Constraints, State vs. Transition Constraints.
4.2. Views: Introduction, Retrieval and Updates of Views, Snapshots.
Unit 5: Database Design [9 Hours]
5.1 Functional Dependencies: Introduction, Trivial and Non-trivial Dependencies, Closure of a Set of
Dependencies, Closure of a Set of Attributes.
5.2 Data Normalization: Introduction, Non-Loss Decomposition and Functional Dependencies, MVD,
JD, INF, 2NF and 3NF, BCNF, 4NF, 5NF, PJNF, Trigger.
Unit 6: Recovery and Concurrency [9 Hours]
6.1 Transaction Recovery: Introduction, Transaction, Transaction Recovery, System Recovery, Media
Recovery, Two-Phase Commit Protocol.
6.2 Transaction Concurrency: Introduction. Locking Deadlock, Serializability, Isolation Levels, Intent
Locking
Unit 7: Security [4 Hours]
7.1 Introduction, Discretionary Access Control. Mandatory Discretionary Access Control, Statistical
Database, Data Encryption.
43
PRACTICAL
Unit 3: Introduction to Relational Database, SQL and Relational Model Basics [17 Hours]
3.1. Design a Database and create required tables. For e.g. Bank, College Database
3.2. Apply the constraints like Primary Key, Foreign key, NOT NULL to the tables.
3.3. Write a sql statement for implementing ALTER, UPDATE and DELETE
3.4. Write the queries to implement the joins
3.5. Write the query for implementing the following functions: MAX(),MIN(),AVG(),COUNT()
Unit 4: Data Integrity and Views and Unit 5: Database Design [20 Hours]
4.1. Write the query to implement the concept of Intergrity constrains
4.2. Write the query to create the views
4.3. Perform the queries for triggers
4.4. Perform the following operation for demonstrating the insertion, updating and deletion using the
referential integrity constraints
4.5. Write the query for creating the users and their role.
Unit 5: Project work [40 Hours]
The course will be supplemented by project work. The project can involve the design of a schema for a realistic application, and the implementation and coding of the entire application using SQL (and other development tools such as graphical user interfaces or forms packages) on a relational database system (say Oracle)
Reference books:
1. Abraham Silberschatz, Henry F. Korth and S. Sudarshan- “Database System Concepts”, Fourth Edition,
McGraw-Hill, 2002.
2. Ramez Elmasri and Shamkant B. Navathe, “Fundamental Database Systems”, Third Edition, Pearson
Education, 2003.
3. Raghu Ramakrishnan, “Database Management System”, Tata McGraw-Hill Publishing Company, 2003.
4. Hector Garcia–Molina, Jeffrey D.Ullman and Jennifer Widom- “Database System Implementation”- Pearson
Education- 2000.
5. Peter Rob and Corlos Coronel- “Database System, Design, Implementation and Management”, Thompson
Learning Course Technology- Fifth edition, 2003.
6. Date, C.J., An Introduction to Database, 7th Edition, Addison Wesley . 2010
No comments:
Post a Comment
its cool