Question: 1. When configuring a relational database to show that a PROFESSOR can to teach multiple CLASSes, and that a CLASS can have only one PROFESSOR,

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

a.

Entity name

b.

Attribute constraints

c.

Relationship strength

d.

Connectivity classification

2. In a COURSE and CLASS relationship if the CLASS object is given a cardinality of (0,N) then which of the following would be true?

a.

a COURSE is mandatory

b.

a COURSE is optional

c.

a CLASS is mandatory

d.

a CLASS is optional

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

a.

ENROLL

b.

COURSE

c.

CRS_CODE

d.

SEMESTER

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

a.

CAR_PART

b.

SS_NUMBER

c.

COLLEGE_DEGREE

d.

CAR_COLOR

5. Although a student's registration form may list information gathered from the COURSE, CLASS, BUILDING, and ROOM table, which of the following would be the most accurate phrase describing these table's relationship with each other in an UML class diagram?

a.

a CLASS uses a ROOM in a BUILDING

b.

a COURSE generates CLASSes in a BUILDING

c.

COURSEs in a BUILDING have ROOMs

d.

CLASSes in a BUILDING has multiple ROOMs

6. A large entity relationship model (ERM) diagram was presented to management but 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?

a.

Set the primary keys to a bold font.

b.

Label the foreign keys as "FK."

c.

Notate the cardinality next to each table.

d.

Draw solid lines between each entity.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!