All assignment submissions must be completed individually via EASE

Assignment 2 S3 2016
CIS5200
Professional Skills for Systems Analysis
Marked out of 100 – Weighting 30%
Due Date: refer to Study-Desk
All assignment submissions must be completed individually via EASE
(http://ease.usq.edu.au/). Collusion and cheating is considered to be a very serious issue and all
assignments will be closely monitored to ensure that all students are submitting their own work.
This ensures that all students are treated fairly and graded on their own knowledge and work.
It is acceptable to discuss course content with others to improve your understanding and clarify
requirements however you must not discuss the actual assignment solution and the solutions to
assignment questions must be done on your own. You must not copy from anyone, including
tutors and fellow students, nor provide copies of your work to others. Assignments that do not
adhere to this requirement will be deemed as being the result of collusion or cheating. This
may lead to severe academic penalties as outlined in the Student Academic Regulation
Misconduct policy found at:
https://ift.tt/2mWSWWP.
It is your own responsibility to ensure the integrity of your work. It is recommended that you
use passwords to protect your files and ensure that others are unable to access your work. All
assignments must be submitted in electronic form via the link on the Study-Desk by the due
date. Ensure that you read the extension guidelines for this course as posted onto the course
Study-Desk. Only requests that fall within the specified guidelines will be considered. Do not
assume that all extension requests will be approved.
Read each assignment question carefully and refer as required to your course textbook and I/SB
materials. I encourage students to post any queries that they have regarding this assignment
onto the course Study-Desk. An appropriate response will be provided and this enables all
course participants to view the relevant discussion. Please also read the Study-Desk item
regarding contact with the course team prior to directly contacting the course team. For all
assessment item digital file naming convention: When you have an assessment item you need
to upload digitally, please use the following naming convention when saving your digital
document: (If you do not follow this you will lose marks).
Student last name_assignment #_CIS5200_Student USQ ID
For example, the second assignment for CIS5200 submitted by Omar Ali, student #
0061234567. If I was uploading this assessment item, my file would be named as follows:
Ali_A2_CIS5200_0061234567.doc
Assignment 2 S3 2016 CIS5200
Auto-Parts Warehouse
Auto-Parts Warehouse is a small auto parts supplier with locations in several Midwestern metro
areas. The business is based on the idea of discount prices for auto parts that are always in stock
or can be delivered within hours. The owners have decided to computerize their operations to
allow them to better track their business and manage their inventories for just in time deliveries
for sales. Data to be gathered for each customer sale includes invoice number, date, parts
number, cost, retail price. Customer data is collected that includes basic contact information
and vehicles owned, which includes vehicle make and model. For parts that have to be
delivered to the store to fulfil a customer purchase, a transfer request is created. Data associated
with these transfers include tracking number, invoice number, date, parts number, origination
location (store or warehouse) number, destination store number.
Tasks 1:
Draw an ERD for Auto-Parts Warehouse indicating the types of relationships between the
entities.
Tasks 2:
For each of the entities identified, design tables and identify the possible candidate keys, the
primary key, a probable foreign key, and potential secondary keys.
Tasks 3:
Create fully normalized 3NF table designs for the system.
Tasks 4:
Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats.
Tasks 5:
Presentation (cover sheet, clarity, and professionalism).
Good Luck