1.
Write the candidate keys (type answer in lowercase)
Acct_id
Cust_id
State_code
Bal
100
C1
AZ
10000
200
C2
CA
65675
423
C1
MN
45646
111
C3
AZ
456456
100
C6
MN
65675
800
C2
TX
12133
500
C3
IL
123123
2.
Write the primary key (type answer in lowercase)
Acct_id
Cust_id
State_code
Bal
100
C1
AZ
10000
200
C2
CA
65675
423
C1
MN
45646
111
C3
AZ
456456
100
C6
MN
65675
800
C2
TX
12133
500
C3
IL
123123
3.
The number of Fully FD’s >= No of FD’s in a relation
4.
When a relation is in 3NF implies the relation does not have any insert anomalies
5.
Foreign key should be unique
6.
A relation is in 2NF implies all the determinants should be primary key
7.
{ C1, C2 } -----> { C3} implies C1, C2 dependent on C3
8.
No of unique keys >= No of primary keys in a relation
9.
A NOT NULL constraint can have duplicate values
10.
C1----> C5 then what is determinant and dependent here?
A. 
C1 Determinant C2 Dependent
B. 
C2 Determinant C1 Dependent
C. 
D. 
E. 
11.
Referential integrity should be maintained for each table in RDBMS
12.
A relation is in nNF implies it should be in (n-1)NF
13.
FD is also called left irreducible dependency
14.
Normal forms applied at the logical level
15.
If a column is a candidate key then it should be a super key
16.
If a relation is in 2NF means update anomaly is eliminated
17.
In a table If a primary key is composite then implies foreign key in that table is also composite
18.
A table can have more than one foreign keys
19.
In a relation all functional dependents should become a fully functional dependencies implies
A. 
All the determinants are candidate keys
B. 
All determinants consists of only one column
C. 
D. 
There are more than one candidate key
20.
Dependent is Primary key implies
A. 
There are more than one candidate key
B. 
The relation contains full FD's
C. 
There are more than one alternative keys
D. 
There is only one super key
21.
The above relation is in --------------
A. 
B. 
C. 
D. 
22.
Is the relation is in 3NF?
23.
What is the attribute/s which acts as both determinant and dependent?(Type your answer in lower case)
24.
Does the below table design contains any insert anomoly
movie_id
movie_name
Director_id
Dir_name
M1
ABC
D1
KKK
M2
DEF
D2
EEE
M3
AAA
D1
LLL
M4
BBB
D3
YYY
M5
CCC
D5
QQQ
M6
DDD
D4
MMM
M7
EEE
D5
PAS
25.
Ship(BoatId, NbrOfPools, YearMade, Tonage, CompanyId, CompanyName)
The only functional dependencies for this table are: BoatId --> NbrOfPools, YearMade, Tonage, CompanyId, CompanyName CompanyId --> CompanyName CompanyName --> CompanyId Which Normal form is the Ship table in?
A. 
B. 
C. 
D. 
E.