12 Aug Create a new table called “manufacturing_ facility
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.
