Question

You have been given a university business plan that produced the
following information:

    PERSON: lname, fname, rname, idnum, private, linkblue
        lname, fname, rname are variable length strings
        idnum is type INT and is a key attribute
        private is BOOLEAN
        linkblue is string of 8 characters

    ADDR:  idnum, adtype, streetaddr, city, state, country, zip
        idnum is a foreign key to PERSON.idnum
        adtype is a string in the set {"bill","permanent","local"}
        streetaddr is a variable length string that includes #, street,
            and maybe apt #
        state is a 2 letter char denoting the state
        country is a 2 letter char denoting country
        zip is string no bigger than 10 characters.

    ADVISOR: student, advisor
        student is a foreign key to PERSON.idnum
        advisor is a foreign key to PERSON.idnum

    DIGITAL: smtype, idnum, smaddr
        smtype is a string in the set {"email", "facebook", "twitter"}
        idnum is a foreign key to PERSON.idnum
        smaddr is a variable length string
        There is a primary key on the pair (smtype, idnum)

#5 Write a DML statement for inserting 2 tuples into the PERSON table.

#8 Write a DML statement for inserting 4 entries into the DIGITAL table
   2 for each PERSON.


#9 Write a DDL statement to alter the table schema for ADVISOR to include
   two new columns 'sdate' and 'edate', both of type DATE.


#10 What is the value for the pre-existing tuple's sdate and edate entry
    after you execute the DDL statement from #9?

Answer 1