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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started