Case-Based Critical Thinking Questions Case 2-3
Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information. Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information. Using appropriate database design guidelines, answer the following questions.
Based on the information to be included in the database, what is the best way to avoid data redundancy in the database?
A) store data for each field in only one table (excluding the common field)
B) store data for each field in multiple tables (excluding the common field)
C) create a composite primary key (including the common field)
D) change field properties for all fields to require data input

Question

Case-Based Critical Thinking Questions Case 2-3
Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information.  Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information.  Using appropriate database design guidelines, answer the following questions.
Based on the information to be included in the database, what is the best way to avoid data redundancy in the database?
A) store data for each field in only one table (excluding the common field)
B) store data for each field in multiple tables (excluding the common field)
C) create a composite primary key (including the common field)
D) change field properties for all fields to require data input

Quizplus · Accepted Answer

To avoid data redundancy, it is best to store data for each field in only one table (excluding the common field). This will prevent duplication of information and ensure efficiency in data storage and retrieval. Creating a composite primary key and changing field properties to require data input do not address the issue of data redundancy. Storing data in multiple tables may also lead to duplication of information and make it difficult to manage the database.