Identify the minimum and maximum cardinality for each of the following scenarios: depict the symbols on the graph of each question

7. EXERCISE DESCRIPTION (PICTURE) EXERCISE DESCRIPTION (NARRATIVE) The Belgian Chocolate Company has specific rules for carrier selection. All shipments that are not within a 50 mile radius of East Lansing are shipped by a long SHIPMENT distance carrier. These are the 'Long Distance' shipments. There are three different SALE categories of Long Distance (LD) shipments - normal LDS, express LDS and delicate LDS. Express LDS delivers the chocolates within two working days. A delicate LDS is SHIPMENT used in summer or to warm places such as New Mexico, Texas and Arizona. There TYPE are only two types of local shipments (LS), normal LS and delicate LS. Only carriers CARRIER that offer at least one of these shipment categories are considered. The UPS strike led to the decision to record at least two different carries for each shipment category. Categories and authorized carriers change over time. BCC would like to have these rules stored into the relational database. What are the cardinalities for the relationship that stores these rules; the relationship between shipment type and carrier ? 7a 7b Shipment Carrier Type 8 EXERCISE DESCRIPTION (PICTURE) EXERCISE DESCRIPTION (NARRATIVE) The Abmis Orchestra would like to build a database that records information about instruments and musicians: . More than one instrument can be recorded for the same musician. . It is possible to include instruments without having any actual or potential musician that can play the instrument. . There can be many musicians available for the same instrument. . They would like to include the actual musicians as well as potential musicians ga 8b Instrument Musicinu . At least one instrument must be recorded for each musician. Instrument Musician 9 EXERCISE DESCRIPTION Dwarf (Left Entity) -- Job (Right Entity) Doc is very upset. After Snow White married the Prince, the other dwarfs (Dopey, Sneezy, Grumpy, Bashful, Happy and Sleepy) became very dissorganized. There are so many things to do and none of the dwarfs seems to know what he is supposed to do Doc decides to create a database application that lists all the jobs that need to be done and the dwarf who is responsible for doing the job. He comes up with a list of 9 jobs: cooking, cleaning, gardening, shopping, etc. He assigns three jobs to himself and asks Grumpy to clean and shop. He makes sure there is exactly one dwarf responsible for each job. 9a 9b Dwarf Job 10. EXERCISE DESCRIPTION Author (Left Entity) -- Book (Right Entity) writes (relationship) You must have written at least one book to be an author. 10a 10b Most authors write more than one book Author Book We only consider a book when we know the author For some books there is more than one author (this is especially true for textbooks)