database management system

database management system and sql server assignment

CIS2002 Assignment 1 2014

Assignment 1 specification

Description	Marks out of	Wtg(%)	Due date
ASSIGNMENT 1	100.00	7% ONC / 10% EXT	25 April 2014

IMPORTANT INFORMATION

There are 3 sections to this assignment.  You are required to attempt all sections and all questions.

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

 

SECTION A (APPLIED DATABASE THEORY) (20 marks)

FABILOUS FASHION is a ladies apparel business with over 60 retail outlets in NSW, VIC and QLD. The company wishes to develop a system that controls and manages their inventory to better coordinate operations between their outlets and three warehouses in the three states.

The company head office in Melbourne has initiated development of a database-driven inventory management system. The general manager of the company wants to develop the system in the head office with web-based access for all store and warehouse managers from their offices. The project proposal has recently been approved and initial requirements gathering and analysis has been undertaken.

As part of the next phase in the project, the project manager has appointed you as the data analyst/ modeler and you are responsible for refining the data requirements for the project and modelling the database for the system. The project manager firstly wants you to research the expectations that database users (data entry/ admins), store managers and warehouse managers may have for the new database-driven inventory system during a stakeholder analysis.

Write a memorandum to the project manager and present your research findings on the expectations of the three different types of users. Your memorandum should be no longer than 500 words.

A template for the memorandum will be placed on the Study Desk in the ASSIGNMENTS folder. You should use this template. Selected Reading 1.3 is a good starting resource to study for this case.

You are expected to present solutions like an IT consultant’s report in a memo format. You are required to extensively research on the relevant topics and present concise and workable solution.

There is no requirement for formal in-text referencing in this question. However, it is recommended to put a list of references at the end of the memo showing the published materials that you researched while answering this question.

SECTION B (SQL) (40 marks)

For each question, three marks will be awarded for the SQL and one mark for the correct output. 

 Get Professional Help with Your Research Essay Paper Today From Our Student Essay Service!