Question

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 choose the ERD that most appropriately represents the scenario above.
(A) because it is serializable
(B) because it is serializable
(C) because it is virtual (non-seralized)
(D) because it is virtual (non-serialized)

Answer 1

Answer:

(A) because it is serializable

Explanation:

The full form of ERD is the Entity Relationship Diagram. It is commonly known as the ER Model or the ER diagram. It is a kind of structural diagram which is used in the database design.

In the context, the most appropriately representing the scenario is option (A).

The serializable schedule always results in the consistent database. It is allowed to the transactions that are to be executed simultaneously. Therefore, all the transaction gets well executed concurrently. The serializable schedules are always recoverable.