Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a database design for the Boeing X Aircraft Company (BAC), which has two HUD (heads-up display) products: TRX-5A and TRX-5B. The database must enable

Create a database design for the Boeing X Aircraft Company (BAC), which has two HUD (heads-up display) products: TRX-5A and TRX-5B. The database must enable managers of BAC 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. 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 authorized 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.


Step by Step Solution

3.47 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

Answer1 Certainly heres a database design for the Boeing X Aircraft Company BAC to track blueprints parts software changes and test data for their HUD products Tables Blueprints BlueprintID Primary Ke... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan

11th edition

77861701, 978-0077861704

More Books

Students also viewed these Databases questions

Question

What is the asset-liability time mismatch that all banks face?

Answered: 1 week ago

Question

Calculate the missing values

Answered: 1 week ago