1. Insert these data into the table student:

    id

    first_name

    last_name

    1

    Jack

    Hanson

    2

    Lon

    James

    3

    Ken

    Jones

  2. Insert these data into the table computer:

    id

    description

    1

    Apple iBook

    2

    Apple PowerBook

    3

    Apple iMac

  3. Insert these data into the table history:

    id

    date_added

    student_id

    computer_id

    comments

    1

    2002-01-08

    1

    2

    Cool new laptop

    2

    2002-01-09

    1

    3

    Workstation

    3

    2002-01-14

    2

    1

    Wireless web

    TIP: When inserting dates, use the YYYY-MM-DD format, where Ys are the year, Ms the month, and Ds the day. If you don't, MySQL will not properly store the information.

    Also, treat the date like text by surrounding it with quote marks. Otherwise, MySQL may think that 2002-01-08 is 2002 minus 1 minus 8, or 1993.

    A command to insert a date would look like this:

    INSERT INTO birthdays (name, birthday) VALUES ('Kevin', '1975-11-18');