Wednesday, December 8, 2010

CS403 Mid Dec 2010 Paper

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 paper26 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:-

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)

No comments:

Post a Comment