Vht2 – Vht2 Task 1: Normalization And Database Design
VHT2 – VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGNVHT2 – VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN A. Construct a normalized physical database model to represent the ordering process for Nora’s Bagel Bin by doing the following: 1. Complete the second normal form (2NF) section of the attached “Nora’s Bagel Bin Database Blueprints” document by doing the following: a. Assign each attribute from the 1NF table into the correct 2NF table. b. Describe the relationship between the two pairs of 2NF tables by indicating their cardinality in each of the dotted cells: one-to-one (1:1), one-to-many (1:M), many- to-one (M:1), or many-to-many (M:M). c. Explain how you assigned attributes to the 2NF tables and determined the cardinality of the relationships between your 2NF tables. Solution: - One bagel item can be included in more than one bagel order. - A bagel order id in the bagel order line item relates to just one order id. As a result, this is a 1:M ratio (one-to-many)
Información del documento
- Subido en
- 27 de marzo de 2023
- Número de páginas
- 17
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas