اقتباس:
المشاركة الأصلية كتبت بواسطة fafee
السلام عليكم ورحمة الله
احتاج مساعدة في السؤال الاخير من الواجب الاول لهذه المادة ممكن مساعدة لو تكرمتو
willie’s furniture store sells furniture to customers either big dealers or individuals. When customers arrive on willie’s store, they may be helped by any available salesperson. If more than one salesperson helps the same customer with the same merchandise, any resulting sale to that customer will be credited to all involved salespeople, who will split the sale commission. A sale cannot be made without a salesperson and cannot be involved in more than one customer, but the customer still can make multiple sales in a visit. Information about sales, salespeople, and customers often need to be entered into a database before any transaction involving them have occurred. The following data items (attributes) are of interest for this model:
Customerid, saleid, salespersonid, salespersonname, salespersonmob, cust_name, cust_address, cust_mob, saledate, amount, commissionamountearned
a) create the bnf grammar for sale and salesperson for willie’s furniture store
b) give the minimum and maximum participation cardinalities for the relationships between sale and salesperson, and between sale and customer.
|
ساعدونا ع اﻻقل بحل السؤال هذا 👆