Database Management System slc class 10 syllabus

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)

Evaluation techniques:

S. No. Nature First

Assessment

Second

Assessment

Final

Assessment

Total Pass

Marks

1 Theory 4 12 24 40 40%                                         

2 Practical 6 18 36 60 60%

Total 10 30 60 100 100%

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

7. Elmasri, R. and Navathe, Shamkant B., Fundamentals of Database Systems, 2010, Addison Wesley