Question

Consider the tables given below and answer the questions that follow :

Table: Workshop

WorkshopId	Title	NumSpeakers	MeantFor	Fee
551	Time Management	3	Senior Manager	7000
553	App Development	1	Computer Programmer	9000
554	Planning	2	Senior Manager	8000
556	Marketing Strategies	2	Junior Manager	9000

Table: Participant

ParticipantId	Name	WorkshopId
100	Prabhu Shankar	551
101	Dev Sen	554
102	Fauzia Khan	551
103	Tom Winters	553

(i) WorkshopId '552' is missing in the table workshop. Is there any discrepancy (something not correct) ? Give reason for your answer.

(ii) WorkshopId '551' is present twice in the table Participant. Is there any discrepancy ? Give reason for your answer.

Answer 1

(i) Yes, there must be as it is a primary key which must be in Proper order. And if any value in Primary key for any table is missing then that table is lacking that part of the information.

(ii) No, there will not be any discrepancy, as it is the foreign key and foreign key can contain multiple same values.