ICT321 Jul 2010 TMA01 - ICT321 Database Systems: Modelling...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
ICT321 Database Systems: Modelling and Design Tutor-Marked Assignment July 2010 Presentation
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
[ICT321] Tutor-Marked Assignment TUTOR-MARKED ASSIGNMENT This tutor-marked assignment is worth 21% of the final mark for ICT321 Database Systems: Modelling and Design. The cut-off date for this assignment is 29 August 2010. Submit your solution document in the form of a single MS Word file on or before the cut-off date shown above. To avoid problems: • do not send large files such as RTF document • make sure you submit the CORRECT TMA solution file to the CORRECT TMA folder • state clearly “no answer” if you have not answered a question or part of a question ______________________________________________________________ Question 1 [30 marks] This question assesses your knowledge and understanding of SQL. You should be able to answer this question once you have studied Chapter 2 (Introduction to Structured Query Language). All the questions are based on the tables given below. BRANCH Table SKU_DATA Table SIM UNIVERSITY Tutor-Marked Assignment – Page 2 of 5
Background image of page 2
[ICT321] Tutor-Marked Assignment INVENTORY Table Write SQL Statements to: (a) List all the attributes of those SKUs that are under any department relating to Entertainment . (2 marks) (b) List all the attributes of those SKUs that are currently not in stock or not on order and their corresponding branches. (2 marks) (c) Calculate the average stock level for each SKU under the Home Entertainment department, listing the SKU and its stock level. You are to use subquery for this question. (6 marks)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

ICT321 Jul 2010 TMA01 - ICT321 Database Systems: Modelling...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online