Marked out of 100 – Weighting 20%
Due Date – refer to StudyDesk
All assignment submissions must be completed individually via your study desk. 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/student-academic-misconduct/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 #_CIS2000_Student USQ ID
For example, the second assignment for CIS2000 submitted by Jianming Yong, student #
0061234567. If I was uploading this assessment item, my file would be named as follows:
Yong_A2_CIS2000_0061234567.doc
Assignment 2 S1 20015 CIS2000
AutoParts Warehouse
AutoParts 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 fulfill 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.
Assignment 2
Task 1
Draw an ERD for AutoParts Warehouse indicating the types of relationships between the
entities. (30%)
Task 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. (25%)
Task 3
Create fully normalized 3NF table designs for the system. (25%)
Task 4
Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data
formats. (20%)