Answered step by step
Verified Expert Solution
Question
1 Approved Answer
c ) The following represents part of the facts gathered during an interview about a Sales System: A customer may send zero, one or many
c The following represents part of the facts gathered during an interview about a Sales System:
A customer may send zero, one or many Requests for Quotation RFQ An RFQ is sent by a particular customer.
An RFQ may contain one or many items. An item may be contained in one or many RFQ A customer may send one or many sales orders. A sales order is sent by only one customer.
Using the standard notation, draw an entityrelationship diagram ERD for the above scenario. You are NOT required to resolve any manytomany relationships between the entities.
marks
d Without referencing to the scenario in c above, and by using the Database Design Language DBDL format, identify the relevant data attributes for CUSTOMER and SALES ORDER entities. Show clearly both the primary and foreign keys. Example of a DBDL format: PAYMENT Payment No Date, Amount, Invoice No
marks
Total: marks
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started