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
Get step-by-step solutions from verified subject matter experts
