Question: solve Question 16 4 pts Consider a STUDENT table in a database. There is no student id, so the primary key is a combination of
solve
Question 16 4 pts Consider a STUDENT table in a database. There is no student id, so the primary key is a combination of Name and Birthdate. Each student will declare a major and the Major attribute is a foreign key which references the Department Number, which is the primary key in the DEPARTMENT table of the database. CPhone is an attribute with the student's cell phone number, and it does not reference any other table. Consider the following three cases in the STUDENT table and for each indicate a) whether a NULL value is allowed and b) if allowed, what does the NULL value "mean" in this context. 1) Consider a NULL value in a Birthdate value of a tuple. 2) Consider a NULL value in the Major value of a tuple. 3) Consider a NULL value in a CPhone value of a tuple. Edit View Insert Format Tools Table 12pt ~ Paragraph ~ | BRB 7F| U Av Yy Tv O wordsStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
