PAPER#1View more random threads:
- MTH101 mid term current paper spring fall December 2011
- cs607 mid term current subjective paper December 2011
- mth301 midterm paper subjective type on 27th november, 2011
- cs402 mid term current paper subjective fall 4 December 2011
- CS101 Midterm papers current fall December 2011
- fin621 mid term current paper fall 4 December 2011
- cs506 mid term current paper fall 4 December 2011
- mgt603 mid term current subjective paper fall December 2011
- cs610 full mid term current paper fall 4 December 2011
- cs507 current mid term subjective paper fall 2011
1) what is minimum cardinality
2)write a note on Relational Algebra
3)what is cross matrix
4)write 5 function of relational table
Mcqs are mostly from past paper
PAPER#2
Total Marks = 36
MCQs = 16 (01 Mark each)
One long question = 05 Marks
03 long questions = 03 Marks
03 Long questions = 02 Marks
Describe with example function of Union Operation in relational
algebra (05 Marks)
Describe with example Refrential integrity constraints (03 Marks)
Describe functional dependency (03 Marks)
Give atleast 02 benefits of Normalization (02 Marks)
What is Data Definition Language (DDL) ? (02 Marks)
What is data type? (02 Marks)
PAPER#3
CS403-Data Base management
MCQ’s =20 Mostly form past paper’s
Sponsored Links
Q21:-what do you know about partial dependency? (2)
Q22:-Define domain of an attribute? (2)
Q23:-Define relationship type? (3)
Q24:-Describe shortly “ the difference Operation “ in relational
algebra? (3)
Q25:-Explain the salient features of foreign key with help of example?
(5)
Q26:-Consider the relation R with four attributes A,B,C and D and the
functional dependencies
(A,B)->(C,D) and C->D
a). The above relation is normalized relation upto which normal
form.
b).Write the PK of relation R. (5)
There are currently 1 users browsing this thread. (0 members and 1 guests)