Design a database using the following information. UsingMicrosoft Visio 2013, create a complete E-R Diagram in Crow’s Footnotation (including entity names, attributes, primary keys andforeign keys) that can be implemented, and then implement it inMicrosoft Access. Your completed assignment will have two filessubmitted: the Crow’s Foot ER diagram and the Microsoft Accessdatabase file (an .accdb file). My Closet is a small online companythat sells dresses. All customer orders to My Closet are orderedfrom the dressmaker at the time of sale. My Closet can orderdresses from multiple dressmakers. Every dressmaker produces one ormore different styles of dresses. Every style is produced by onlyone dressmaker. Every style has one or more colors of dresses.Every dress color made is belongs to only one style. Everydressmaker is identified by a dressmaker code. The dressmaker name,address, email, phone number, and account number are kept for everydressmaker. Every dress style is identified by a style code. Thestyle name and price are kept for every style. Every color isidentified by a color code. The color name and the available sizesfor that color are kept for every color.
*** I know what the ER diagram should look like. I’m wonderingwhat the final ACCESS database should look like.