3. Design a database for a business that allows customers to decorate pottery shapes: The business offers some number of distinct shapes, each of which has a name, requires a certain amount (weight) of clay, is stored on a set of shelves, has a price, and is identified by an id. Shapes have some number of instances, which are considered separate entities. The total number of instances is also of interest. Each instance of a shape is burnt on a specific day. Customers have a name that is composed of first and last name, and a telephone number. Customers can decorate any number of instances of shapes. Not every instance of a shape is assigned to a customer, since not all have been decorated.

a) State which attributes are simple, composite, multi-valued, and derived.

b) State the cardinality ratios and participation constraints of each relationship and describe what it implies.

c) Draw an entity-relationship diagram for this miniworld. Include all primary keys and all foreign keys.