create table Customer
(
    FirstName varchar(255),
    LastName varchar(255),
    CustID int primary key
    );

create table Contact
(
    CustID int ,
    ContactInformation varchar(255) primary key,
    ContactType varchar(255),
    foreign key (CustID)
    References customer(CustID)

    );

INSERT INTO
Customer
VALUES
("Elaine","Stevens", 101),
("Mary","Dittman",102),
("Skip","Stevenson",103),
("Drew", "Lakeman", 104),
("Eva","Plummer",105)

INSERT INTO
Contact
VALUES
(101, "555-2653", "Work"),
(101, "555-0057", "Cell"),
(102, "555-8816", "Work"),
(104, "555-0949", "Work"),
(103, "555-0650", "Work"),
(101, "555-8855", "Home"),
(105, "Plummer@akcomms.com", "Email"),
(101, "Stevens@akcomms.com", "Email"),
(101, "555-5787", "Fax"),
(103, "Stevenson@akcomms.com", "Email"),
(105, "555-5675", "Work"),
(102, "Dittman@akcomms.com", "Email");