Question 1 Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course (Primary Key is mark post-fix with #): !"$%!(%#& %ame& 'aor& date) C*"+$(Course#& Cname& ept) $%+*,,(%& Course#& uarter& .rade) **K/0*P!1*%(Course#& uarter& ook/1%) !$2!(ook/1%#& ook/!itle& Publisher& 0uthor) raw a relational schema diagram specifying the foreign keys for this schema3
olution:
ENROLL *
STUDENT *
COURSE *
BOOK_ ADOPTION * TEXT *
Question 2 .i4en the 1n4oice table with following initial structure (Primary Key is mark post-fix with #)
Please: 53 73
%ormali6e that table structure to the first& second and third normali6ation forms raw relational schema diagram for the tables defined in the third normali6ation form abo4e