Question

Using SQL

1. Create a table (Passenger) based on the specifications below: Field Name Type/Length

PassID text 5 fixed (Primary Key)

PassLName text 25 variable

PassFName text 20 variable

PassAge numeric Maint_DT date

2. Add the 5 records below using the INSERT command. For the Maint_DT attribute use the following Access function “Date()”.

PassID PassLName PassFName PassAge

00001 Morris Lucy 50

00002 Smith Trudy 61

00003 Collins Harry 32

00004 Dean Mark 27

00005 Hunter Alan 12

3. Select all passengers sorted from oldest to youngest.

4. Select PassID, PassLName, and Maint_DT for all records.

Answer 1

Answer ::

Raw Code ::

CREATE TABLE Passenger (

        PassID varchar(5) primary key,

        PassLName text(25),

        PassFName text(20),

        PassAge int,

        Maint_DT date

);

INSERT INTO Passenger VALUES ('00001', 'Morris', 'Lucy', 50, CURDATE()),

                                                    ('00002', 'Smith', 'Trudy', 61, CURDATE()),

                                                    ('00003', 'Collins', 'Harry', 32, CURDATE()),

                                                    ('00004', 'Dean', 'Mark', 27, CURDATE()),

                                                    ('00005', 'Hunter', 'Alan', 12, CURDATE());

SELECT * FROM Passenger ORDER BY PassAge DESC;

SELECT PassID, PassLName, Maint_DT FROM Passenger;