CS403 Mid Term Current Paper (Dec 2010)

Thanks to those who share papers:

Q . explain the 3nf 5maks
Q. 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

Another Paper

today paper 
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

Another Paper

mra aaj ka paper 3rd dec

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..