Q1A: The following figures shows three order forms containing order, customer and product details. Draw an entity relationship diagram (ERD) reflecting ALL the data contained in these forms. Write down any assumptions you make including any assumptions made for primary keys and attributes. The ERD must not have any multi-valued attributes.
Q1B: Convert the ERD into a relational model.