Question: A business is using an Access table named STORES to manage information regarding its stores within the 50 states. Particularly, the table stores information regarding

A business is using an Access table named STORES to manage information regarding its stores within the 50 states. Particularly, the table stores information regarding Store ID (each store has a unique Store ID), the State the store is located in, and regional managers who oversee the stores. The following shows 3 sample rows from the table:

STATE REGIONAL_MANAGER STORE_IDS
NY Alice 1,3,5
NJ Bob 2,4
CT Carol 6

Comment on any design flaws of this table from a relational design perspective. If there are issues, suggest a solution.

A business is using an Access table named STORES to manage the information about its stores. A sample data below suggests that Alice and Bob are employees in Store #1, which is located in 1 Main St. NJ, and Carol works in Store #2 that is located in NY.

STORE_ID STORE_ADDRESS EMPLOYEE GENDER SALARY
1 1 Main St. NJ Alice F 48000
1 1 Main St. NJ Bob M 35000
2 23 Fulton St. NY Carol F 39000

Comment on any design flaws of this table from a relational design perspective. If there are issues, suggest a solution.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!