CS403 – Database Management Systems Assignment No2 Fall 2016
CS403 – Database Management Systems Assignment No2
Question: (15 Marks)
As you all know that Virtual University of Pakistan provides an interface to the student for making their own exam date-sheet according to their convenience. In date-sheet interface, students are required to enter their VU allocated ID and password to get logged in the system. In next step, students are required to select exam city/center of their choice before further proceedings. After that, a list of students’ registered courses will be displayed and students will select the date and time of exam for each course to finalize their date-sheet. Also, note that students and exam data is managed by a system administrator in the date-sheet system.
Now, by keeping the above scenario in your mind, you are required to:
• Identify all the Entities along with proper attributes. [5 Marks]
• Make an ER Diagram of the system showing all entities, their attributes and relations among the entities.[10 Marks]
NOTE: Do not put any query on MDB about this assignment, if you have any query then email at [email protected]
Deadline: Your assignment must be uploaded/submitted on or before 2nd December 2016.