Quiz: Basic Mapping: The Transformation Process

1. In a physical data model, a relationship is represented as a:
Column
Primary Key
Unique Identifier
Foreign Key (*)

2. Why would this table name NOT work in an Oracle database?
2007_EMPLOYEES
Numbers cannot be incorporated into table names
Table names must start with an alphabetic character (*)
Underscores “_” are not allowed in table names
None of the above

3. The transformation from an ER diagram to a physical design involves changing terminology. Relationships in the ER diagram become __________ , and primary unique identifiers become ____________.
Foreign keys, primary keys (*)
Primary keys, foreign keys
Foreign keys, mandatory business rules
Foreign keys, optional business rules

4. The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ , and attributes become ____________.
Columns, Tables
Tables, Columns (*)
Foreign Keys, Columns
Tables, Foreign Keys

5. In a physical data model, an entity becomes a _____________.
Attribute
Table (*)
Constraint
Column

6. Attributes become columns in a database table. True or False?
True (*)
False

7. In an Oracle database, why would the following table name not be allowed ‘EMPLOYEE JOBS’?
The database does not understand all capital letters
EMPLOYEE is a reserved word
JOBS is a reserved word
You cannot have spaces between words in a table name (*)