3: Consider a relation that belongs to the Software academy shipment data. You h

Question

3: Consider a relation that belongs to the Software academy shipment data. You have been given a task to analyze the following relation and Professor Turing is counting on you (a mistake here will probably be fatal).

There are 6 attributes: Name, ShipID, Capacity, Model, Size, Class.

You are given the following dependencies:

Class --> Model, Size

ShipID, Capacity --> Name, Model, Size, Class

Model --> Capacity

Compute the closure of the functional dependencies above.

2. Compute the attribute closure of (ShipID, Capacity)

3. Compute a minimal cover of the functional dependencies.

4. If possible, decompose the scheme into lossless, dependency preserving, BCNF. If not, then try 3NF, lossless and dependency preserving (show all your work here, otherwise Master Yoda won

Explanation / Answer

Rule 1: C.createsOder

Event( ?Var_Event_BeginOrder), OrderArtifact(?Var_Order), hasEventID(?Var_Event_BeginOrder,

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.