Consider the relation student(sno, sname, cname, cno) where (sno, cno) or (sname, cname) are
candidate keys. There are functional dependencies within the keys.
The highest normal form whose requirements this relation satisfies is:
A -
1NF
B -
2NF
C -
3NF
D -
BCNF
2-
For a table to be in first normal form (1NF), it must
A -
No have any foreign keys.
B -
Have at least one foreign key.
C -
Not have any repeating groups.
D -
Have a composite primary key.
3-
Let R be a relation with attributes (A,B,C,D,E,F) and let the following functional dependencies hold.
A -> B
A -> C
CD -> E
CD -> F
B -> E
Given the above functional dependencies, which of the following functional dependencies does not
hold:
A -
A -> E
B -
CD -> EF
C -
AD -> F
D -
B -> CD
4-
Which of the following is true about a key (CADIDATE KEY)?
A -
It may be unique.
B -
It may be non-unique.
C -
In may identify more than one row.
D -
All of the above
5-
Which of the following is not true about primary keys?
A -
Primary keys cannot be null.
B -
Primary keys must be unique.
C -
Primary keys must be a single attribute.
D -
Primary keys are used to represent relationships.
6-
STUDENT (SID, StudentName, Major, AdvisorID)
ADVISOR (AdvisorID, AdvisorName, Office, Phone)
Given the relations above such that each student is assigned to one advisor, which of the following is
true?
A -
SID is both a primary key and a foreign key.
B -
AdvisorName is a determinant.
C -
AdvisorID is a foreign key.
D -
Phone is a candidate key.
7-
A functional dependency is a relationship between or among:
A -
Tables
B -
Relations
C -
Rows
D -
Attributes
8-
One important relational design principle is that:
A -
every candidate key must not be a determinant.
B -
every determinant must be functionally dependent on the primary key.
C -
every determinant must be a candidate key.
D -
every primary key must be functionally dependent on every determinant.
9-
The first step of the normalization process is to:
A -
identify all the candidate keys of a relation.
B -
identify all the functional dependencies of a relation.
C -
identify all the determinants of a relation.
D -
split the relation into two or more new relations.
10-
Which two of the following are primary aims of normalisation?
A -
decompose large relations into smaller ones
B -
avoid data redundancies; avoid certain update, insertion and deletion anomalies