Data Management - Applications - C170 Performance Labs - uCertify
1.1.1 - Conceptual Schema - ER Model Tables: Customer, DonutOrder, Donut - Customer: PK - CustomerID Rest are customer related fields DonutOrder: FK - CustomerID, FK - DonutID Qty, SpecialNotes Donut: PK - DonutID Rest are donut fields Relationships: Customer - 1:n Identifying - DonutOrder DonutOrder - n:1 Identifying - Donut Why are the relationships in 1.1.1 Identifying? - The PK's of Customer and Donut are included in the composite primary key of DonutOrder. 2.1.1 - Physical Scheme - ER Model Tables: Customer, DonutOrder, Donut - Customer: PK - CustomerID
Geschreven voor
- Instelling
- Data Management - Applications - C170 Performance
- Vak
- Data Management - Applications - C170 Performance
Documentinformatie
- Geüpload op
- 30 november 2023
- Aantal pagina's
- 5
- Geschreven in
- 2023/2024
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
data management applications c170 performance
Ook beschikbaar in voordeelbundel