Question

you can draw it out it use lucidchart whichever is easier for you. this is database and we are using ERD's

THE FINAL ERD Seminar This is the final ERD. We'll discuss the final marks in the videos Seminar IR Integer Seminar Date Date Seminar Time Time Location Address Seminar Title String Customer Email Address String Cust_Last_Name String Attended-- oCust_First_Name String Cust Address Address CustPhone String Do Not Contact Boolean Customer contacted Contact About_Seminar Contact Contact Date Date - Contact Type String Contact Number Integer Customer_Ordered Invoice Invoice ID Integer Invoice Date Date Payment Type String Subotal Currency Shipping Currency Tax Currency Total Currency Line Hem Line Number H-Order linea Quantity Unit Price Total_Price - Product_Ordered Integer Integer Currency Currency Product Productombet Integer HH Description String Unit_Price Currency Quantity_In_Stock Integer

Answer 1

answer 1: no change

answer 2:

seminar and customer should have m:n relationship as customer may or may not attend the seminar or attend multiple seminar

seminar and contact should have 1: n relationsship with full participation of seminar and partial on contact

customer and contact should have 1: n relationship with full participation of seminar with full participation of customer for acqurinbg the the details of customer

customer and invoice should have m: n full participation on customer side as invoice will generated only when something is ordered , customer may order multiple things

invoice and line number should have 1:n relationship with full participation on invoice as invoice will only be passed if it is generated.

line number and product n:1  full participation on product and partial on the line number .

answer 3:

i think the entity customer should be removed as it is irrelevant , because the custoemr attending the seminar will automatically share the details , then there will be no need for creating such relationship along with such entity.