This task maps the given conceptual ER model into a logical ER model by following the ER mapping rules discussed in the class. The ER mapping must go through the following design steps and provide the described details:

1) Map unsupported types of attributes in the given ER model. You should show the corresponding portion of the conceptual model that affected by this step. You may reference to the University Application Example (Logical Design) for the presentation and discussion of this mapping step.

2) Implement all relationships using foreign keys. You should show how each relationship is implemented by which foreign key(s) in the logical model. Again, refer to University Application Example (Logical Design) for how to show the mapping details.

3) Convert the entity types in the logical model into relations (textual representation of relations) after the correct completion of Steps 1 and 2 above. It is very important that the logical ER model is consistent with the given conceptual model and the list of mapped relations is consistent with the logical ER model. Otherwise, inconsistency will be regarded as errors

Product a Supplier ProductCode Supplierld Package Order Item Include BarCode Orderitemt DO HHHO Date OfExpiration Quantity Saleindicator UnitPrice ProductName Name Emai Phones Description (Productimage) QuantityOnHand QuantityOnOrder DateOfOrder Address (Street, Street, City, State, ZipCode) Contain Credit Card Lead Time PaymentCode Sales Order UnitCost UnitSalesPrice Charge And SalesOrderk DiscountRate CreditCardNumber CreditCardType Expiration Date ContactName (FirstName LastName) Date OfPurcahse (Quantity Sold ToDate) TOrder Total Customer Account Email (ContactPhone (AreaCode, PhoneNumber, Type)? Name (FirstName, LastName BillingAddress (Name, Street Address, Apartment, City, State, Zip Code) Password Product a Supplier ProductCode Supplierld Package Order Item Include BarCode Orderitemt DO HHHO Date OfExpiration Quantity Saleindicator UnitPrice ProductName Name Emai Phones Description (Productimage) QuantityOnHand QuantityOnOrder DateOfOrder Address (Street, Street, City, State, ZipCode) Contain Credit Card Lead Time PaymentCode Sales Order UnitCost UnitSalesPrice Charge And SalesOrderk DiscountRate CreditCardNumber CreditCardType Expiration Date ContactName (FirstName LastName) Date OfPurcahse (Quantity Sold ToDate) TOrder Total Customer Account Email (ContactPhone (AreaCode, PhoneNumber, Type)? Name (FirstName, LastName BillingAddress (Name, Street Address, Apartment, City, State, Zip Code) Password