IS07
Database
Management
(For
CNM Cases)
Assignment – II
Assignment Code: 2016IS07A2 Last
Date of Submission: 30th April 2016
Maximum
Marks: 100
Attempt all the questions. All the questions are compulsory and
carry equal marks.
Section-A
1. What
is normalization? Explain the advantages of normalization. Explain the first
normal Form (1NF), second normal form (2NF)
and the third normal form (3NF) with an example.
2. What do you understand by Database Design?
Differentiate between Physical and Logical Design.
3. Explain Database Management Life Cycle
taking an example.
4. Write short note on:
a.
Object Oriented Database
b.
Data Warehousing
Section-B
Case
Study
Assume you are given the following relations:
Take(StudentID,
CourseID)
RequiredForGraduation(CourseID)
The Take
relation lists IDs of students and IDs of courses taken by the students. The RequiredForGraduation relation lists the
courses every student must take to graduate. The following division query finds
the 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:
5. You
have an allergy to the HAVING clause. Rewrite this query without using the
HAVING clause.
No comments:
Post a Comment