Assignment 8 Page 1 of 2 Assignment 8 Submit Assignment Due Friday by 10pm Points 50 Submitting a text entry box or a file upload Assignment 8 Assume you have been given the following data model created for the Beauty Gallery, a small art gallery tha has been in business for 30 years. Review the conceptual data model carefully and follow the steps to transform the model into relational database design. Then implement the relational design into Access database. Submit the created Access database file . Create each table and specify appropriate column data types, primary keys, foreign keys, and any special column characteristics in the Access database implementation. . Build relationships in the Relationship window in Access and specify referential integrity constraints & actions as appropriate. CUSTOMER WORK ARTIST CustomerNumber WorkID ArtistID LastName PURCHASE FirstName Title CREATE Name Address City O - Copy DO Nationality State Description Birthdate ZIP Phone DeceasedDate pe REFERRED-BY Has_Interest_In / Admired_By