For this ER diagram, create the relational schema (i.e. the relations, complete with all primary and foreign keys, as well as data attributes). This should be using the notation we've done with our in-class exercises. The process shown in chapter 4 will help you to decide what relations are needed based on this diagram.

BOUGHT NEW BOUGHT USED Previous Service Records Date, Problem, Action)) BonusServiceType Manages CUSTOMER SALES PERSON SALE OF CAR Customer ID Name ( Address () Phone Email WantsEmailNotifications? WantsTextNotifications Sale ID Date of Sale VIN Number CommissionRate SERVICE RECORD Service Date Start Time End Time (Actions) Diagnostics) Creates SERVICE PERSON Manages SERVICE MANAGER EMPLOYEE Employee ID Name Contact (email, phone)