Given the following narrative description for Lydia's Purple Cloth Factory:
a. Create a business process level REA model in either grammar or diagram format, for the following business process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Lydia's Purple Cloth Factory (LPCF) produces fabric in many different textures and patterns, all in various shades of purple. Raw materials, employee labor, and machines are used in the production process. Raw materials include various types of threads and dyes, along with assorted chemicals and detergents. Employees are hired to meet the skill requirements of various labor types. Each machine is specifically identified. LPCF uses bills of materials and operations lists to document which raw materials and labor types are needed to produce each type of purple fabric, therefore the database must capture the information needed to produce these documents.
As a need for a fabric type is identified, a production supervisor orders production and issues a signle requisition for the necessary raw materials, labor types, and machinery. LPCF never combines multiple fabric types on the same production order or production run; however, multiple materials, labor types, and machines are often needed to produce a single fabric type. When all requisitioned inputs are available, the raw materials are issued and the labor operations and machine operations are completed in a production run. Production employees perform the labor operations (one employee and one labor type per operation) under the watchful eye of a production supervisor; the machine operations are fully automated with one machine per operation, so they require only a production supervisor's attention. Raw material issuances are accomplished by inventory clerks and are authorized by production supervisors (one clerk and one supervisor per issuance). LPCF does not directly assign production supervisors to production employees; the supervisor position simply designates responsibility for all events and other activities associated with a production run.
The following attributes must be accounted for in your model.

Question

Quizplus · Accepted Answer

The Answer of Given the following narrative description for Lydia's Purple Cloth Factory:
a. Create a business process level REA model in either grammar or diagram format, for the following business process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Lydia's Purple Cloth Factory (LPCF) produces fabric in many different textures and patterns, all in various shades of purple. Raw materials, employee labor, and machines are used in the production process. Raw materials include various types of threads and dyes, along with assorted chemicals and detergents. Employees are hired to meet the skill requirements of various labor types. Each machine is specifically identified. LPCF uses bills of materials and operations lists to document which raw materials and labor types are needed to produce each type of purple fabric, therefore the database must capture the information needed to produce these documents.
As a need for a fabric type is identified, a production supervisor orders production and issues a signle requisition for the necessary raw materials, labor types, and machinery. LPCF never combines multiple fabric types on the same production order or production run; however, multiple materials, labor types, and machines are often needed to produce a single fabric type. When all requisitioned inputs are available, the raw materials are issued and the labor operations and machine operations are completed in a production run. Production employees perform the labor operations (one employee and one labor type per operation) under the watchful eye of a production supervisor; the machine operations are fully automated with one machine per operation, so they require only a production supervisor's attention. Raw material issuances are accomplished by inventory clerks and are authorized by production supervisors (one clerk and one supervisor per issuance). LPCF does not directly assign production supervisors to production employees; the supervisor position simply designates responsibility for all events and other activities associated with a production run.
The following attributes must be accounted for in your model.

Given the Following Narrative Description for Lydia's Purple Cloth Factory