Exam 4: The Relational Model: Advanced Topics

Information-level design is independent of any particular DBMS that the organization will ultimately use.

In an entity-relationship model (ERM) for a many-to-many relationship, what do you call the middle entity that links two other tables?

Access uses Database Design Language (DBDL) to diagram relationships in the Relationship report.

In a database for a health care clinic, a medical specialty is listed only once in the Specialties table, but each specialty may be linked to many doctors in the Doctors table. What type of relationship do the Specialties and Doctors tables have?

Because you cannot directly create a many-to-many relationship between two tables, what must you create to link the tables together?

A(n) _____ is a field that contains unique data for each record in the table but is not used as the primary key field for security or other reasons.

Explain the difference between information-level design and physical-level design.

When the Unique property for an index is set to Yes in Access, every value in the index must be unique.

In the following Database Design Language (DBDL) notation, what does SK stand for? Employees (EmpID, LastName, FirstName, SSN, DeptNum) AK SSN SK LastName, FirstName FK DeptNum à Departments

Which of the following fields would you most likely index but set the index's Unique property to No?