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.
Homework Solution: 1. What is a reasonable domain for the data attribute for a student’s last name?…
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