[SOLVED] Beauty Gallery

15.00 $

Programming resource
Digital learning resource
Category:
Practical programming resource
Suitable for guided study and reference
Tutor guidance available when needed

Description

5/5 - (3 votes)

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

Resource details

Understand the Task Before You Use the Resource

Review the requirements, identify the programming concepts involved, study the implementation and test your understanding with your own examples and modifications.