Section 11
(Answer all questions in this section)

  1. In a physical data model, an entity becomes a _____________.

Attribute

  Table 

Constraint

Column



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. 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



  4. Attributes become columns in a database table. True or False?

  True

False



  5. 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



  6. In a physical data model, a relationship is represented as a:

Column

Primary Key

Unique Identifier

  Foreign Key 



  7. 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