Part2: All Code for CREATING tables, insert statements and queries. 1 Using your

Question

Part2: All Code for CREATING tables, insert statements and queries.

  

1 Using your Oracle Accounts, Create all tables from Part1.

2 Insert 10 drivers to your Driver table.

3 Insert 5 trains to you Train table.

4 Insert 10 schedules to your Schedule table.

5 Insert 5 routs to your Route table.

6 Insert 10 stops to your Stop table.

7 Using a query, list all drivers in your Driver table.

8 Using a query, list all trains in your Train table.

9 Using a query, list all routes in your Route table.

10 Using a query, list all stops in you Stop table.

11 Using a query, list all schedules in your Schedule table

12 Using a query, list all trains that are driven by the first Driver from question 7.

13 Using a query, find how many trains are driven by the second from question 7.

14 Using a query, find how many trains you have in your Train table.

15 Using a query, list all stops that belong to your first route from question 9.

16 Using a query, find how many stops belong to your second route from question 9.

17 Using a query, find the train that the first driver from question 7 is driving.

18 Using a query, find all drivers associated with Train 2 from question8.

19 Using a query, find all schedules associated with train 3 from question8.

20 Using a query, find how many schedules associated with train 3 from question8

PS i can give u 1000 points

Part2: All Code for CREATING tables, insert statements and queries. 1 Using your Oracle Accounts, Create all tables from Part1. 2 Insert 10 drivers to your Driver table. 3 Insert 5 trains to you Train table. 4 Insert 10 schedules to your Schedule table. 5 Insert 5 routs to your Route table. 6 Insert 10 stops to your Stop table. 7 Using a query, list all drivers in your Driver table. 8 Using a query, list all trains in your Train table. 9 Using a query, list all routes in your Route table. 10 Using a query, list all stops in you Stop table. 11 Using a query, list all schedules in your Schedule table 12 Using a query, list all trains that are driven by the first Driver from question 7. 13 Using a query, find how many trains are driven by the second from question 7. 14 Using a query, find how many trains you have in your Train table. 15 Using a query, list all stops that belong to your first route from question 9. 16 Using a query, find how many stops belong to your second route from question 9. 17 Using a query, find the train that the first driver from question 7 is driving. 18 Using a query, find all drivers associated with Train 2 from question8. 19 Using a query, find all schedules associated with train 3 from question8. 20 Using a query, find how many schedules associated with train 3 from question8

Explanation / Answer

CREATE TABLE DriverDetails

(

);

Select Driver_name from DriverDetails

Select Train_id from TrainDetails

Select distinct Route_id from TrainRoute

SELECT DISTINCT STOP_ID FROM TrainStopping

Select Schedule_Id from TrainTimings

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---