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