Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1: Building Logical ERDs [4 points! Build a Logical ERD using the below business description. Equestrianzone, a family owned business that sells horse products. was

image text in transcribed
1: Building Logical ERDs [4 points! Build a Logical ERD using the below business description. Equestrianzone, a family owned business that sells horse products. was founded in 19115 and has grown to have 8 locations throughout the western United States. Ned Picket, the son of the founder and current owner, has grown tired of the physical papemrork. During a date with a really nice cowgirl he met on FarmersDnly.com, he learned that a database would be just what he needs to get rid of that darned paperwork once and for all. Ned heard the U of Utah has a great Information Systems program and has contacted you to build the data model that will be used for the database. During your conversation with Ned. you learn the following Business Requirements {rules}. As the company has grown. Ned has observed how different regions have different characteristics. For example, costs to procure certain products vary per region, and logistics costs differ as well. Therefore, Ned wants to categorize stores into regions. Each region will have at least 1 store. and possibly many stores. Each store will belong to only 1 region. For regions. Ned wants to track the RegionlD. Name, and a Description. For stores. Ned wants to track the StorelD. Address (StreetAddress. City, State, Zip). and the EmployeelD of the employee who manages the store. Each store must have multiple employees to operate. Each employee works at just 1 store. For employees. Ned wants to track EmployeelD, FirstName. LastName. SSN. HireDate, and Title. Some employees are store managers. but most are not. Each store is managed by 1 employee

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_2

Step: 3

blur-text-image_3

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

Management

Authors: Chuck Williams

4th Edition

978-0324316797, 0324316798

More Books

Students also viewed these General Management questions

Question

Describe topics for inclusion in orientation training programs.

Answered: 1 week ago

Question

What are the objectives of performance appraisal ?

Answered: 1 week ago

Question

State the uses of job description.

Answered: 1 week ago