ER Modeling & Normalization HW $1$

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 $3$NF$.$

Data for an artificial intelligence 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.

An online retailer of ice cream maintains a long list of unique ice cream flavors. The ice cream

shop purchases ice cream from a number of suppliers; however, each specific flavor of ice

cream is purchased from only a single supplier. Many of the customers are repeat purchasers

and typically order at least four flavors of ice cream in each order.