Chapter 4 Entity Relationship Modeling

A large entity relationship model (ERM) diagram was presented to management by the relationships between each entity was hard to understand visually, especially with dashed lines. If using the Crow's Foot model to depict the relationships, what other actions could be done to the ERM to make it more understandable in terms of number of occurrences in the related entities?

Notate the cardinality next to each table

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

False

If a database designer had to determine the amount of revisions required to plan the completion of the database design, how many iterations would most likely take to account for all operational requirements in the database?

Many

In an ERD that say DOCTOR writes PRESCRIPTION, a PATIENT receives a PRESCRIPTION, and a DRUG appears in a PRESCRIPTION, it is mostly portraying what type of relationship degree?

Ternary

Attribute examples such as STU_LNAME, STU_FNAME, and ROM_NUMBER would apply to one entity.

False

If a college had professors who are not always assigned a class, but created classes would require one professor, then what is the relationship of the PROFESSOR table to the CLASS table?

Mandatory

The marketing team is not able to distinguish customers in a specific city because the CUSTOMER table is too compact. The table's attributes must be broken down to make the customer's city a groupable query. Which of the following attributes should be simplified to improve queries for the CUSTOMER table?

ADDRESS

When a company reorganizes its executive branch so executives can manage more than one division, the employee database will need to update its relationship between the EXECUTIVE and DIVISION tables to which of the following?

1:1 to 1:M

Connectivities and cardinalities are established by concise statements known as business rules.

True

If a college with a department called Research must also offer courses to its students, just like all other departments that offer courses, then what type of relationship would a COURSE have to a DEPARTMENT in an entity relationship diagram (ERD)?

Mandatory

If TEAM and PLAYER have a mandatory relationship where PLAYER has a cardinality expressed as (6,12), which of the following is true about the TEAM object?

Team must have a minimum of 6 players

When designing an ERD segment where a DEPARTMENT must have one or more PROFESSORs assigned to it, but the DEPARTMENT can only be chaired by one PROFESSOR, how would the "chairs" relationship be visualized on the DEPARTMENT table?

Optional