CS403 Mid Term Current Paper (Dec 2010)
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..