Question

Instructions: For each case below, graphically represent entities and relationships between entities. Include primary keys, foreign keys where appropriate. For each entity add a couple of attributes (fields) and then provide a brief statement explaining why each entity (table) is in 3NF.

Data for an information technology conference needs to be collected. The conference has a variety of sessions scheduled over a two-day period. All attendees must register for the sessions they plan to attend. Some speakers are presenting only one session, whereas others are handling multiple sessions. Each session has only one speaker.

Conference speaker                 Conference session                 Registration       conference-attendees

An online retailer of coffee beans maintains a long list of unique coffee flavors. The company purchases beans from a number of suppliers; however, each specific flavor of coffee is purchased from only a single supplier. Many of the customers are repeat purchasers and typically order at least five flavors of beans in each order.

Answer 1