BCIS 475Chapter 3 – Create a database. Write the DDL (SQL) for a data model.Below is a data model.Th

BCIS 475Chapter 3 – Create a database. Write the DDL (SQL) for a data model.Below is a data model.This model depicts facilities that transfer inventory between facilities. For example, the El Pasofacility 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 foreignkeys, one for each relationship.What to do:1. Create the DDL statements that build these tables and their relationships. You do not need to includecolumns except the primary key and any foreign key(s). All primary and foreign key fields arerequired. These DDL statements should be in one script and all the statements in the correct orderfor 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.