Thursday, December 13, 2007

DSM assignment

For 1c
"You have to populate the given tables with relevant data",
  • insert around 5 records... (at least 3)

  • no need to include method you used to insert

  • "it will be good" (most likely more marks) to know how to use those 3 methods taught in class

  • MUST include primary key as marks are given...

  • no need to include foreign keys and no extra marks if you included

for 1e(i)
"select * from inventory.product"
  • this question is asking for the result of "select * from inventory.product" to be displayed

  • there are afew methods to do for (i) and (ii) but "implement appropriate objects"...

for 1f
include all sql statements for all parts

Labels:

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home