Reference no: EM1371864
You have been asked to create a database design for the BoingX Aircraft Company (BAC), which has two products: TRX-5A and TRX-5B HUD (heads-up display) units. The database must enable managers to track blueprints, parts and software for each HUD, using the following business rules:
• For simplicity's sake, you may assume that the TRX-5A unit is based on two engineering blueprints and that the TRX-5B unit is based on three engineering blueprints. You are free to make up your own blueprint names.
• All parts used in the TRX-5A and TRX-5B are classified as hardware. For simplicity's sake, you may assume that the TRX-5A unit uses three parts and that the TRX-5B unit uses four parts. You are free to make up your own part names.
Please note:
Some parts are supplied by vendors, while others are supplied by the BoingX Aircraft Company. Parts suppliers must be able to meet the technical specification requirements (TSRs) set by the BoingX Aircraft Company. Any parts suppliers that meet the BoingX Aircraft Company's TSRs may be contracted to supply parts. Therefore, any part may be supplied by multiple suppliers and a supplier can supply many different parts.
• BAC wants to keep track of all part price changes and the dates of those changes.
• BAC wants to keep track of all TRX-5A and TRX-5B software. For simplicity's sake, you may assume that the TRX-5A unit uses two named software components and that the TRX-5B unit also uses two named software components. You are free to make up your own software names.
• BAC wants to keep track of all changes made in blueprints and software. Those changes must reflect the date and time of the change, the description of the change, the person who authorised the change, the person who actually made the change, and the reason for the change.
• BAC wants to keep track of all HUD test data by test type, test date and test outcome. Given those requirements, create the ERD segment using UML notation
|
Expression for marginal product of labor
: Find an expression for the marginal product of labor, MP L , when the amount of capital is fixed at 16 units, and then illustrate that mardinal producer of labor depends on the amount of of labor hired by calculating the marginal porducto of labor..
|
|
Question on production curve
: The questions asked that suppose that, because of important technological improvements, the society in question can double its production of tractors at each level of food production.
|
|
What is the underground economy
: What is the Underground Economy? What effect, if any, does the Underground Economy have on the entire economy? Is it positive, negative, or has no effect?
|
|
Evaluate a bundling strategy for consumers
: Pepsi manufactures Fritos and Lays potato chips in addition to its basic soft drink products. Discuss and explain potential ways that this business combination might increase value.
|
|
Design database design for boingx aircraft company
: You have been asked to design database design for BoingX Aircraft Company (BAC), that has two products: TRX-5A and TRX-5B HUD (heads-up display) units.
|
|
Economic efficiency in the organization
: If a manager that takes over a furniture factory and realizes immediately that it was throwing away at least $100,000 a year worth of wood scrap
|
|
Write down java program for furniture company
: Write down a Java program for the furniture company. Ask user to select P for Pine, O for Oak or M for Mahogany. Illustrate price of table manufactured with chosen wood.
|
|
Risky behavior amoung youths in behavioral economics
: Determine what is Risky Behavior Amoung Youths in Behavioral Economics and explain how does it affect the economy?
|
|
Design application-layer protocol for streaming video
: Suppose you are designing the application-layer protocol for streaming video. How would you deal with unreliability of Internet Protocol?
|