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

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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