Assume that Stained Glass Artistry, a new shop that specializes in making stained glass artwork, has hired you to design an integrated database that will provide the owners with the accounting information they need to effectively manage the business. Stained Glass Artistry makes a wide variety of stained glass windows for sale in its store.
A unique job order is assigned to each production run, which includes creating multiple copies of the same basic design. When raw materials are issued to employees, the issuance is documented on a prenumbered raw material issue form. The different kinds of glass needed for the product, and other materials such as copper foil or lead, are issued at one time, so that employees can efficiently produce the design.
Creating a piece of stained glass art involves several different steps, including cutting, foiling, and soldering. The owners want to track how much time each employee spends each day performing each of those various tasks.
The owners have developed raw material and direct labor standards for each design they offer. They want their AIS to track actual costs and standard costs so that they can generate reports that provide price and quantity variance information.
The owners also have provided you with the following list of facts that they want stored in the database. (Note: You must create appropriate primary keys for each table; this is the list of other attributes.)
ATTRIBUTES IN STANDARD GLASS ARTISTRY AIS | ||
Date hired | Time started task | Time completed task Color of glass |
Style of glass (name or description) | Quantity on hand Quantity to be produced | Actual cost of design Quantity issued |
Design name | Standard quantity of glass to use in design | Standard cost of design |
Standard hours to make design | Date design produced | Date of birth |
Wage rate | Employee name | Standard cost of glass |
REQUIRED
a. Draw an integrated REA diagram for Stained Glass Artistry. Include both minimum and maximum cardinalities.
b. Create the set of relational tables required to implement your REA diagram for Stained Glass Artistry in a relational database.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.