1. For the COURSE database in figure 1, write any violation of relational integrity constraints and its corresponding data that cause the violation (if any).

There are three types of relational integrity constraints. Whenever there is a violation of each type of relational integrity constraints in Figure 1, specify the violated integrity constraint and the attribute name and value that caused the violation.

Use the following table to fill out with your answer. Include a violation to each row. (Add more rows as needed).

Violated relational integrity constraint name	Table name that caused the violation	Attribute name that caused the violation	Attribute value that caused the violation

Figure 1. COURSE DATABSE

The PK of STUDENT = {SID}.

The PK of TAKES = {TSID, TCID}

The PK of COURSE = {CID}

SSN is a unique key (or alternate key) for STUDENT.

TSID is a foreign key (FK), which refers to PK of STUDENT.

TCID is a foreign key (FK), which refers to PK of COURSE.

STUDENT
SID	SSN	firstname	lastname	major	GPA	class
11	350-33-5939	Mary	Kay	CS	3.3	Junior
22	359-12-3040	John	Blizzard	IT	2.1	NULL
33	347-90-7731	Barry	Butter	NULL	3.0	NULL
44	318-50-2930	Ron	Beasley	NULL	2.9	Junior
55	343-10-9583	Sam	Farley	CS	3.9	Senior
66	325-76-8869	Aria	Farley	IT	3.9	Senior
88	318-50-2930	Daniel	Robert	SECURITY	3.5	Sophomore
22	360-11-2230	Dwight	Farley	NMT	3.7	NULL
99	347-90-7731	Steph	Fieri	CS	3.1	Senior
TAKES
TSID	TCID			COURSE
44	IT383			CID	cname	dept
55	IT326			IT244	BI	IT
99	IT244			IT340	AI	IT
55	IT378			IT378	DB	NULL
77	IT378			IT383	OS	CS
99	IT340			IT340	ML	IT
44	IT383			NULL	BI	IT