We have a table ORDER with columns like OrderID, OrderDate, CustomerID, ProductID, and

OrderQuantity. Write a SQL code to list order dates and product IDs for the customer ID $$IL$003.$

What changes are required for the below tables to be normalized? Why are such changes

necessary?

CUSTOMER

What are the key differences between Chen's and crow's foot ERD notations? Give three

examples with illustrations.