Nora’s Bagel Bin Database Blueprints (continued)

Second Normal Form (2NF) Bagel ID • Separate the data that depend on just one of the two parts of the primary key into separate tables. • Keep any columns in the original table (now named "Bagel Order Line Item") that still depend on both parts of the original primary key. • Fill in each shaded cell within the tables with an attribute from the 1NF blueprint in the previous section. • Fill in the dotted cells between the tables with the cardinality of the relationship between those two tables: one- to-one (1:1), one-to-many (1:M), many-to-one (M:1), or many-to-many (M:M). Third Normal Form (3NF) • Look for remaining data that are or could be repeated within each table but do not depend on the primary key. • Move that repeated data into their own table by filling in the shaded cells with attributes from your 2NF diagram. • Create a new attribute to be the primary key for this new table and also use it as the foreign key linking to this new table; fill in the appropriate shaded cells with this new attribute. • Fill in the dotted cell between the two new tables with the cardinality of the relationship between those two tables: one-to-one (1:1), one-to-many (1:M), many-to-one (M:1), or many-to-many (M:M). • Give the two new tables appropriate names. • Fill in the remaining shaded cells from any unchanged tables using the information from your 2NF diagram.