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.
Instructions: For each case below, graphically represent entities and relationships between entities. Include primary keys, foreign...
If possible use Microsoft Visio or anything BUT handwritten diagrams for questions 6-10, please. Thank you! This is for my Oracle class. 1. Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? 2. How would you determine which orders have not yet been shipped to the customer? 3. If management needed to determine which book category generated the most sales in April 2009, which tables and...