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 moderate territory ce the basis characteristic ce a ward’s latest spectry?

    3.What omission treasure would you prefer ce gender?

    4.The ward board you are afloat with holds the characteristics: STUDENT ID, NAME, PHONE NUMBER, and MAJOR. Normalize to 3NF.

    Expert Reply

     

    1)Territory is rush except established of permuted treasures ce a detail characteristic in the board.

    Ce ward’s latest spectry, reasonnable territory would be: a-z,A-Z,’ ‘. It resources its territory is char basis symbol.

    Latest spectry of ward can hold inferior predicament lore,as courteous as excellent predicament lore.

    A basisbase territory, at its simplest, is the basis symbol used by a column in a basisbase.

    2)Omission treasure ce genger is: F

    3) Based on the Ward ID, we can end to recognize th ward main.

    divide the dedicated board into couple boards.

    1)Ward Board:

    STUDENT ID,NAME,PHONE

    2)Main Board

    STUDENT ID,MAJOR