Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases In Action

Authors: Dave Bechberger, Josh Perryman

1st Edition

1617296376, 978-1617296376

More Books

Students also viewed these Databases questions