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.
- 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.