2.5s Insert Records into Manufacturer Table The Select queries that you have exe
ID: 388061 • Letter: 2
Question
2.5s Insert Records into Manufacturer Table The Select queries that you have executed previously to the Redcat database only require "read" permissions. However, to execute updates to the database "write" permissions are required In order to allow you to update the database, and to have write permission, a separate database schema has been created for each student. Initially this database schema is completely empty. You must add (Create table) the Manufacturer table into this schema before you add the data required for this problem. Your Student Database Schema is completely under your control. You get to add and delete tables and data as required to complete you assignments. Before completing the Insert statements for this assignment, use the following code to create the Manufacturer Table. You can copy and paste it into the work area. You will receive feedback when it executes correctly. If you create it incorreclty and need to create it again, you must first remove the incorrect version with the Drop table Manufacturer SQL statement. Once you have your schema created with the necessary table, you can clear the work area and enter only the statements for this assignment. After you are sure they are working correctly, then you can submit them. Remember only submit the specific SQL statements required by the problem definition Here are the SQL statements to set up your schema Drop table Manufacturer; Create table Manufacturer ( ManufacturerID ManufacturerName Varchar (30) Address Integer Primary Key Not Null Varchar (100) Varchar (50) Char (2) Char (10) Char (15)) Not Null, Not Null Not Null, Not Null, Not Null, ity ate PostalCode PhoneExplanation / Answer
INSERT INTO Manufacturer (ManufacturerID, ManufacturerName, Address, City, State, PostalCode, Phone) VALUES (100, 'Classic Shoes Inc', '521 Schaefer Ave', 'Chino', 'CA', '91710', '714-276-1180');
INSERT INTO Manufacturer (ManufacturerID, ManufacturerName, Address, City, State, PostalCode, Phone) VALUES (101, 'All About Boots', '80 Enterprise Avenue South', 'Secaucus', 'Nj', '17094');
INSERT INTO Manufacturer (ManufacturerID, ManufacturerName, Address, City, State, PostalCode, Phone) VALUES (102, 'Sports Footwear', '22500 S.Vermont Ave', 'Torrence', 'CA', '90502', '310-783-1900');
INSERT INTO Manufacturer (ManufacturerID, ManufacturerName, Address, City, State, PostalCode, Phone) VALUES (103, 'Fancy Feet LLC', '910 S Los Angeles Street #704', 'Los Angeles', 'CA', '90015', '877-740-7732');
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.