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