Question

Based on the table given below, answer the following questions.

STUDENT

StudentID StudentName IC # CourseCode Intake

1001 Alice 12543456 123CMC   060906

1002   Dominic   62361335 458BIT   050906

1003   Kate   39334631 123CMC   060906

1004   James 95215345 123CMC   060906

a) What is the name of the above relation?

b) Give an example of an attribute.

c) What is the domain of StudentID and CourseCode .

d) What is the degree of the above relation?

e) What is the cardinality of the above relation?

f) Give an example of Primary Key (PK).

g) Give an example of Foreign Key (FK).

h) Give an example of Supper Key.

Answer 1

Thank you. Please give an upvote. If any queries or changes needed please comment will respond ASAP!!!!