Fire Tint, Inc. (FTI) applies tint to airplane canopies (front windows) manufactured by other companies. When...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Fire Tint, Inc. (FTI) applies tint to airplane canopies (front windows) manufactured by other companies. When the canopy manufacturer asks FTI to tint a canopy, FTI tracks the manufacturer, model number, and the CIN-a unique serial number assigned to each individual canopy by the manufacturer. FTI has a finite set of standard treatments it applies to canopies. Each treatment applied by FTI has a treatment number, treatment description, and a published price for each treatment. Although there is a published price for each treatment type, FTI often negotiates the actual price for each treatment when a manufacturer places an order. Sometimes more than one different treatment is applied to the same canopy. When a treatment is applied to a canopy, FTI keeps track of the treatment applied, the date it was applied, and the start and end time of when the treatment was applied, and the negotiated actual price. Please select the ERD that most appropriately represents the scenario above. A) B) D) PK PK PK PK Canopy Model Num Manufacturer CIN Canopy CIN Manufacturer Model Num Canopy Manufacturer Model Num Model Num + Canopy H CIN Manufacturer Model Num + Canopy-Treatment PK/FK Model Num PK/FK PK/FK PK/FK Canopy-Treatment TNum Date PK/FK PK/FK Start Time End Time ActualPrice Canopy-Treatment CIN TNum Date StartTime EndTime ActualPrice PK/FK PK/FK CIN TNum Date StartTime End Time ActualPrice Canopy-Treatment CIN TNum Date Start Time End Time PublishedPrice PK PK PK PK Treatment TNum Description Published Price Treatment TNum Description PublishedPrice Treatment TNum Description Published Price Treatment TNum Description ActualPrice Fire Tint, Inc. (FTI) applies tint to airplane canopies (front windows) manufactured by other companies. When the canopy manufacturer asks FTI to tint a canopy, FTI tracks the manufacturer, model number, and the CIN-a unique serial number assigned to each individual canopy by the manufacturer. FTI has a finite set of standard treatments it applies to canopies. Each treatment applied by FTI has a treatment number, treatment description, and a published price for each treatment. Although there is a published price for each treatment type, FTI often negotiates the actual price for each treatment when a manufacturer places an order. Sometimes more than one different treatment is applied to the same canopy. When a treatment is applied to a canopy, FTI keeps track of the treatment applied, the date it was applied, and the start and end time of when the treatment was applied, and the negotiated actual price. Please select the ERD that most appropriately represents the scenario above. A) B) D) PK PK PK PK Canopy Model Num Manufacturer CIN Canopy CIN Manufacturer Model Num Canopy Manufacturer Model Num Model Num + Canopy H CIN Manufacturer Model Num + Canopy-Treatment PK/FK Model Num PK/FK PK/FK PK/FK Canopy-Treatment TNum Date PK/FK PK/FK Start Time End Time ActualPrice Canopy-Treatment CIN TNum Date StartTime EndTime ActualPrice PK/FK PK/FK CIN TNum Date StartTime End Time ActualPrice Canopy-Treatment CIN TNum Date Start Time End Time PublishedPrice PK PK PK PK Treatment TNum Description Published Price Treatment TNum Description PublishedPrice Treatment TNum Description Published Price Treatment TNum Description ActualPrice
Expert Answer:
Answer rating: 100% (QA)
The most appropriate ERD EntityRelationship Diagram for the given scenario is option B Canopy PK Can... View the full answer
Related Book For
Modern Advanced Accounting In Canada
ISBN: 9781259066481
7th Edition
Authors: Hilton Murray, Herauf Darrell
Posted Date:
Students also viewed these economics questions
-
Mrs. Knosy is a high school teacher who likes to stay informed about how her students are doing, both academically and socially. She usually does this by spending time in the hallway talking to her...
-
Financial statement users typically begin their assessment of permanent earnings with: Multiple Choice a. sales revenue. b. income from continuing operations. c. net income. d. gross profit. :
-
If a currency reform has no effects on the economys real variables, why do governments typically institute currency reforms in connection with broader programs aimed at halting runaway inflation?...
-
Barry has a chronic back problem that requires that he receive regular therapy in a swimming pool. He purchased a new home with a larger backyard so that he could install a swimming pool. The...
-
Consider the wire bond pull strength data in Exercise 12-8. Build regression models for the data using the following methods: (a) Stepwise regression. (b) Forward selection. (c) Backward elimination....
-
The following balances come from the ledger of Hansi's Home Furniture Factory at 30 June 2025. Hansi's Home Furniture Factory financial year ends on 30 June. During the year the accountant prepared...
-
Aquatica uses a standard cost system for materials and labor in producing small fishing boats. Production requires three materials: fiberglass, paint, and a purchased trim package. The standard costs...
-
1 2 34 What is "SWOT analysis? How do you carry it for a technical educationalinstitute? What is corporate planning? Explain the process of corporate planning? Discuss the process of strategy...
-
For the assigned product manufactured in Canada and/or the selected country, identify: Licences, Permits, Approvals List and briefly describe the key licences, permits and approvals that your...
-
Describe some of the alternative structures for digital marketing within an organization.
-
What are common communications approaches that need to be applied by marketers across the major social media marketing platforms?
-
Describe the situations where you think a single digital marketing agency is preferable to the use of different specialists.
-
Are transit tickets, Uber rides, and gasoline substitutes? Explain your answer. Public transit ridership was down in 2016 in most U.S. cities. Uber rides increased and gas prices fell. In some...
-
What types of goal is it important to define for social media marketing?
-
Mathematically, define marginal utility? Visually show that marginal utility of screen size of smartphone keeps diminishing with the growth of size and runs the risk of being negative.
-
Dawson Companys balance sheet information at the end of 2019 and 2020 is as follows: Additional information: The company did not issue any common stock during 2020. Required : Next Level Fill in the...
-
On July 1, Year 4, Aaron Co. purchased 80% of the voting shares of Bondi Ltd. For $543,840. The statement of financial position of Bondi on that date follows. The accounts receivable of Bondi were...
-
Explain why complete comparability on a worldwide basis is going to be difficult to achieve despite a switch over to IFRSs.
-
Describe when to use the closing rate and when to use the historical rate when translating assets and liabilities denominated in a foreign currency. Explain whether or not this practice is consistent...
-
Which process would release energy from goldfission or fusion? From carbon? (a) gold: fission; carbon: fusion (b) gold: fusion; carbon: fission (c) gold: fission; carbon: fission (d) gold: fusion;...
-
If an iron nucleus split in two, its fission fragments would have (a) greater mass per nucleon. (b) less mass per nucleon. (c) the same mass per nucleon. (d) either greater or less mass per nucleon.
-
Is it possible for a hydrogen nucleus to emit an alpha particle? Why? (a) yes, because alpha particles are the simplest form of radiation (b) no, because it would require the nuclear fission of...
Study smarter with the SolutionInn App