AN 324 Module 4

When configuring a relational database to show that a PROFESSOR can to teach multiple CLASSes, and that a CLASS can have only one PROFESSOR, a simple line is not enough for design reviewers to understand the full relationship on the diagram. What else would make it easier for the reviewer to understand their relationship?

Connectivity classification

Recognizing the entities CLASS and STUDENT in a college ERD, what bridged entity can a database designer add to help ensure each student is assigned their classes for specific courses?

ENROLL

In an entity relationship diagram with objects EMPLOYEE, DEPENDENT, CUSTOMER and PRODUCT, which would be most true about the EMPLOYEE object?

It is a strong entity

When explaining tables such as STUDENT, CLASS, or TEACHER to management as entities, they seem to not grasp the reason for each. What other term would be most acceptable to call these entities so that leadership can understand the reason for their existence in the overall database design?

Object

If a STUDENT entity is related to a bridge entity called ENROLL, and that bridge entity also included an ENROLL_GRADE attribute that is related to another parent entity called CLASS, what would the STUDENT cardinality be?

(1,1)

If a PROFESSOR can teach up to 4 CLASSes, the cardinality of CLASS should be expressed as which of the following?

(1,4)

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 customers' city a groupable query. Which of the following attributes should be simplified to improve queries for the CUSTOMER table?

ADDRESS because it can be further subdivided to yield additional attributes such as ADDRESS_STREET, ADDRESS_CITY, and ADDRESS_STATE.

In a M:N relationship between STUDENT and CLASS at a university, it is possible that a class may start with no students and a student may start with no classes. If a database designer is using the O symbol using the Chen model, what is the designer hoping to establish between these entities?

An optional relationship.

In the early development stage, if a company suggests entities CUSTOMER and MAINTENANCE to a database designer to build a database that will track car repairs, what other entities would a designer want to add to improve the overall design based on operational needs?

CAR and PART

If processing speed was an important requirement for a company when building out a database, what changes can a designer revise in the next database iteration if the current design has more than 95% of tables with a 1:1 relationship?

Combine some tables together

In an entity relationship diagram with objects EMPLOYEE, DEPENDENT, CUSTOMER and PRODUCT, which of the following would be the most appropriate example of a derived entity?

DEPENDENT

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

When a student's grade point average (GPA) attribute has a domain of (0,4), the GPA can hold ____ possible values.

Many

. As a database, _____ relates to activities that make them operate more efficiently in terms of storage and access speed.

Performance tuning

Recognizing the entities PROFESSOR, SCHOOL, and DEPARTMENT, what else can a database designer add that is most appropriate for professors to know which rooms they are assigned to teach in?

ROOM_NUM entity

After looking at the database design, another designer found that the primary keys were not established with a simple underline. Knowing that single-valued attribute can almost always be labeled as primary identities, which of the following attributes would be a good candidate as a primary key for a table?

SS_NUMBER

In an ERD that says 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

When examining an associative entity with a primary key and two foreign keys, what can a database designer review as well to better understand the overall design?

Two parent entities

A database contains how many types of data?

Two: End user data and metadata

When relating SEMESTER and COURSE to an associative entity such as CLASS where a SEMESTER can have many CLASSes and a COURSE can have many CLASSes, then COURSE would have what type of relationship to CLASS?

one to many