Convert the following picture into a schema diagram and write the DDL for the schemas. Time...

Transcribed Image Text:

Convert the following picture into a schema diagram and write the DDL for the schemas. Time Dimension Order ID Order Date Year Quarter Month Customer Dimension Customer ID Customer Name Address City Zip SALES Product ID Order ID Customer ID Employer ID Total Quantity Discount Product Dimension Product ID Product Name Product Category Unit Price Emp Dimension Emp ID Emp Name Title Department Region Convert the following picture into a schema diagram and write the DDL for the schemas. Time Dimension Order ID Order Date Year Quarter Month Customer Dimension Customer ID Customer Name Address City Zip SALES Product ID Order ID Customer ID Employer ID Total Quantity Discount Product Dimension Product ID Product Name Product Category Unit Price Emp Dimension Emp ID Emp Name Title Department Region