What are some programs I could use to execute code such as the following: /* Database Systems, Coronel/Morris */ /* Type of SQL : MySQL */ CREATE TABLE AIRCRAFT ( AC_NUMBER varchar(5), MOD_CODE varchar(10), AC_TTAF float(8), AC_TTEL float(8), AC_TTER float(8) ); INSERT INTO AIRCRAFT VALUES('1484P','PA23-250','1833.1','1833.1','101.8'); INSERT INTO AIRCRAFT VALUES('2289L','C-90A','4243.8','768.9','1123.4'); INSERT INTO AIRCRAFT VALUES('2778V','PA31-350','7992.9','1513.1','789.5'); INSERT INTO AIRCRAFT VALUES('4278Y','PA31-350','2147.3','622.1','243.2'); /* -- */ CREATE TABLE CHARTER ( CHAR_TRIP int, CHAR_DATE datetime, AC_NUMBER varchar(5), CHAR_DESTINATION varchar(3), CHAR_DISTANCE float(8), CHAR_HOURS_FLOWN float(8), CHAR_HOURS_WAIT float(8), CHAR_FUEL_GALLONS float(8), CHAR_OIL_QTS int, CUS_CODE int ); INSERT INTO CHARTER VALUES('10001','2018-02-05','2289L','ATL','936','5.1','2.2','354.1','1','10011'); INSERT INTO CHARTER VALUES('10002','2018-02-05','2778V','BNA','320','1.6','0','72.6','0','10016'); INSERT INTO CHARTER VALUES('10003','2018-02-05','4278Y','GNV','1574','7.8','0','339.8','2','10014'); INSERT INTO CHARTER VALUES('10004','2018-02-06','1484P','STL','472','2.9','4.9','97.2','1','10019'); INSERT INTO CHARTER VALUES('10005','2018-02-06','2289L','ATL','1023','5.7','3.5','397.7','2','10011'); INSERT INTO CHARTER VALUES('10006','2018-02-06','4278Y','STL','472','2.6','5.2','117.1','0','10017'); INSERT INTO CHARTER VALUES('10007','2018-02-06','2778V','GNV','1574','7.9','0','348.4','2','10012'); INSERT INTO CHARTER VALUES('10008','2018-02-07','1484P','TYS','644','4.1','0','140.6','1','10014'); INSERT INTO CHARTER VALUES('10009','2018-02-07','2289L','GNV','1574','6.6','23.4','459.9','0','10017'); INSERT INTO CHARTER VALUES('10010','2018-02-07','4278Y','ATL','998','6.2','3.2','279.7','0','10016'); INSERT INTO CHARTER VALUES('10011','2018-02-07','1484P','BNA','352','1.9','5.3','66.4','1','10012'); INSERT INTO CHARTER VALUES('10012','2018-02-08','2778V','MOB','884','4.8','4.2','215.1','0','10010'); INSERT INTO CHARTER VALUES('10013','2018-02-08','4278Y','TYS','644','3.9','4.5','174.3','1','10011'); INSERT INTO CHARTER VALUES('10014','2018-02-09','4278Y','ATL','936','6.1','2.1','302.6','0','10017'); INSERT INTO CHARTER VALUES('10015','2018-02-09','2289L','GNV','1645','6.7','0','459.5','2','10016'); INSERT INTO CHARTER VALUES('10016','2018-02-09','2778V','MQY','312','1.5','0','67.2','0','10011'); INSERT INTO CHARTER VALUES('10017','2018-02-10','1484P','STL','508','3.1','0','105.5','0','10014'); INSERT INTO CHARTER VALUES('10018','2018-02-10','4278Y','TYS','644','3.8','4.5','167.4','0','10017'); /* -- */ Please tell me how to use the program so I can complete the following tasks: Note: The entire code is not shown above, since there is a 5,000 character limit. Review the tables created (AIRCRAFT, CHARTER, CREW, CUSTOMER, EARNEDRATING, EMPLOYEE, MODEL, PILOT, RATING) by the SQL statement. Create an ERD Diagram for the database tables showing the relationships between the tables. Be sure to identify any primary or foreign keys. Explain SQL statements necessary to perform the following: Create a table with 3 columns with three different data types and add at least 3 records into the table. Delete your table. AviaCo: Change the CREW_JOB titles from ‘Pilot’ to ‘Captain’ and ‘Co-Pilot’ to ‘Co-Captain’. Add a date of birth column to the CUSTOMER table. Remove a row from the CUSTOMER table. Include SQL statements you used as well as returned results of statements.
What are some programs I could use to execute code such as the following:
/*
/* Type of SQL : MySQL */
CREATE TABLE AIRCRAFT (
AC_NUMBER varchar(5),
MOD_CODE varchar(10),
AC_TTAF float(8),
AC_TTEL float(8),
AC_TTER float(8)
);
INSERT INTO AIRCRAFT VALUES('1484P','PA23-250','1833.1','1833.1','101.8');
INSERT INTO AIRCRAFT VALUES('2289L','C-90A','4243.8','768.9','1123.4');
INSERT INTO AIRCRAFT VALUES('2778V','PA31-350','7992.9','1513.1','789.5');
INSERT INTO AIRCRAFT VALUES('4278Y','PA31-350','2147.3','622.1','243.2');
/* -- */
CREATE TABLE CHARTER (
CHAR_TRIP int,
CHAR_DATE datetime,
AC_NUMBER varchar(5),
CHAR_DESTINATION varchar(3),
CHAR_DISTANCE float(8),
CHAR_HOURS_FLOWN float(8),
CHAR_HOURS_WAIT float(8),
CHAR_FUEL_GALLONS float(8),
CHAR_OIL_QTS int,
CUS_CODE int
);
INSERT INTO CHARTER VALUES('10001','2018-02-05','2289L','ATL','936','5.1','2.2','354.1','1','10011');
INSERT INTO CHARTER VALUES('10002','2018-02-05','2778V','BNA','320','1.6','0','72.6','0','10016');
INSERT INTO CHARTER VALUES('10003','2018-02-05','4278Y','GNV','1574','7.8','0','339.8','2','10014');
INSERT INTO CHARTER VALUES('10004','2018-02-06','1484P','STL','472','2.9','4.9','97.2','1','10019');
INSERT INTO CHARTER VALUES('10005','2018-02-06','2289L','ATL','1023','5.7','3.5','397.7','2','10011');
INSERT INTO CHARTER VALUES('10006','2018-02-06','4278Y','STL','472','2.6','5.2','117.1','0','10017');
INSERT INTO CHARTER VALUES('10007','2018-02-06','2778V','GNV','1574','7.9','0','348.4','2','10012');
INSERT INTO CHARTER VALUES('10008','2018-02-07','1484P','TYS','644','4.1','0','140.6','1','10014');
INSERT INTO CHARTER VALUES('10009','2018-02-07','2289L','GNV','1574','6.6','23.4','459.9','0','10017');
INSERT INTO CHARTER VALUES('10010','2018-02-07','4278Y','ATL','998','6.2','3.2','279.7','0','10016');
INSERT INTO CHARTER VALUES('10011','2018-02-07','1484P','BNA','352','1.9','5.3','66.4','1','10012');
INSERT INTO CHARTER VALUES('10012','2018-02-08','2778V','MOB','884','4.8','4.2','215.1','0','10010');
INSERT INTO CHARTER VALUES('10013','2018-02-08','4278Y','TYS','644','3.9','4.5','174.3','1','10011');
INSERT INTO CHARTER VALUES('10014','2018-02-09','4278Y','ATL','936','6.1','2.1','302.6','0','10017');
INSERT INTO CHARTER VALUES('10015','2018-02-09','2289L','GNV','1645','6.7','0','459.5','2','10016');
INSERT INTO CHARTER VALUES('10016','2018-02-09','2778V','MQY','312','1.5','0','67.2','0','10011');
INSERT INTO CHARTER VALUES('10017','2018-02-10','1484P','STL','508','3.1','0','105.5','0','10014');
INSERT INTO CHARTER VALUES('10018','2018-02-10','4278Y','TYS','644','3.8','4.5','167.4','0','10017');
/* -- */
Please tell me how to use the program so I can complete the following tasks:
Note: The entire code is not shown above, since there is a 5,000 character limit.
Review the tables created (AIRCRAFT, CHARTER, CREW, CUSTOMER, EARNEDRATING, EMPLOYEE, MODEL, PILOT, RATING) by the SQL statement. Create an ERD Diagram for the database tables showing the relationships between the tables. Be sure to identify any primary or foreign keys.
Explain SQL statements necessary to perform the following:
Create a table with 3 columns with three different data types and add at least 3 records into the table.
Delete your table.
AviaCo:
Change the CREW_JOB titles from ‘Pilot’ to ‘Captain’ and ‘Co-Pilot’ to ‘Co-Captain’.
Add a date of birth column to the CUSTOMER table.
Remove a row from the CUSTOMER table.
Include SQL statements you used as well as returned results of statements.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
What is the program called that I need to use to execute the code, and how do I do it?
by Bartleby Expert
