QUESTION 6 6-3 Question 2 Class Enrollment is the intersection entity that resolves the M:M between STUDENT and CLASS. Does the ERD follow the rules of Second Normal Form? If you spot a violation, describe how you would correct it. a record for ENROLLMENT grade room CLASS #id *name *time the subject of a record for the attendee of STUDENT #number *name QUESTION 7 6-4 Question 4 Assume the following business rules: An athlete employs one agent An agent may work for one or more athletes. An athlete may play for one team. A team may have one or more players Does the model below contain one or more transitive dependencies? Identify the attributes involved in the transitive dependencies. ATHLETE #number * name * birth date * team * team coach * agent * agent commission QUESTION 8 7-1 Vocab Match the vocabulary word for each definition A. Arc A curved line used to represent an exclusive relationship in an entity-relationship diagram B. Exclusive OR A logical operator that returns a true value if one, but not both, of its operands is true C. Mutually Exclusive relationship / Exclusive or relationship D. Constraint A relationship between one entity and two (or more) other entities when only one of the relationships can exist at a time A restriction that applies to data, which is often dictated by the business rules QUESTION 9 7-1 Question 1 A show ticket is purchased from an agent, the box office, or the Internet. A ticket has a de-scription, an event, a date and a price. An agent has a name and a phone number. The box office has an address and a phone number. The Internet has a URL address. Draw the entities and represent the mutually exclusive relationship. QUESTION 10 8-1 Question 1 In the scenario below, what words or phrases indicate to you the need to track data that changes over time? Actors at the local theater sign contracts that specify their pay and working conditions. These contracts are renewed annually. Each year the contracts may change through new language and pay rates. In order to resolve labor disputes, the theater must sometimes go back several years in order to see the contract provisions in place on a particular date