Question

Student Project Database
Table: STUDENT
Roll No	Name	Class	Section	Registration_ID
11	Mohan	XI	1	IP-101-15
12	Sohan	XI	2	IP-104-15
21	John	XII	1	CS-103-14
22	Meena	XII	2	CS-101-14
23	Juhi	XII	2	CS-101-10
Table: PROJECT
ProjectNo	PName	SubmissionDate
101	Airline Database	12/01/2018
102	Library Database	12/01/2018
103	Employee Database	15/01/2018
104	Student Database	12/01/2018
105	Inventory Database	15/01/2018
106	Railway Database	15/01/2018
PROJECT ASSIGNED
Registration_ID	ProjectNo
IP-101-15	101
IP-104-15	103
CS-103-14	102
CS-101-14	105
CS-101-10	104

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

1. Insert a student record with a missing roll number value.
2. Insert a student record with a missing registration number value.
3. Insert a project detail without a submission date.
4. Insert a record with registration ID IP-101-19 and ProjectNo 206 in the table PROJECT-ASSIGNED.

Answer 1

1. No, Roll No. is the primary key that does not allow a NULL value.
2. Yes
3. Yes
4. Yes.