Total 26 Question
Held on 07-JUN-2014
20 MCQs = 20x1 Marks
2 Questions each = 2 Marks
2 Questions each = 3 Marks
2 Questions each = 5 Marks
Anaylyse relation (EMPLOY(enpId,empName etc... ))... and tell weathr it is in 2ND
note: it is in 1NF -- 2 marks
Customer (c-no, name, address, city, phone-no)
Case A –
If c-no --> city, phone-no
Then c-no --> city and c-no --> phone-no
Case B –
If c-no --> phone-no and phone-no, address --> city
Then c-no, address --> city
Which of the Inference Rules are applied on the Case A and CaseB?
AxB find krna tha
A= no of week
B =shift
A {Monday,tuseday,Wednesday ‘Thursday,Friday}
B={shift-1 shift-2 shift-shift-3}
Component ER data model ?
Held on 07-JUN-2014
20 MCQs = 20x1 Marks
2 Questions each = 2 Marks
2 Questions each = 3 Marks
2 Questions each = 5 Marks
Anaylyse relation (EMPLOY(enpId,empName etc... ))... and tell weathr it is in 2ND
note: it is in 1NF -- 2 marks
Customer (c-no, name, address, city, phone-no)
Case A –
If c-no --> city, phone-no
Then c-no --> city and c-no --> phone-no
Case B –
If c-no --> phone-no and phone-no, address --> city
Then c-no, address --> city
Which of the Inference Rules are applied on the Case A and CaseB?
AxB find krna tha
A= no of week
B =shift
A {Monday,tuseday,Wednesday ‘Thursday,Friday}
B={shift-1 shift-2 shift-shift-3}
Component ER data model ?