Question: 2. Use the Insert Into Command to add your data to each table. Add data to your primary tables first and then to your secondary

2. Use the Insert Into Command to add your data to each table. Add data to your primary tables first and then to

2. Use the Insert Into Command to add your data to each table. Add data to your primary tables first and then to your secondary tables. Also, remember to use the sequence code with your insert statement to add the auto number value to each primary key field. (30 points) DATA TO BE INSERTED Campus 1,IUPUI, 425 University Blyd Indianapolis. 'IN''46202', 317-274-4591',.08 2, Indiana University','107 S. Indiana 3,Purdue University'.'475 Stadium Mall Drive West Lafayette', 'IN',47907', '765-494-1776',.06 IN,47405', '812-855-4848',.07 Position 1,Lecturer', 1050.50 2,'Associate Professor, 900.50 3,'Assistant Professor', 875.50 4.Professor, 700.75 5,Full Professor, 500.50 Members: 1. Ellen','Monk','009 Purnell. '812-123-1234. 2, 5, 12 2,Joe',Brady','008 Statford Hall, "765-234-2345', 3, 2, 10 3.Dave','Davidson','007 Purnell. '812-345-3456', 2, 3, 0 4.'Sebastian','Cole','210 Rutherford Hall, '765-234-2345, 3, 5, 10 5, Michael','Doo','66C Peobody', '812-548-8956', 2, 1, 10 6, Jerome','Clark,'SL 220', '317-274-9766', 1, 1, 12 7,Bob',House^ET 329', '317-278-9098', 1, 4, 10 8,'Bridget,'Stanley', SI 234', '317-274-5678',1, 1,12 9,'Bradley.'Wilson',334 Statford Hall', '765-258-2567', 3, 2, 10 Prices 1,Beer/Wine', 5.50 2,Dessert, 2.75 3,Dinner, 15.50 4.,Soft Drink', 2.50 5,Lunch', 7.25 2. Use the Insert Into Command to add your data to each table. Add data to your primary tables first and then to your secondary tables. Also, remember to use the sequence code with your insert statement to add the auto number value to each primary key field. (30 points) DATA TO BE INSERTED Campus 1,IUPUI, 425 University Blyd Indianapolis. 'IN''46202', 317-274-4591',.08 2, Indiana University','107 S. Indiana 3,Purdue University'.'475 Stadium Mall Drive West Lafayette', 'IN',47907', '765-494-1776',.06 IN,47405', '812-855-4848',.07 Position 1,Lecturer', 1050.50 2,'Associate Professor, 900.50 3,'Assistant Professor', 875.50 4.Professor, 700.75 5,Full Professor, 500.50 Members: 1. Ellen','Monk','009 Purnell. '812-123-1234. 2, 5, 12 2,Joe',Brady','008 Statford Hall, "765-234-2345', 3, 2, 10 3.Dave','Davidson','007 Purnell. '812-345-3456', 2, 3, 0 4.'Sebastian','Cole','210 Rutherford Hall, '765-234-2345, 3, 5, 10 5, Michael','Doo','66C Peobody', '812-548-8956', 2, 1, 10 6, Jerome','Clark,'SL 220', '317-274-9766', 1, 1, 12 7,Bob',House^ET 329', '317-278-9098', 1, 4, 10 8,'Bridget,'Stanley', SI 234', '317-274-5678',1, 1,12 9,'Bradley.'Wilson',334 Statford Hall', '765-258-2567', 3, 2, 10 Prices 1,Beer/Wine', 5.50 2,Dessert, 2.75 3,Dinner, 15.50 4.,Soft Drink', 2.50 5,Lunch', 7.25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

3. Create the tables identified below in the following order: CampusName, Street, City, State, Zip, Phone, CampusDiscount) Campus Position (PositionID, Position, YearlyMembershipFee) Members...

** WRITE AND EXECUTE SQL QUERIES** **TO BE DONE IN SQL** 3. Create the tables identified below in the following order Campus (CampusID, CampusName, Street, City, State, Zip, Phone, CampusDiscount)...

For this lab we will be taking our various tables created from our normalization process and entering them into Oracle. For each of your tables you will use SQL and the CREATE TABLE command to create...

PLEASE PROVIDE SCREENSHOTS Instructions For this lab we will be taking our various tables created from our normalization process and entering them into Oracle. For each of your tables you will use...

For this lab we will be taking our various tables created from our normalization process and entering them into Visual Studio. Create a database with proper statements. For each of your tables you...

Instructions Database For this lab we will be taking our various tables created from our normalization process and entering them into Oracle. For each of your tables you will use SQL and the CREATE...

For this lab we will be taking our various tables created from our normalization process and entering them into SQL Server Management Studio (PATIENT, BED, EMPLOYEE, DEPARTMENT, TREATMENT, TEST)....

A steam turbine receives steam at 6 MPa, 800C. It has a heat loss of 49.7 kJ/kg and an isentropic efficiency of 90%. For an exit pressure of 15 kPa and surroundings at 20C, find the actual work and...

What is the angular speed, in rad/s, of a flywheel turning at 813.0rpm? A) 63.84 rad/s B) 85.14 rad/s C) 13.53 rad/s D) 95.33 rad/s

Burchard Company sold 3 3 , 0 0 0 units of its only product for $ 1 8 . 4 0 per unit this year. Manufacturing and selling the product required $ 2 9 6 , 0 0 0 of fixed costs. Its per unit variable...

There are five openings to a persuasive message and each one needs your help.Number each of your responses. Your opening should introduce the product or idea.Remember to use action-oriented language...

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...