Database Engineering Lab

 

Class & Semester

:

T. Y. B.Tech (Computer Science and Technology)   Part III, Sem VI

 

Course Title

:

Database Engineering Lab

Course Code: 

:

CS324L

Teaching Scheme (Hours)

:

2 hr /week=2x13= 26 hrs

Credits

:

01

Evaluation Scheme (Marks)

:

IPE

IOE

:50

:

50

 

EPE

 EOE

:50

:

50+50= 100

Duration of Exam (in case of External Evaluation)

:

3 hrs

Revision: 

:

Third

Month

:

June 2018

 

Pre-requisites

:

 

The prerequisite for this course is basic knowledge of database engineering and programming.

Type of Course

:

Practical

Course Domain  

:

Core (Database , SQL , Transactions , Recovery)

Skills Imbibed

:

Cognitive

Course Assessment Methods:

Student is evaluated during Internal Oral Examination and External Oral Examination.

Course Objectives:

1.      To describe a sound introduction to the discipline of database management systems and to give foundation for ER Diagram and the usage of relational algebra.

2.      To introduce the concepts of basic SQL as a universal Database Query language.

Construct simple and moderately advanced database queries using Structured Query Language (SQL).

3.      To enable the design of an efficient database design principles using normalization concepts.

4.      To enable students to create indexes for databases.

5.      Design and implement a small database project.

Course Outcomes:

1.      Construct problem statements for real life applications and design a database for the same.

2.      Design ER model for real life applications and to construct queries with Relational Algebra. 

3.      Create and populate queries using SQL to query, update and retrieve information from the Database.

4.      Analyze and apply concepts of normalization to existing database schema. 

5.      Design and Implement indices for a database.

6.      Design and Implement concurrency control protocol and database recovery protocol.

Practical covered

:

 

1.      Draw ER diagrams for different schemas & Convert them into tables (Assume any suitable schema). Apply normalization. Display constraints.

2.      Study of SQL.

3.      Design the relational database for any of the ER Model from assignment No.1 using SQL.

4.      Insert and Modify Database: Implement queries to insert, update data in tables created in assignment 3 and store data in separate File / Table.

5.      View Data: Design queries to view and retrieve table data.

6.      Canonical cover & Closure: For given set of functional dependencies to find canonical cover & closure.

7.      B+ Tree Indexing Technique: Write program to implement B+ Tree Index.

8.      Dynamic Hashing Technique: Write program to implement Dynamic Hashing on the created data.

9.      Concurrency Control: Write program to simulate any one concurrency control Protocol.

10.  Database Logs: Write program to create logs of the activities of assignment 3 & 4. Choose either Immediate Log or Deferred Log.