1. When writing expressions to perform calculations in queries, table fields are reference by enclosing the field name in ???? 

2. to represent a many-to-many relationship in a relational database, the designer must 

A. combine the two entity tables that share the many-to-many relationships in a single table. 

B. eliminate the many-to-many relationships; such relationships are not permitted. 

C. create three tables, one for each of the entities and a third for the relationship table that includes the primary key of the two entity tables. D. create four tables, each having a one-to-one relationship with the other three tables. 

3. A table that does not include any transitive dependencies 

A. is in third normal form or higher. 

B. cannot be in normal form; all normal forms require at least one transitive dependency. 

C. is in first normal form or higher. 

D. is in second normal form or higher.

Answer rating: 100% (QA)

1 In Microsoft Access when writing expressions to perform qu... View the full answer