CS403 MID 28May2010

Spring_2010_MidTerm_OPKST_CS403_bc080402322

Another Paper:-
total marks 38
16 mcqs
total 23 questions

1) What is the difference between total and partial completeness constraints? (5 marks)

2) write the first normal form. (2 marks)

3) what is the significance of normalization? (3 marks)

4) what are the two types of data dictionaries? (2 marks)

3 aur thay jo yad nhi arhe

Another Paper:-

Today I had my CS403 - Database Management Systems paper.

It had total 22 Questions, out of which

16 MCQs of marks 1 each
2 short questions of marks 2 each
2 short questions of marks 3 each (i'm not sure whether there were 2 short questions of marks 3 each or 3 short questions, but what I remember, there were 2 short questions of marks 3 each)
2 short questions of marks 5 each


Some of the short questions that I remember are:
I do not remember the exact statements of questions, but the concept which was asked in questions is as under:

1. For what purpose do we use Relational Data model?
2. What is the difference between Primary key and unique key with reference to null value?
3. Write two sub-categories of outer join?
Answer: 1. left outer join 2. right outer join
4. attribute and key attribute, give example as well. (I think the question was, what is the difference b/w attribute and key attribute, anyways, I wrote about attribute and key attribute in answer with one example)
5. Explain union? (marks 5) (page # 152 of handouts)
6. What is first normal form? (page # 167 of handouts)