Create a new table called “manufacturing_ facility” with the following attributes:

Use the Premier Database
Use SQL to:
1) Create a new table called “manufacturing_ facility” with the following attributes:
 Factory_id – integer, primary key and not null
 Factory_describe – varchar(50)
 Date_opened – date
 State – char(2)
2) Add a field called “factory_id” to the Part table. Add a constraint to the part table that enforces
referential integrity.
3) For the Premiere database, update customer credit limits so that each customer gets a 10%
increase.
For each question, use a screen shot to:
 Show me your query
 Show that your query was successful.
 Show me your database structure displaying the new table as well as the new/updated
information.