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

Quizplus · Accepted Answer

Storing data for each field in only one table (excluding the common field) is the best way to avoid data redundancy in the database. This can be achieved by creating tables for each entity (such as items, sellers, and sales) and linking them through common fields (such as seller code). This approach ensures that each piece of data is stored only once in the database, improving data integrity and reducing the potential for errors. The other choices are not appropriate for avoiding data redundancy. Storing data for each field in multiple tables (excluding the common field) would result in duplicated data, creating redundancy. Creating a composite primary key (including the common field) would not necessarily prevent data redundancy, as it only identifies a unique record in a table, not across tables. Changing field properties for all fields to require data input would enforce data entry but would not prevent redundancy.

Syed and Marino Li Own a Small Furniture Consignment Shop