Exercise 3

Solution Notes

Output from running Carol's submission before she processed any student submissions

Output from running Carol's submission after she processed all the student submissions

Carol's submission would receive 3/3.

Students who created a view other than CanadianMusician will receive, at most, 2/3.

Students who created a base tables, instead of a view, for CanadianMusician will receive, at most, 1/3.

The supplied code clearly says

-- Create the view CanadianMusician 

Students who created a view called CanadianMusician, but which contains rows for all musicians, will receive, at most, 1/3.

Students who ignored the instruction

Do not put any other commands in your  ci.sql  file.

will receive, at most, 2/3.

Students who created extra base tables will receive, at most, 2/3.

Some students are still not using the BNF notation correctly.

• < > (angle/pointy brackets) indicate that you need to provide *something*
  The words in lowercase inside the < > are descriptions of the type of *thing* you have to provide.

• [ ] (square brackets) indicate optional words/*things*.

• | indicates that you choose one of the words/*things* on either side of the |.

Do not type in the < >, [ ], or | because these are symbols which belong to the syntax meta-language.

For example
If you see  <your initials>|<your initials>,
do not type in, say,  <cae>  AND  <Carol Edmondson>
type in, say,  cae  OR  Carol Edmondson 

Students who did not update the <description> in the comment will receive, at most, 2/3.

Students who did not make a choice between the options on the other side of a | will receive, at most, 2/3.

[Top]