Step 2. Use the Insert Into Command to add your data to each table. Add data to

Question

Step 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. Remember to commit your data after you insert data for a given table.

DATA TO BE INSERTED:

Apartment_Building_TBL
(BuildingID, BuildingName, Street, City, State, Zip, Phone)
1, Alpha House 1, 123 Wood Street, Detroit, Michigan, 48763, 234-345-1234
2, Alpha House 2, 234 Birch Avenue, Detroit, Michigan, 48788, 234-456-9876

Employer_TBL
(EmployerID, CompanyName, Street, City, State, Zip, Phone, ContractDiscount)
1, Daimler-Chrysler , 1234 Chrysler Lane, Detroit, Michigan, 12345, 123-098-0987, .075
2, Ford Motor Company, 2345 Ford Road, Ann Arbor, Michigan, 23456, 234-876-8765, .055
3, General Motors , 3456 General's Lane, Grand Rapids, Michigan, 34567, 345-654-6543, .065

Apartment_Type_TBL
(ApartmentTypeID, ApartmentType, PricePerNight)
1, 1 Bedroom, 250.00
2, 2 Bedroom, 200.00
3, 3 Bedroom, 150.00

Trainee_TBL
(TraineeID, LastName, FirstName, PermStreet, PermCity, PermState, PermZip, PermPhone, EmployerID)
1, Avery, Alvin, 123 First Street, Indianapolis, Indiana 46203, 317-123-1234, 1
2, Berry, Bob, 234 Second Avenue, Baltimore, Maryland, 45854, 342-234-2345, 2
3, Callie, Cassandra, 345 Third Lane, Los Angeles, California, 87654, 235-345-3456, 3
4, Dorkman, Donnie, 456 Fourth Road, Cleveland, Ohio, 93038, 928-456-4567, 1
5, Eaton, Easy, 567 Fifth Street, Tallahassee, Florida, 87699, , 2
6, Franks, Frankie, 678 Sixth Avenue, New York, New York, 67890, 678-678-6789, 3
7, Glutton, George, 789 Seventh Lane, Camden, Indiana, 46917, , 1
8, Hilton, Hilly, 890 Eighth Road, Atlanta, Georgia, 89012, 890-890-8901, 2
9, Isaacs, Isaac, 901 Ninth Street, Houston, Texas, 90123, , 3
10, Johnson, John, 2344 Glenwood Street, Indianapolis, Indiana 46239, 317-223-1234, 1
11,  Tanner, Tommy, 342 Hollow Ave, Houston, Texas, 90234, 901-901-93432, 2
12, Flannerson, Jane, 974 Jones Road, Houston, Texas, 90234, 901-903-93456, 2
13, Tubs, Toni, 290 Jackson's Lane, Indianapolis, Indiana 46239, 317-225-1984, 3

NOTE: A few of the trainees do not have permanent phone numbers and it will effect how you implement the Insert commands.

Apartment_Rental_TBL (RentalED, ChecklnDate, CheckOutDate, ApartmentPhone, ApartmentID, TraineelD)

Explanation / Answer

1)

insert into Apartment_Building_TBL values (1,'Alpha House 1','123 Wood Street','Detroit','Michigan',48763,'234-345-1234');

insert into Apartment_Building_TBL values (2,'Alpha House 2','234 Birch Avenue','Detroit','Michigan',48788,'234-456-9876');

commit;

2)

insert into Employer_TBL values (1,'Daimler-Chrysler','1234 Chrysler Lane','Detroit','Michigan',12345,'123-098-0987',0.075);

insert into Employer_TBL values (2,'Ford Motor Company','2345 Ford Road','Ann Arbor','Michigan',23456,'234-876-8765',0.055);

insert into Employer_TBL values (3,'General Motors','3456 General''s Lane','Grand Rapids','Michigan',34567,'345-654-6543',0.065);

commit;

3)

insert into Apartment_Type_TBL values (1,'1 Bedroom',250);

insert into Apartment_Type_TBL values (2,'2 Bedroom',200);

insert into Apartment_Type_TBL values (3,'3 Bedroom',150);

commit;

4)

insert into Apartment_TBL values (1,102,1,1,1,'Yes');

insert into Apartment_TBL values (2,103,1,1,1,'Yes');

insert into Apartment_TBL values (3,104,1,1,2,'Yes');

insert into Apartment_TBL values (4,105,1,1,2,'No');

insert into Apartment_TBL values (5,106,1,1,3,'No');

insert into Apartment_TBL values (6,202,2,1,1,'Yes');

insert into Apartment_TBL values (7,203,2,1,2,'Yes');

insert into Apartment_TBL values (8,204,2,1,3,'No');

insert into Apartment_TBL values (9,205,2,1,2,'Yes');

insert into Apartment_TBL values (10,206,2,1,1,'Yes');

insert into Apartment_TBL values (11,302,3,1,1,'Yes');

insert into Apartment_TBL values (12,303,3,1,2,'Yes');

insert into Apartment_TBL values (13,304,3,1,3,'Yes');

insert into Apartment_TBL values (14,305,3,1,3,'No');

insert into Apartment_TBL values (15,306,3,1,3,'No');

insert into Apartment_TBL values (16,102,1,2,1,'Yes');

insert into Apartment_TBL values (17,103,1,2,1,'Yes');

insert into Apartment_TBL values (18,104,1,2,2,'Yes');

insert into Apartment_TBL values (19,105,1,2,2,'Yes');

insert into Apartment_TBL values (20,106,1,2,3,'Yes');

insert into Apartment_TBL values (21,202,2,2,1,'Yes');

insert into Apartment_TBL values (22,203,2,2,2,'Yes');

insert into Apartment_TBL values (23,204,2,2,3,'Yes');

insert into Apartment_TBL values (24,205,2,2,2,'Yes');

insert into Apartment_TBL values (25,206,2,2,1,'Yes');

insert into Apartment_TBL values (26,302,3,2,1,'Yes');

insert into Apartment_TBL values (27,303,3,2,2,'Yes');

insert into Apartment_TBL values (28,304,3,2,3,'Yes');

insert into Apartment_TBL values (29,305,3,2,3,'No');

insert into Apartment_TBL values (30,306,3,2,3,'Yes');

insert into Apartment_TBL values (31,402,4,2,3,'Yes');

insert into Apartment_TBL values (32,403,4,2,2,'Yes');

insert into Apartment_TBL values (33,404,4,2,3,'Yes');

insert into Apartment_TBL values (34,405,4,2,3,'Yes');

insert into Apartment_TBL values (35,406,4,2,3,'Yes');

commit;

5)

insert into Trainee_TBL values (1,'Avery','Alvin','123 First Street','Indianapolis','Indiana',46203,'317-123-1234',1);

insert into Trainee_TBL values (2,'Berry','Bob','234 Second Avenue','Baltimore','Maryland',45854,'342-234-2345',2);

insert into Trainee_TBL values (3,'Callie','Cassandra','345 Third Lane','Los Angeles','California',87654,'235-345-3456',3);

insert into Trainee_TBL values (4,'Dorkman','Donnie','456 Fourth Road','Cleveland','Ohio',93038,'928-456-4567',1);

insert into Trainee_TBL values (5,'Eaton','Easy','567 Fifth Street','Tallahassee','Florida',87699,NULL,2);

insert into Trainee_TBL values (6,'Franks','Frankie','678 Sixth Avenue','New York','New York',67890,'678-678-6789',3);

insert into Trainee_TBL values (7,'Glutton','George','789 Seventh Lane','Camden','Indiana',46917,NULL,1);

insert into Trainee_TBL values (8,'Hilton','Hilly','890 Eighth Road','Atlanta','Georgia',89012,'890-890-8901',2);

insert into Trainee_TBL values (9,'Isaacs','Isaac','901 Ninth Street','Houston','Texas',90123,NULL,3);

insert into Trainee_TBL values (10,'Johnson','John','2344 Glenwood Street','Indianapolis','Indiana',46239,'317-223-1234',1);

insert into Trainee_TBL values (11,'Tanner','Tommy','342 Hollow Ave','Houston','Texas',90234,'901-901-93432',2);

insert into Trainee_TBL values (12,'Flannerson','Jane','974 Jones Road','Houston','Texas',90234,'901-903-93456',2);

insert into Trainee_TBL values (13,'Tubs','Toni','290 Jackson''s Lane','Indianapolis','Indiana',46239,'317-225-1984',3);

commit;

6)

insert into Apartment_Rental_TBL values (1,'12-Jan-2010','15-Jan-2010','(111)111-1111',1,1);

insert into Apartment_Rental_TBL values (2,'12-Jan-2010','15-Jan-2010','(333)333-3333',3,4);

insert into Apartment_Rental_TBL values (3,'12-Jan-2010','15-Jan-2010','(333)333-3333',3,7);

insert into Apartment_Rental_TBL values (4,'15-Jan-2010','17-Jan-2010','(222)222-2222',2,2);

insert into Apartment_Rental_TBL values (5,'12-Jun-2009','20-Jun-2009','(444)444-4444',4,2);

insert into Apartment_Rental_TBL values (6,'12-Jun-2009','20-Jun-2009','(444)444-4444',4,5);

insert into Apartment_Rental_TBL values (7,'1-Apr-2010','3-Apr-2010','(555)555-5555',28,8);

insert into Apartment_Rental_TBL values (8,'1-Apr-2010','3-Apr-2010','(555)555-5555',28,3);

insert into Apartment_Rental_TBL values (9,'1-Apr-2010','3-Apr-2010','(555)555-5555',28,6);

insert into Apartment_Rental_TBL values (10,'22-Mar-2011','25-Mar-2011','(666)666-6666',14,1);

insert into Apartment_Rental_TBL values (11,'22-Mar-2011','25-Mar-2011','(666)666-6666',14,4);

insert into Apartment_Rental_TBL values (12,'22-Mar-2011','25-Mar-2011','(666)666-6666',14,7);

insert into Apartment_Rental_TBL values (13,'15-Mar-2011','25-Mar-2011','(777)777-7777',15,2);

insert into Apartment_Rental_TBL values (14,'15-Mar-2011','25-Mar-2011','(777)777-7777',15,5);

insert into Apartment_Rental_TBL values (15,'15-Mar-2011','25-Mar-2011','(777)777-7777',15,8);

insert into Apartment_Rental_TBL values (16,'10-Mar-2011','27-Mar-2011','(888)888-8888',29,3);

insert into Apartment_Rental_TBL values (17,'10-Mar-2011','27-Mar-2011','(888)888-8888',29,6);

insert into Apartment_Rental_TBL values (18,'10-Mar-2011','27-Mar-2011','(888)888-8888',29,9);

insert into Apartment_Rental_TBL values (19,'27-Mar-2011','2-Apr-2011','(444)444-4444',4,3);

insert into Apartment_Rental_TBL values (20,'27-Mar-2011','2-Apr-2011','(999)999-9999',5,2);

insert into Apartment_Rental_TBL values (21,'5-Apr-2011','10-Apr-2011','(999)111-1111',8,1);

insert into Apartment_Rental_TBL values (22,'5-Apr-2011','10-Apr-2011','(999)111-1111',8,4);

commit;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.