You are required to transform the given relations into De-Normalized form and provide the resultant table.

Fig. 1 given below reflects the relationship of some specific scenario related with Customer-Order.

Fig. 1: Customer-Order relationship

You are required to transform the given relations into De-Normalized form and provide the resultant table.

Solution:

Here is the given relation's De-Normalized

table_customer_order:

ID

FirstName

Surname

Address1

City

PostCode

ItemOrdered

Date

Price