Example 1 Write the SQL create statement for one of the major entities from your ERD from question 2.

Example 2 Briefly describe what steps need to be undertaken to merge the new database with the current database. Note: do not describe or draw the new model, you are to describe what you would do, not do it. Only use brief examples to assist with your explanations

Example 3 Explain how if this system was implemented as a data warehouse it would differ from the OLTP system of the current system. Some of the differences you should address include (but should not be limited to) data structure and types of queries users would address to each system.

Example 4 Explain how you would approach creating a data warehouse using the system you created in the previous questions plus other data that may be available from other sources suppliers, competitors, market trends. Make certain to address some of the most important data cleaning activities related to combining data from distributed sources.

Example 5 Describe the integrity constraints including triggers, domains, and batch processes that you would use to ensure data integrity in one of the main tables(relations).

Example 6 Describe security and recovery plans and procedures for the database you designed in question 2.

you can just ignore question 1, the question 2 answer i has given, just follow question 2 answer to solve other example question

Draw an ER diagram representing a logical model of the relations that you have identified in Question 1. Be sure to show multiplicities, primary keys, and foreign keys. Include any assumptions you have made Note: this diagram uses UML notation. You may use Crow's feet notation. Customer custiD (PK), firstname lastname DOB Email Optin custstadd custcity custpostcode Purchase custiD (PK) (FK) itemID (PK) (FK) purchasedate (PK 1..1 0. Quantity deliverystreetaddress deliverycity deliverypostcode employeeD(FK) storename tem 1..1 itemiD (PK 1.1 Employee employeelD [PK) employeelastname itemname