Question: 4G VOLTE O 58% 22:22 + https://drive.google.com... : Length Film type Name Address Yop Title Movies Stars Act n Shot Connect n Studio Owner Banner

4G VOLTE O 58% 22:22 + https://drive.google.com... : Length Film type Name Address Yop Title Movies Stars Act n Shot Connect n Studio Owner Banner From the above E-R diagram answer the followings: 1. Rectangles are the in the above E-R diagram. 2. Oval Shapes are 3. Diamond shapes are 4. A movie is shot in only one studio [True False) 5. Stars are connected to one studio only but can act in any film which may or may not be owned by the studio [True False) MEIE3284 Design of Industrial Information System SAMPLE TEST2 C. The following is a description of some data requirements for a chain of hypermarkets. (a) A company manufactures one or more cakes, and each cake is manufactured and marketed by exactly one company. (b) Cakes are sold in hypermarkets. Each hypermarket has a unique identification Every hypermarket sells one or more cakes, but some hypermarkets do not sell every cake. (c) Cake sales must be recorded by invoice, which are kept as a record by the hypermarket . An invoice clearly identifies the cake, chief, and customer, as well as the date it is filled. (d) Chief produces cakes for customer. A Chief can produce one or more cakes for a customer and a customer can get one or more invoices, but a invoice is written by only one chief. (e) Cake manufacturer companies may have long-term contracts with hypermarkets and a hypermarket can contract with zero, one, or more companies. Each contract is uniquely identified by a contract number Draw the appropriate entity-relationship (E-R) diagram. Clearly show all cardinality constraints, cardinality limits, and existence dependencies (10 Points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
