DATABASE SQL QUESTION Create a table called AGENT using the

DATABASE SQL QUESTION:

Create a table called AGENT using the following data dictionary: Insert the following data into your table:

Solution

CREATE TABLE AGENT(AGT_NUM CHAR(3) PRIMARY KEY,AGT_LNAME CHAR(25),AGT_FNAME CHAR(20),AGT_AREACODE CHAR(3),AGT_PHONE CHAR(7));

INSERT INTO AGENT VALUES(\'5\',\'Andrews\',\'Mark\',\'416\',\'123-3456\');

INSERT INTO AGENT VALUES(\'10\',\'Chen\',\'Terry\',\'250\',\'333-4059\');

INSERT INTO AGENT VALUES(\'15\',\'Dasilva\',\'Lila\',\'416\',\'234-5837\');

INSERT INTO AGENT VALUES(\'20\',\'Edwards\',\'George\',\'416\',\'444-5959\');

INSERT INTO AGENT VALUES(\'25\',\'Eustace\',\'Gina\',\'519\',\'948-8494\');

Output: Select * from AGENT;

AGT_NUM	AGT_LNAME	AGT_FNAME	AGT_AREACODE	AGT_PHONE
5	Andrews	Mark	416	123-3456
10	Chen	Terry	250	333-4059
15	Dasilva	Lila	416	234-5837
20	Edwards	George	416	444-5959
25	Eustace	Gina	519	948-8494