Assignment 2 S1 2016
CIS5200
Professional Skills for Systems Analysis
Marked out of 100 – Weighting 30%
Due Date: 09/May/2016
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: http://policy.usq.edu.au/portal/custom/detail/studentacademicmisconduct/index.html.
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 S1 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