Lovely Professional University 2011 B.Tech Computer Science and Engineering Database management system-assignment - Question Paper

Assignment – 1

PART – A

1. Design an ER diagram for an IT training group database that will meet the info needs for its training program. Clearly indicate the entities, relationships and the key constraints. The description of the environment is as follows:

The company has 12 instructors and can handle upto 100 trainees for every training session. The company offers five Advanced technology courses, every of which is taught by a team of two or more instructors every instructor is assigned to a maximum of 2 teaching teams or may be assigned to do research every trainee undertakes 1 Advanced technology course per training session.

2. Identify at lowest five DBMS successfully running in market and compare their features

3. How the different components of database management system interact for transaction Processing.

PART – B

4. Comment on the significance of administration of a database system. elaborate the different functions associated with database administration?

5. discuss the concepts of Generalization and Specialization with examples

Earning:   Approval pending.