Question

For the above given database STUDENT-PROJECT, can we perform the following operations?

a) Insert a student record with missing roll number value.
b) Insert a student record with missing registration number value.
c) Insert a project detail without submission-date.
d) Insert a record with registration ID IP-101−19 and ProjectNo 206 in table PROJECT-ASSIGNED.

Answer 1

a) No, because Roll No is a primary key and for primary key column value is mandatory.

b) No, because Registration_ID is a primary key and for primary key column value is mandatory.

c) Yes, it is possible because it may be the case that the deadline may not be known when the project is given, in that case, NULL will be present in the SubmissionDate column.

d) No, because there is no information about this project in the Project table and also no information about which student's registration id is IP-101-19.