Advertisements
Advertisements
Question
Add foreign key in the ATTENDANCE table (use figure to identify referencing and referenced tables).
Code Writing
Advertisements
Solution
ALTER TABLE ATTENDANCE
ADD FOREIGN KEY (RollNumber)
REFERENCES STUDENT (RollNumber);
- Referencing table:
ATTENDANCE - Referencing attribute:
RollNumber - Referenced table:
STUDENT - Referenced attribute:
RollNumber
shaalaa.com
Is there an error in this question or solution?
