06-03-2013, 03:03 PM
DBMS QUESTION
DBMS QUESTION.doc (Size: 29.5 KB / Downloads: 21)
Purpose:
To develop an understanding of database management system and abilities to apply the concept in real world.
Objectives:
1. To provide the students an understanding about the implications of DBMS in practical cases.
2. To provide a platform where students can apply the concepts of data base in real scenarios and understand its importance.
3. To make the students aware about the management of huge data bases in organizations and people involved in its maintenance.
QUESTIONS:
1. Study the Database Management process of “Delhi University” or RDIAS portal and prepare a report how the respective institution has been able to manage such a huge database. Also, mention the active players involved in its maintenance.
2. Choose any organization and prepare its ER diagram displaying all the relationships amongst the entities. Also, explain the type of data model followed by that organization to create its database.
3. Suppose you are the Database Administrator of an organization dealing in the manufacturing of spare parts of luxury cars. How will you design your organization’s database with the help of your team? Also, mention how the model that you have opted for is helpful for your organization.