Reference no: EM13964758

Create a database.  Write the DDL (SQL) for a data model.

Below is a data model.

This model depicts .  For example, the El Paso facility might transfer (send) 3 inventory items to the Portland facility (receiver of the items).  There are regional facilities and other facilities are assigned to one of the regional facilities.

Hint:  Two relationships between the same two entities means there are two different foreign keys, one for each relationship.

 

 

What to do:

1. Create the DDL statements that build these tables and their relationships.  You do not need to include columns except the primary key and any foreign key(s).  All primary and foreign key fields are required.  These DDL statements should be in one script and all the statements in the correct order for creating the tables.

2.     Create a script to drop all the tables in the correct order.

3.     Submit your two scripts online.  Each script file must have either a TXT or SQL file extension.