Multiple Choice
Case-Based Critical Thinking Questions Case 2-1
Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database:
∙ artist
∙ song and year
∙ client name
∙ client address
∙ client contact information
∙ vendor
∙ purchases
∙ equipment
∙ equipment inventory and rental
Given the information Akae would like to include in his database, how many tables would be optimal if similar information is grouped into tables?
A) 5
B) 4
C) 3
D) 2
Correct Answer:

Verified
Correct Answer:
Verified
Q8: Which data type would be most logical
Q10: The Address Quick Start selection adds a
Q38: A relationship between Access tables that is
Q38: Which data type would be the best
Q56: Explain how a one-to-many relationship is created
Q58: A field in an Access database table
Q63: Identify the letter of the choice that
Q66: Identify the letter of the choice that
Q70: What is the default setting for the
Q93: <u>Relationship integrity</u> is a set of rules