Question

Question 1: Consider the following EERD and answer the questions mentioned below. (3x10 = 30 Marks)

a) Transform the above diagram in the form of relations. Mention column names and constraints only, not

values. Discuss why it does or does not need normalization.

b) Write a query to display the following attributes.

SSN Name Salary Rank

c) Create a trigger in SQL on generalized table “Employee” & “Student” to automatically insert values of

primary key in their respective specialized tables’ foreign key. Depending on the type, the values must be

inserted in the relevant table only​

Answer 1

Explanation:

a trigger in SQL on generalized table “Employee” & “Student” to automatically insert values of

primary key in their respective specialized tables’ foreign key. Depending on the type, the values must be

inserted in the relevant table.