Attempt all the problems.
Section-A
problem1) 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 ex.
problem2) What do you mean by Database Design? Distinguish between Physical and Logical Design.
problem3) Describe Database Management Life Cycle taking an ex.
problem4) prepare 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 problems:
problem5) Reprepare this query without using the HAVING clause.