P Pre Langsql Cssfilehk1stylecreate Table Section Courseid #477

</p> <pre><code class="language-sql">Create table section (Course_id varchar (8), Sec_id varchar (8), Semester varchar (6), Year numeric (4,0), Building numeric (15), primary key (course id, sec id, semester, year), foreign key (course id) references course);</code></pre> <p>Which of the following has an error in the above create table for the relation section

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Database Systems Design and Implementation - Reduction to Relational Schemas - Quiz No.1.

Create table section (Course_id varchar (8), Sec_id varchar (8), Semester varchar (6), Year numeric (4,0), Building numeric (15), primary key (course id, sec id, semester, year), foreign key (course id) references course);