Information Technology IT – 10 Database and file concepts | e-Consult
10 Database and file concepts (1 questions)
Login to see all questions.
Click on a question to view the answer
Conceptual ERD:
| Entity |
- Product: Attributes - ProductID (PK), ProductName, Description, Price
- Supplier: Attributes - SupplierID (PK), SupplierName, ContactPerson, Phone, Email
- Order: Attributes - OrderID (PK), OrderDate, TotalAmount
- OrderLine: Attributes - OrderLineID (PK), OrderID (FK), ProductID (FK), Quantity, UnitPrice
- Relationships:
- A Supplier supplies one or more Products (One-to-Many).
- A Product can be included in many Orders via OrderLines (One-to-Many).
- An Order can contain many OrderLines (One-to-Many).
Explanation: This conceptual model captures the core business entities and their fundamental relationships. The relationships are defined based on how the business interacts with these entities. The primary keys (PK) uniquely identify each entity instance, and foreign keys (FK) establish the relationships between entities. The relationships are chosen to reflect the core business processes – suppliers providing products, products being ordered, and orders containing product lines.