Reminder: The ERD only has rectangles, lines, and tic marks (maximum and minimum cardinalities). There shouldnt be any diamonds or ovals (i.e., attributes) on the ERD. The attributes will be on the relational schema so there is no reason to list them twice.

Given the following scenario, draw (1) an ERD and (2) a relational schema.

A music store sells musical instruments, accessories, and music.

This music store has three locations Seattle, Missoula, and Portland, OR.

Employees work on commission for selling items above $5,000.00.

Employee commission rates may differ depending on location and tenure at the company.

There is no loyalty program for customers

The music store has a many-suppliers sourcing strategy.

If you make other assumptions in your diagram, please note it. Do not draw by hand and scan it in. Use either PowerPoint, LucidChart, www.draw.io, etc. to draw the figures and then cut and paste them into your Word document.

Draw.io has built in ERD symbols on the bottom left. This will make your life so much easier!

Reminder: The ERD only has rectangles, lines, and tic marks (maximum and minimum cardinalities). There shouldnt be any diamonds or ovals (i.e., attributes) on the ERD. The attributes will be on the relational schema so there is no reason to list them twice.