How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask TheDoctor Your Own Question
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1757
Experience:  M.S. in Internet Information Systems
Type Your Homework Question Here...
TheDoctor is online now
A new question is answered every 9 seconds

For the Doctor...can you assist with this task? Thanks. Draw

This answer was rated:

For the Doctor...can you assist with this task? Thanks.

Draw an ERD based on the following case study.

Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed a list of business rules and specifications:

• Customers place orders through a branch.
• Wally would like to track the following about customers: Name, Address, City, State, Zip Code, Telephone, Date of Birth, and Primary Language.
• A customer may place many orders.
• A customer does not always have to order through the same branch all the time.
• Customers may have one or more accounts, although they may also have no accounts.
• The following information needs to be recorded about accounts: Balance, Last payment date, Last payment amount, and Type.
• A branch may have many customers.
• The following information about each branch needs to be recorded: Branch Number, Location (Address, City, State, Zip Code), and Square Footage.
• A branch may sell all items or may only sell certain items.
• Orders are composed of one or more items.
• The following information about each order needs to be recorded: Order Date and Credit Authorization Status.
• Items may be sold by one or more branches.
• We wish to record the following about each item: Description, Color, Size, Pattern, and Type.
• An item can be composed of multiple items; for example, a dining room wall covering set (item 20) may consist of wallpaper (item 22) and borders (item 23).
• Wally employs 56 employees.
• He would like to track the following information about employees: Name, Address (Street, City, State, Zip Code), Telephone, Date of Hire, Title, Salary, Skill, and Age.
• Each employee works in one and only one branch.
• Each employee may have one or more dependents. We wish to record the name of the dependent as well as the age and relationship.
• Employees can have one or more skills.
Hello again! Thank you for requesting me.

By when do you need this?
Customer: replied 4 years ago.

By tomorrow would be good. Thanks.

Thank you. I will contact you once this is complete.

You need to spend $3 to view this post. Add Funds to your account and buy credits.
TheDoctor and other Homework Specialists are ready to help you