Schema $3$ A Milliner $(25$ points$)$

The Mad Hatter Millinery shop has finally decided to build a database and have asked you for your assistance. The shop sells hats to customers in Provincetown. Each type of hat sold at the Mad Hatter is associated with a well$-$known hat style, a manufacturer$-$assigned hat name, a composing material, and a $256$ character length description. The hat style values are: fedora, panama, baseball, bucket, newsboy, bowler, turban, beret and sun. The hat name can be any character string and is guaranteed to be unique for the manufacturer but not unique across manufacturers. The sizes of hats are categorized by the size of the circumference of the head that it can fit. Hats are sized by the actual circumference of the head with values ranging from $20$ to $26$ inches. For each hat, the Mad Hatter assigns a unique serial number. A customer buys $1$ to many hats on a specific date. A hat is associated with a size, and is also associated with a specific hat type and color. A hat type can be purchased by many different customers but a specific hat is purchased by only $1$ customer. A customer can purchase many hats. A customer consists of a name $($first and last$),$ a credit card and an optional mailing address $($street number, street name, town, state and zip code$).$ For a hat manufacturer you must track the unique manufacturer$$s names, the company$$s unique email address and its postal address $($ street number, street name, town, state, zip code$).$

For the data dictionary $-$ please create the $3$ standard tabs$,$ the entity, relationship and attribute tabs$.$ Before each solution for a problem in the first column specify the problem number.