Draw an erd for auto-parts warehouse

Assignment Help Other Subject
Reference no: EM131339800

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).

Systems Analysis

- 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.
You need only to draw a diagram

- 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.

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

- 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.

Reference no: EM131339800

Questions Cloud

What is the classical hamiltonian for this system : Calculate the partition function in closed form, under the assumption that the molecule is much smaller than the box it is in. That is, let the limits on the integral over the separation between the atoms in a molecule extend to ∞.
Wreite a thesis and outline on non-lethal weapons : Wreite a Thesis and outline on Non-Lethal Weapons. Military's involvement in the drug war, NCO 2020, NCOPDS, Contractors in theater, Civilian leadership of the military and Israel and its strategic importance.
Control function analysis-purpose of assignment : Students learn to understand associate and leadership involvement in creating metrics that fit the organization's culture and strategy.They will also be able to successfully track progress to goals.
Difference between normal and abnormal behavior : Regarding the difference between normal and abnormal behavior, which statement is TRUE? Frequent nightmares, insomnia, and intrusion of painful memories are symptoms commonly associated with
Draw an erd for auto-parts warehouse : CIS5200 - Professional Skills for Systems Analysis - Draw an ERD for Auto-Parts Warehouse indicating the types of relationships between the entities and Create fully normalized 3NF table designs for the system.
What is the temperature dependence of the specific heat : What is the temperature dependence of the specific heat at low temperatures?
What were the arguments used by the defenders of the study : What were the ethical principles violated in the interaction between patients and doctors? What other parties had interests in this case and what were these interests? What were the arguments used by the defenders of the study to justify its executio..
Estimate the average temperature of the earth : From the nature of your assumptions in the previous question (rather than your knowledge of the actual temperature), would you expect a more accurate calculation with this data to give a higher or lower answer? Explain your reasons clearly to obta..
In what ways is non-state actor different from nation-state : In what ways is a non-state actor different from a nation-state? Please be specific and give examples of each to support your argument.

Reviews

len1339800

1/4/2017 12:00:10 AM

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).

len1339800

1/4/2017 12:00:04 AM

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.

len1339800

1/3/2017 11:59:33 PM

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).

len1339800

1/3/2017 11:59:16 PM

i want this assignment to be done without plagirism ...... this time i have to score atleast 90% to get passed in the subject ............ and i want the assignment well present with all the thing like table of content etc..... what ever is in the criteria file 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.

Write a Review

Other Subject Questions & Answers

  Social change and motivational factors

Explain social change and motivational factors that would be necessary to ensure that social change happen and consider which motivational theory might best support your argument.

  Advantages and disadvantages associated with strategies

What kind of corporate-level strategies did News Corp pursue to build its multibusiness model - what are the advantages and disadvantages associated with these strategies?

  Include a definition of culture and help me with two ways

include a definition of culture and help me with two ways culture influences human psychology along with a specific

  Dissertation chair or dissertation committee

Explain why you selected each person and what role (i.e., dissertation chair or dissertation committee member) you think each would play on your committee.

  Communications-transportation and increased trade

The linking of the world's nations by fast communications, transportation, and increased trade has created what sociologists refer to as ________.

  What is meditation

What is meditation? Please include a basic definition, types and techniques in the discussion. In what ways could the quality of your life change for the better if/when a person meditates regularly? Explain and please provide references.

  Explain van dyck personality of his profession

What was Van Dyck personality his profession and his involvement in the peach war? Who came along to attempt reparation of Native American relations? And we're they successful?

  What are environmental benefits of the given energy source

What are the environmental benefits of this energy source? What are the environmental downsides, if any, to this renewable energy technology? Analyze the risks to human health associated with this technology.

  Drive the decision-making process

Correlation is also used extensively by the pharmaceutical industry when studying the effect of one variable on another. In healthcare, correlation is used to drive the decision-making process.

  Intelligence analyst

Your intelligence analyst told you he is observing a unit that travels to its refueling point the same time and way everyday, and he believes you can destroy them with one air strike this time tomorrow. This unit is displaying which OPSEC indicator?

  Middle eastern culture vs. anglo-american culture

Need help comparing and contrasting information on Middle Eastern culture vs. Anglo-American culture. Need info on culture food way's, rites of passage, beliefs and values.  Need book titles or articles available online that can help me. My local lib..

  Any sports-related article

Choose any sports-related article for this assignment, provided that: (1) it comes from a printed magazine, newspaper, or scholarly journal (examples include but are not limited to: Newsweek, New York Times, Chicago Tribune, Sports Illustrated, Jo..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd