Exercise 2

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 called their table a different name from the TVS table which they copied, will receive, at most, 2/3.

See: a1: Creating Test Data

If I had wanted you to call your table a different name from the TVS table, the supplied code would have been:

-- <your initials>|<your name> <date>
-- COMP2400/6240 2006/2

-- Copy one TVS table

create table <new_tablename> as
select * from tvs.<old_tablename>;

-- Add one row of data

<your insert command>

not, as it was:

-- <your initials>|<your name> <date>
-- COMP2400/6240 2006/2

-- Copy one TVS table

create table <tablename> as
select * from tvs.<tablename>;

-- Add one row of data

<your insert command>

Students who ignored the instruction

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

will receive, at most, 2/3.

Some students are still confused by the BNF notation.

• Words without < > around them should be used as the appear.

• < > (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.

[Top]