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: /* 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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

What is the program called that I need to use to execute the code, and how do I do it?

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.