Chapter 2:

A tuple is a column of a relation?
1. True
2. False
The domain for the attribue 'Sex' in the entity STUDENT could be the single character string of either 'M' or 'F'. True or False?
1. True
2. False
Which of the following is not a property of a relation?
1. Relation names are distinct
2. A cell of a relation can contain repeating information
3. Attribute names are distinct
4. Attribute values are all from the same domain
5. The order of attributes is not significant
6. Each tuple is distinct - no duplicates are allowed
7. The order of tuples is not significant
The Relational Algebra operator ‘Project’ extracts a horizontal subset from a specified relation. True or false?
1. True
2. False
NULL values in numeric fields are normally treated as zeros. True or false?
1. True
2. False
A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?
1. True
2. False
A foreign key is an attribute (or set of attributes) in one entity that appears as a non-key attribute in some other entity. True or false?
1. True
2. False
Relationships are made possible through candidate keys. True or false?
1. True
2. False
When two relations are linked together the foreign key is placed on the _________ side of the relationship. What is the missing word?
1. many
2. one
If a Teacher has a many-to-many relationship with Student, then each Teacher instance must relate to 1 or more Student instances. True or false?
1. True
2. False

Chapter 2:

Test Yourself on MIS