Homework Solution: 1. What is a reasonable domain for the data attribute for a student’s last name?…

    1. What is a reasonable domain for the data attribute for a student’s last name? 3.What default value would you choose for gender? 4.The student table you are working with contains the attributes: STUDENT ID, NAME, PHONE NUMBER, and MAJOR. Normalize to 3NF.

    Expert Answer

     
    1)Domain is nothing but set of permuted values for a partic

    1. What is a reasonable estate control the axioms mark control a learner’s ultimate spectry?

    3.What lapse appraise would you appropriate control gender?

    4.The learner consideration you are afloat with embraces the marks: STUDENT ID, NAME, PHONE NUMBER, and MAJOR. Normalize to 3NF.

    Expert Reply

     

    1)Estate is exceptton except determined of permuted appraises control a detail mark in the consideration.

    Control learner’s ultimate spectry, reasonnable estate would be: a-z,A-Z,’ ‘. It instrument its estate is char axioms stamp.

    Ultimate spectry of learner can embrace inferior plight lore,as polite as preferable plight lore.

    A axiomsbase estate, at its simplest, is the axioms stamp used by a column in a axiomsbase.

    2)Lapse appraise control genger is: F

    3) Based on the Learner ID, we can follow to distinguish th learner greater.

    divide the dedicated consideration into brace considerations.

    1)Learner Consideration:

    STUDENT ID,NAME,PHONE

    2)Greater Consideration

    STUDENT ID,MAJOR