Reference no: EM131346124
Assignment - 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).Assignment Presentation:
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, sub-headings, fonts and other ways of improving readability, Systems Design and Analysis is all about clarity of communication.
ASSIGNMENT 2STRUCTURE
• 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?
Task1:
You need to draw ERD for Auto-Part Warehouse that including the types of relationships between the entities.
Task2:
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.
Task 3:
Create fully normalized 3NF table designs for the system.
Task 4:
Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats.
Excel problem-calculate net present value of each project
: Excel Problem-XYZ Co. has an 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows. Calculate the Net Present Value of each project. If XYZ's WACC is 18%, what is the NPV and IRR of eac..
|
Explain the implications of an unlevered firm
: Contrast (provide brief example) and explain the implications of an unlevered firm with that of a levered firm on Net Income and the corresponding risks associated with each approach.
|
Cash and cash equivalents-inventory-account receivable
: What is the relation of assets to: cash and cash equivalents, inventory, account receivable? What is the relation of Total Liabilities and Shareholder Equity to: long term debt, equity, retained earning?
|
You are the financial manager of a company
: You are the financial manager of a company and you are presented with this scenario: the exchange rate is 0.95 $/€, the euro-denominated continuously compounded interest rate is 4%, the dollar-denominated continuously compounded interest rate is 6%, ..
|
Draw an erd for auto-parts warehouse
: CIS5200 Auto-Parts Warehouse - Draw an ERD for Auto-Parts Warehouse indicating the types of relationships between the entities and Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats.
|
Discuss the themes of power-resistance
: Discuss the themes of power, resistance, and equality in the United States in 1865, 1915, and 1965. How did the nation change across these fifty-year periods? With respect to politics, economics, and society, would you describe this change as adva..
|
Write kcl and kvl connection equations for the circuit
: Identify the nodes and at least two loops.- Identify any elements connected in series or parallel.- Write KCL and KVL connection equations for the circuit.
|
Rise of nationalism in the former yugoslavia
: Given the rise of nationalism in the former Yugoslavia, and the subsequent war and ethnic cleansing that followed, was the fall of communism and the Berlin Wall good for everyone in theformerSoviet Union. Why or why not?
|
Battles were fought before and after the great war
: To what extent did World War 1 change the way wars were fought? Tie to Nationalism: How important is it to fight wars on foreign soil? Consider how wars and battles were fought before and after the Great War?
|