Beauty Gallery Database

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 relatiobal database design. Then implement the relational design into Access database.

  • Create each table appropraite column data types, primary keys, foreign keys, and any special column characteristics in the Access database implementation.
  • Build relationhips in the Relationship window in Access and specify referential integrity constraints and actions as appropriate.

ER Diagram: see image.

Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.