assignment2_spec - Assignment 2 specification Description...

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

View Full Document Right Arrow Icon
Assignment 2 specification Description Marks out of Wtg(%) Due date ASSIGNMENT 2 100.00 25.00 24 January 2011 IMPORTANT INFORMATION You must submit the assignment electronically by the due date via the EASE link on the study desk. Instructions will be provided on the course study desk. If you are unable to complete the whole assignment, submit what you have done rather than nothing. Section C in particular was designed to provide you with SQL practice. It is only worth ten marks and we urge you to attempt the other sections first. Model answers will be released at 18h00 on 29 January. Submissions will not be accepted after model answers have been posted. You must use the official USQ data modelling and normalization methodology. This methodology is based on Clive Finkelstein s techniques ( SR 2.1 and SR 2.2 ) and all the examples in the lectures, study book and the tutorials use this methodology. If you do not use the USQ methodology, you will probably be awarded a mark of zero. It is perfectly acceptable if you submit neat hand-drawn ERD s. Alternatively, you might wish to use Word. If you use a CASE or drawing tool, you must adapt the drawing to conform to the USQ methodology. This assignment covers much of the same ground as the exam and will provide you with a strong indicator of your level of preparedness for the exam. Many of the questions are at examination standard although the data modelling exercise is somewhat more substantial than what would be expected in an examination setting. A few of the more advanced SQL questions are beyond the exam standard. SECTION A (Data Modelling) (50 marks) FASHION SHOES is a ladies footwear business with over 60 retail outlets in NSW, VIC and QLD. You have been asked to design a data model for the company based upon the following specification:
Background image of page 1

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

View Full DocumentRight Arrow Icon
The business wants to store information about retail stores, as follows: store number, location and a store manager. Each retail store has only one manager but can have several other store staff. Information about staff includes first name, last name, hire date, address, phone, salary and commission. Note that a store manager is also considered a member of staff. A retail store can be one of two types: city store or regional store. A city retail store can order all of its shoe supplies directly from one of the 15 authorised suppliers, each of which may supply multiple city stores. We need to store supplier company name, address, contact name, contact number and email for each supplier. Date of order and status of shipment must be recorded in each shipment from a supplier to a store. A regional retail store does not deal with a supplier directly and we need to record whether the store opens on Sunday. Each retail store, whether city or regional, stocks a number of lines of shoes. A line of shoe is essentially a
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/17/2012 for the course ECON 101 taught by Professor Econnorm during the Spring '11 term at Art Institutes Intl. Minnesota.

Page1 / 6

assignment2_spec - Assignment 2 specification Description...

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

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