1. In a physical data model, a relationship is represented as a:
Foreign Key (*)
2. Why would this table name NOT work in an Oracle database?
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 ____________.
Tables, Columns (*)
Foreign Keys, Columns
Tables, Foreign Keys
5. In a physical data model, an entity becomes a _____________.
6. Attributes become columns in a database table. True or 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 (*)