A database designer set the CRS_CODE attribute as the primary key to the CLASS table. If no other changes are made, how many composite identifiers does the table have?
Zero
A database designer set the CRS_CODE attribute as the primary key to the CLASS table. If no other changes are made, how many composite identifiers does the table have?
Zero
If CUSTOMER and INVOICE is classified as a 1:M and one direction would specify that a CUSTOMER may generate many INVOICEs, what would be true of the opposite direction?
Each INVOICE is generated by one CUSTOMER
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
When designing a college ERD where the PROFESSOR entity connects to other entities, its relationship to SCHOOL (e.g., School of Business) would most likely be expressed as which of the following?
a.
PROFESSOR chairs a SCHOOL.
b.
PROFESSOR teaches a SCHOOL.
c.
PROFESSOR operates a SCHOOL.
d.
PROFESSOR is dean of SCHOOL
PROFESSOR is dean of SCHOOL
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?
b. (1,1)
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
Starting with the objects PROFESSOR, CLASS, ROOM, how would a database begin building a diagram showcasing their relationship between each other?
c. Create a binary relationship
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 CLASS is optional
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?
a. two parent entities
When a student's grade point average (GPA) attribute has a domain of (0,4), the GPA can hold ____ possible values.
many
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?
b. Notate the cardinality next to each table.
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 database designers must account for dependents when an EMPLOYEE table already exists, what other entity would the ERD require so that the database reflects the operational needs and processes for its employees?
Additional entity for DEPENDENTs
If a weak relationship is required between COURSE and CLASS, then the CLASS object must have which of the following?
one foreign key and one primary key
If a PROFESSOR can teach up to 4 CLASSes, the cardinality of CLASS should be expressed as which of the following?
(1,4)
