CS403 Mid Term Current Paper (Dec 2010)
Friday, December 03, 2010 Posted In .Midterm Dec 2010 Edit ThisQ. explain the difference between the super type and primary key 5maks
Q. what is data type 2
Q explain the minimum cadnality 3
bus ya he yad hain
26 questions
20 objectives just 2 or 3 from past
6 questions
1. what is the purpose to use the relational data model? 2marks
2. what is relationship set ? 3 marks
3. explain union operation in relational algebra? 5 marks
4. what is secondary key give an exampel also ? 5 marks
5. what is partial dependency ? 2 marks
6.what are data anomalies? 3 marks
total questions 26
21 mcqs
mostly mcqs from lec 13 to 20
1) two types of completeness constraints ? (2)
2) what major problem can acure if we dont normalize a relatin into 1st normal form ? (2)
3) write the situation in which a partial completeness constraints accurs ?(3)
4) define candidate key wd example (5)
5) 5 properties of rational table ? (5)
dont depend on past papers..