Attempt all the questions.
Section-A
Question1) What is normalization? Describe the advantages of normalization. Describe the first normal Form (1NF), second normal form (2NF) and the third normal form (3NF) with the suitable example.
Question2) What do you mean by Database Design? Distinguish between Physical and Logical Design.
Question3) Describe Database Management Life Cycle taking an example.
Question4) Write brief note on:
a) Object Oriented Database
b) Data Warehousing
Section-B
Case Study
Suppose you are given the following relations:
Take(StudentID, CourseID)
RequiredForGraduation(CourseID)
Take relation lists IDs of students and IDs of courses taken by the students. The RequiredForGraduation relation lists courses every student should take to graduate. The following division query finds students who have satisfied all the requirements for graduation.
SELECT StudentID
FROM Take AS T, RequiredForGraduation AS R
WHERE T.CourseID = R.CourseID
GROUP BY T.StudentID
HAVING COUNT(T.CourseID) = (SELECT COUNT(CourseID) FROM RequiredForGraduation);
Case Questions:
Question5) Rewrite this query without using the HAVING clause.