Kuis 2 Database Design

What are the two main rules that subtypes must follow in an Entity Relationship Diagram?

• Complete and Overlapping

• Exhaustive and Mutually Exclusive

• Independent and Dependent

• Primary and Secondary

Which of the following is an example of a structural business rule?

• "Students must have studied algebra before enrolling in trigonometry"

• "All teachers at our school must possess a valid teaching certificate"

• "Approval for travel requests must be signed by the employee's manager"

• "Any employee whose overtime exceeds 10 hours per week must be paid 1.5 times the hourly rate"

In the context of relationship transferability, which relationship would be considered nontransferable?

• A student moving from one study group to another

• An employee being transferred from one department to another

• A receipt being issued to a student for tuition payment

• A class being reassigned to a different teacher

How is a nontransferable relationship represented in an ERD?

• With a solid line

• With a dashed line

• With a diamond symbol on the relationship line

• With a circle at the end of the relationship

Which type of relationship is most common in Entity Relationship Models?

• One-to-One (1:1)

• One-to-Many (1:M)

• Many-to-Many (M:M)

• Self-referencing relationships

What happens to Many-to-Many relationships in the final stages of database modeling?

• They remain as M:M relationships

• They are converted to 1:1 relationships

• They are resolved using intersection entities

• They are eliminated from the model

In a resolved Many-to-Many relationship, what typically forms the unique identifier (UID) of the intersection entity?

• A new artificial key

• The combination of foreign keys from the originating entities (barred relationships)

• A sequential number

• The primary key of one of the original entities

Which of the following keywords during client interviews would indicate a "CREATE" function in CRUD analysis?

• VIEW, REPORT, PRINT

• CHANGE, MODIFY, ALTER

• INPUT, ENTER, LOAD, RECORD

• DISCARD, REMOVE, DELETE

What does CRUD stand for in database analysis?

• Create, Read, Update, Delete

• Create, Retrieve, Update, Delete

• Copy, Read, Update, Design

• Create, Report, Update, Design

Consider the following ERD scenario: COUNTRY → TOWN → PERSON. Which relationship would be considered redundant?

• COUNTRY to TOWN

• TOWN to PERSON

• COUNTRY to PERSON (direct relationship)

• None of the relationships are redundant