Part 1 - Using the data items given below, construct an REA diagram (entities, participation cardinalities, relationships). The conceptual model could use the model form we have used in classEvents in middle, Resources on left and Agents on right. Bring a printed version of REA Diagram to class. If you use a computer with Visio, you can change the REA diagram below.
Part 2: Design a minimal relational database for Pieces Boutique. By minimal, it is meant that option to post a key into existing table because of either needed participation or a discernible high load could be exercised where appropriate. Use the subsequent format for the DB design: Table Name Primary Keys Attributes Foreign Keys Make sure you have good reasons for putting model elements in for keeping model components out. Please do not add attributes to this list. Some data items on this list can be used more than once in building the REA model and relational database and some attributes can't be used at all if they are volatile attributes