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
Written for
- Institution
- Data Management - Applications - C170 Performance
- Course
- Data Management - Applications - C170 Performance
Document information
- Uploaded on
- November 30, 2023
- Number of pages
- 5
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
data management applications c170 performance
Also available in package deal