Figures 1-24 and 1-25 display the data and relationships within the Clearwater Traders database. Reference these figures when completing the following cases.
1. Based on the description of the Clearwater Traders database, determine the appropriate constraints for each table. Make certain you consider the following constraint types for each table in the database:
o Primary key
o Foreign key
o Check condition
o NOT NULL
o Unique
When drafting your results, list each table name, the constraint type, and the column that is referenced by the constraint.
2. Based on the sample data provided, determine the necessary column definition for each column contained in the following tables:
o CUSTOMER
o ORDERS
o ORDER_LINE
o ORDER_SOURCE
o CATEGORY\
o ITEM
o INVENTORY
Attachment:- Figure 1-24.zip