4 12 Points Consider Following Relation Schema Work Operator Item Made Machine Date 1 For Q37044417

4. (12 points) Consider the following relation schema: WORK(Operator, Item-Made, Machine, Date). (1) Formulate the following

4. (12 points) Consider the following relation schema: WORK(Operator, Item-Made, Machine, Date). (1) Formulate the following constraints on this relation schema as functional dependencies: (a) an operator can work on only one machine on the same day: (b) each Item-Made (eg, skirt, hat) must be made on the same machine (2) Assume that the following functional dependencies on relation schema Wo RK Operator, Machine) (ltem-Made, Date) Item-Made Machine are given. (Do not consider the F.D.s in the above Question (1). Is

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.