Assume you have been given the following data model created for the Beauty Gallery, a small art gallery that 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. Can post image of hw and what I have so far. I am stuck like Chuck here. I know I am close but cannot seem to get the relations working right.

This is what I have so far. I can send info on how i set up the tables too. I am sure I missed something I just cannot figure out what. i deleted the other relations for the image. Thank you in advance.

Assignment 8 ssume you have been given the following data model created for the Beauty Gallery, a small art gallery that has been in business for 30 years. Review the conceptual data model refully 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 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 WORK ARTIST CUSTOMER CustomerNumber LastName WorkID ArtistiD PURCHASE Name Nationality Birthdate DeceasedDate CREATE FirstName Address City State ZIP Phone Title Copy Description REFERRED-BY Has_Interest In / Admired_By