Seminar eminar ID Integer eminar Date Date Seminar Time Time ocation Seminar Title Address String Customer Email Address String Cust_Last Name String -Attended-Cust_First Name String Address String Boolean Cust Address Cust_Phone Do Not Contact
I need help with the following
As the customer may or may not attend the seminar or several seminars, the seminar and the customer should have a m:n relationship.
With full seminar participation and minimal contact, seminar and contact should have a 1:1 relationship.
For the purpose of learning about the client's information, the customer and contact should have a 1:1 relationship and both should fully participate in the seminar.
Due to the fact that an invoice may only be generated when anything is ordered and that a client may place several orders, full consumer engagement is required.
Because an invoice is only passed if it is generated, it should have a 1:n relationship with every line number.
line number and product n:1 complete involvement on the product and partial on the line number.
Step by step
Solved in 2 steps
