Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Build a Logical ERD using the below business description. EquestrianZone, a family owned business that sells horse products, was founded in 1976 and has grown
Build a Logical ERD using the below business description. EquestrianZone, a family owned business that sells horse products, was founded in 1976 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 paperwork. During a date with a really nice cowgirl he met on FarmersOnly.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 RegionID, 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
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