Systems Design and Analysis   

 

Assignment Presentation: 

Assignment 2 Instructions

Your assignment should have a professional presentation; including your name, student

number, course and semester only on the cover page. The rest of the assignment should look

like a professional Systems Analyst’s report.

Word Length:

There is no word limit in this assignment, brevity and clarity is more important than volume of

words. As noted above you should pay particular attention to use of headings, subheadings,

fonts and other ways of improving readability, Systems Design and Analysis is all about clarity

of communication.

ASSIGNMENT 2 STRUCTURE

Cover Page 

In this assignment cover page usually includes course code and name, semester, assignment

title, student name, and student ID.

Abstract

Abstract is one of the important parts of reports, research papers, and academic assignments.

The abstract is often the last item that you write, but the first thing people read when they want

to have a quick overview of the whole paper. I suggest you leave writing the abstract to the

end, because you will have a clearer picture of all of your work.

A good abstract should has one well-developed paragraph that is coherent and concise, and is

able to stand alone as a unit of information covers all the essential academic elements of the

full length paper, namely the background, purpose, focus, methods, results and conclusions

contains no information not included in the paper.

Table of Contents

The table of contents usually includes the titles of the first-level headers, and often includes

second-level or section titles (A-heads), and occasionally even third-level titles (subsections or

B-heads).

Introduction

In this assignment introduction usually includes the following:

1- Case study background

2- What is the report about?

 

Task 1:

You need to draw ERD for Auto-Part Warehouse that including the types of relationships

between the entities.

(You need only to draw a diagram)

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.

  1. a) First you need to identify the entities that related to the Auto-Part Warehouse system.
  2. b) Create a table to each entity that you identify as shown below:

 

For example; one of the entities that you identify is Parts.

Part:

Part Number Store Number Part Description Quantity Cost

 

 

The possible Keys

Candidate keys

 

Primary key

 

Foreign key

 

Secondary keys

 

 

Task 3:

Create fully normalized 3NF table designs for the system.

Create 3NF table designs should include all the entities that you identified in Task 2.

Task 4:

Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats.

Students’ answers may include part numbers as an obvious use of codes for a retail store.

Invoice numbers would be an example of sequence codes. A full discussion of codes can be

found on pages 381 – 384.

 

Reference List

Formatting Your Reference List. All documents cited in your assignment must be listed in a

single alphabetical list at the end of the assignment.

Leave a Reply

Your email address will not be published. Required fields are marked *

Systems Design and Analysis   

 

Assignment Presentation: 

Assignment 2 Instructions

Your assignment should have a professional presentation; including your name, student

number, course and semester only on the cover page. The rest of the assignment should look

like a professional Systems Analyst’s report.

Word Length:

There is no word limit in this assignment, brevity and clarity is more important than volume of

words. As noted above you should pay particular attention to use of headings, subheadings,

fonts and other ways of improving readability, Systems Design and Analysis is all about clarity

of communication.

ASSIGNMENT 2 STRUCTURE

Cover Page 

In this assignment cover page usually includes course code and name, semester, assignment

title, student name, and student ID.

Abstract

Abstract is one of the important parts of reports, research papers, and academic assignments.

The abstract is often the last item that you write, but the first thing people read when they want

to have a quick overview of the whole paper. I suggest you leave writing the abstract to the

end, because you will have a clearer picture of all of your work.

A good abstract should has one well-developed paragraph that is coherent and concise, and is

able to stand alone as a unit of information covers all the essential academic elements of the

full length paper, namely the background, purpose, focus, methods, results and conclusions

contains no information not included in the paper.

Table of Contents

The table of contents usually includes the titles of the first-level headers, and often includes

second-level or section titles (A-heads), and occasionally even third-level titles (subsections or

B-heads).

Introduction

In this assignment introduction usually includes the following:

1- Case study background

2- What is the report about?

 

Task 1:

You need to draw ERD for Auto-Part Warehouse that including the types of relationships

between the entities.

(You need only to draw a diagram)

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.

  1. a) First you need to identify the entities that related to the Auto-Part Warehouse system.
  2. b) Create a table to each entity that you identify as shown below:

 

For example; one of the entities that you identify is Parts.

Part:

Part Number Store Number Part Description Quantity Cost

 

 

The possible Keys

Candidate keys

 

Primary key

 

Foreign key

 

Secondary keys

 

 

Task 3:

Create fully normalized 3NF table designs for the system.

Create 3NF table designs should include all the entities that you identified in Task 2.

Task 4:

Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats.

Students’ answers may include part numbers as an obvious use of codes for a retail store.

Invoice numbers would be an example of sequence codes. A full discussion of codes can be

found on pages 381 – 384.

 

Reference List

Formatting Your Reference List. All documents cited in your assignment must be listed in a

single alphabetical list at the end of the assignment.

Leave a Reply

Your email address will not be published. Required fields are marked *