Question 1: [10 Marks]
Consider the below mentioned ER diagram containing 5 entities (Student, Course, Instructor, Department, and Degree).
Each entity has at least the following attributes:
Student: Student ID, Name, Gender, DOB, Address
Course : Course ID, Course Name, Specialization, Degree program
Instructor: Instructor ID, Instructor Name, Course ID, Course Name, Department Name, Degree program
Department: Department Name, Department Head, Degree program
Degree: Degree Program, Department Name, Campus
There will be total 5 tables (Student, Course, Instructor, Department and Degree) for this ERD.
You are required to draw these 5 tables, fill them with your own particulars (details), and then De-normalize these tables into a single table using the De-normalization techniques you have studied so far.
Note: Deadline for Assignment submission is 4th May 2017.
Wish you best of Luck!
+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)