ITM $315$ Homework $3$ Chapter $7$ Due Tuesday, Nov $12,2024$at $10$pm$.28$ points possible

Use ERD plus to draw the ERD diagram for the scenario below. Paste your diagram into a word document and submit to canvas. You may also submit a PDF$.$ After pasting into your document, crop any excessive white space. Make sure to correctly indicate any composite or multivalued attributes $($Hint$-$names and addresses are almost always composites$).$ Be sure to make sure each attribute has a name that is unique within the ERD. Name your file $$ch $7$ lastname$.$ This is an individual assignment. Please refer to the coursesyllabus for any clarification regarding how I define an individual assignment

You are not allowed to use any AI tools to aid you in completing this assignment.

A pottery studio needs a system to manage its customers, the classes it offers, the instructors who teach those classes, the pottery pieces made by customers, the equipment used, and the supplies necessary for classes. Your task is to design an ERD that reflects these aspects of the studio$$s operations.

Customers are$$ individuals who sign up for pottery classes. Each customer has several attributes, including a unique Customer$\_$ID$,$ Name $($First and Last$),$ Email, Phone Number, and Date Joined. We also record the hobbies each customer has.

Some customers may refer others customers to the studio This means that a customer can refer multiple other customers, but each customer can be referred by only one other customer.

Each class offered by the studio has a Class$\_$ID$,$ Class$\_$Name, Description, Start Date, End Date, and Class Fee. a customer can enroll in multiple classes, and each class can have multiple customers enrolled. When a customer enrolls in a class, we want to record the date.$$ e

Instructors are individuals who teach pottery classes. Instructor attributes include Instructor$\_$ID$,$ First and Last, Phone Number, Email, and Specialization $($e$.$g$.,$ wheel throwing, hand$-$building$).$ Each instructor can teach multiple classes, but each class is taught by only one instructor. Each class has a lead instructor, where each class has only one designated lead instructor, and an instructor can lead only one class at a time.

Pottery pieces$$ represent the items made by customers during classes. Each pottery piece has attributes such as Pottery$\_$ID$,$ Name $($e$.$g$.,$ vase, bowl$),$ Type $($e$.$g$.,$ wheel$-$thrown, hand$-$built$),$ Date$\_$Created, and whether it is glazed. A customer can make multiple pottery pieces, but each piece is made by only one customer.

Equipment tracks the tools used in the studio, such as pottery wheels, kilns, and sculpting tools. The attributes for equipment include Equipment$\_$ID$,$ Name, Type, and Maintenance$\_$Date. as each class uses multiple pieces of equipment, but a particular piece of equipment can only be used by one class at a time.

Supplies are the materials the studio uses, like clay, glazes, and tools. Each supply has attributes like Supply$\_$ID$,$ Name, Type $($e$.$g$.,$ material, tool$),$ and Quantity$\_$On$\_$Hand. A class can use multiple supplies, and the same supply can be used in different classes.