Homework 1
1. A relational database consists of a collection of
a) Tables
b) Fields
c) Records
d) Keys
2. A ________ in a table represents a relationship among a set of values.
a) Column
b) Key
c) Row
d) Entry
3. The term attribute refers to a ___________ of a table.
a) Record
b) Column
c) Tuple
d) Key
4. For each attribute of a relation, there is a set of permitted values, called the ________ of that
attribute.
a) Domain
b) Relation
c) Set
d) Schema
5. Database __________ which is the logical design of the database, and the database _______
which is a snapshot of the data in the database at a given instant in time.
a) Instance, Schema
b) Relation, Schema
c) Relation, Domain
d) Schema, Instance
6. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________
a) Relations, Attribute
b) Attributes, Relation
c) Tuple, Relation
d) Tuple, Attributes
7. A domain is atomic if elements of the domain are considered to be ____________ units.
a) Different
b) Indivisbile
c) Constant
d) Divisible
8. The tuples of the relations can be of ________ order.
a) Any
b) Same
c) Sorted
d) Constant
9. Which one of the following is a set of one or more attributes taken collectively to uniquely identify
a record?
a) Non-key Attributes
b) Sub key
c) Super key
d) Foreign key
10. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
a) NAME
b) ID
c) CITY
d) CITY, I
