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 serious inclosure control the basis attainment control a tyro’s ultimate call?

    3.What absence treasure would you prefer control gender?

    4.The tyro consideration you are agoing with holds the attainments: STUDENT ID, NAME, PHONE NUMBER, and MAJOR. Normalize to 3NF.

    Expert Tally

     

    1)Inclosure is nothing except determined of permuted treasures control a detail attainment in the consideration.

    Control tyro’s ultimate call, reasonnable inclosure would be: a-z,A-Z,’ ‘. It media its inclosure is char basis image.

    Ultimate call of tyro can hold inferior plight letters,as well-behaved-behaved as better plight letters.

    A basisbase inclosure, at its simplest, is the basis image used by a column in a basisbase.

    2)Absence treasure control genger is: F

    3) Based on the Tyro ID, we can after to perceive th tyro main.

    divide the ardent consideration into couple considerations.

    1)Tyro Consideration:

    STUDENT ID,NAME,PHONE

    2)Main Consideration

    STUDENT ID,MAJOR