DBMS Assign 3

ERD Practice BIS 638 – Database Management for Business Systems

Prestige Bakers has hired you to create a database to help mange customer orders at its three stores. Use the following information to create an ERD: For each store, Prestige records the store number, address, and phone number. Each store has multiple employees, while an employee works at only one store. Each employee has an employee number, name, title, date hired, years of service, hourly rate, and skill(s). Each store offers multiple items for sale, while a given item may be available at multiple stores. Prestige records the item number, name, description, and unit price for each item. Prestige records the customer number, name (i.e., a person’s name), address, and phone number for each of its customers. When a customer orders items from a store, the order is processed using the following form:

Order Form

Order Number: __________ Order Date: __________

Store Number: __________

Customer Number: __________

Item Number Quantity

Employee Number:

__________