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 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