Which of the following has an error in the above create table for the relation section
A. Primary key (course id, sec id, semester, year)
B. Foreign key (course id) references course
C. Year numeric (4,0)
D. Building numeric (15)
Answer:A
Which of the following has an error in the above create table for the relation section
A. Primary key (course id, sec id, semester, year) B. Foreign key (course id) references course C. Year numeric (4,0) D. Building numeric (15)
Explanation:It should be replaced by Year Building varchar (15).