Question
Requirement 1. Based on the next narration, complete the REA diagram with connections and multiplicity. For the unknown names in class, you can put the
Requirement 1. Based on the next narration, complete the REA diagram with connections and multiplicity. For the unknown names in class, you can put the names.
Requirement 2. Using the attributes provided, list the names of the tables according to the format at theend of this question as in cash table (don't use any extra attributes and make it sure to indicate the primarykey with PK and foreign key with FK)
Serena's Tennis Togs, Inc., was founded by one ofthe world famous women's tennis players to produce tennisand other sports clothing for the many women that appreciate Serena's unique fashion sense. Serena's TennisTogs, Inc. (STTI) makes and markets multiple types of recreational clothing lines for women. This case focuseson STTI'sacquisition/payment and conversion processes.
STTI Conversion cycle. When STTI gets an order from one of their distributors (sales orders are not modeled in this case), a manufacturing supervisor issues one or more production orders to authorize production of the clothing items. Each production order applies to only one finished clothing item. For cost accounting purposes, STTI determines the total standard labor and material cost for each production order.
STTI has carefully planned the material and labor required for each of its finished clothing items. Its master assembly plan specifies the sequence of steps (assembly operations) as well as the raw materials required to produce each finished clothing item. The master assembly plan also specifies the standard labor and material cost for each step. Each step in the master assembly plan is identified with a master assembly number.
The actual manufacturing process occurs in a series of assembly steps (each step is identified by control # in the production control records). Each step may use several types of material. STTI tracks the actual material and labor costs for each step in their production control records. STTI also tracks the total standard and actual costs for each production order.
The STTI manufacturing process employs two classes of employees: crafters and supervisors (model separately). Crafters get the raw materials from inventory and use them in the assembly steps. Each assembly step may involve several crafters, and crafters may work on several assembly steps.
The crafters are paid on an hourly basis. Production supervisors are paid salaries and bonuses. (Model them separately).
STTI Purchases.STTI's financial success depends on the quality of their products, so the company buys only thehighest quality raw materials and follows a structured acquisition process. First, the buyers issue purchase orders to vendors for one or more required raw material items. Second, the vendor ships the products to STTI, and STTI records purchases upon receipt and acceptance of the items. In some cases, vendors fulfill several purchase orders with one shipment.
STTI takes advantage of all prompt payment discounts. If multiple vouchers are due to the same vendor on a certain day, the cashier combines those into one payment. STTI pays for each purchase in full, less any applicable discount, on the day that the payment is due.
After receipt and acceptance, each raw material item is stored in its designated bin to facilitate its issue to the production process, although each bin may hold several different types of raw material. Each bin is color- coded for easy identification.
General. All economic agents, resources, and types are put into the database before any relationships with other entities are instantiated. STTI tracks its employees in separate classes according to their particular job, although each internal agent is keyed by employee#. (So, don't model one Employee agent; model separate internal agents, e.g., buyers, crafters, cashiers, supervisors.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started