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

Question

Quizplus · Accepted Answer

A logical way to group the similar information into tables could be:
1. Artists and songs (including year of release) table
2. Clients table (including name, address, and contact information)
3. Purchases table (including client and vendor information)
4. Equipment table (including inventory and rental information)
Therefore, four tables would be optimal for Akae's database.