Tracking and ERD systems

Tracking System:
Describe the current tracking system being used, if any. Create Entity Relationship Diagram (ERD) of the
proposed tracking system entities and their relationships. Create a tracking system and incorporate
screenshots that clearly represent data tracked, examples of report(s), forms used, and at least 5 fields
recorded in your proposed tracking system recommendation. Submit to the dropbox by the due date (listed
on course calendar).
What are ERDs?
Entity Relationship Diagrams illustrate how entities relate to each other within a system. There are five
main components of an ERD:
Entities – represented by rectangles, object or concept of information stored
Actions – represented by diamond shapes, show how two or more entities share information in the
database
Attributes – represented by ovals, key attribute is the unique and distinguishing characteristic of the entity
Connecting lines – solid lines that connect attributes to show the relationships of entities in the diagram
Cardinality – specifies how many instances of an entity relate to one instance of another entity
Tracking System:
Research current system (if any) in place. Describe in a short paragraph the current system and what is
working and what is not working. Include business needs below the current system to describe your
findings and new system requirements. Next, create ERD to illustrated proposed new tracking system.
Describe in a short paragraph the recommendation of proposed tracking system and give a supportive
reasoning statement of why the business should choose this option. In addition, add a Rationale: list of 3-5
bulleted business benefits this tracking system would offer the company. Finally, create tracking system
(MS Access one useful tracking system that could be used) to demonstrate to company proposed
recommendation and include multiple screen shots of the system. (Screenshots: data entry of new
customers, forms, reports that could be generated, customer orders, etc.)
Example:
Project Tracking System Requirements:
Observation of current company has MS Excel spreadsheet tracking customers which does…
Viable plan options include… [Include a EFD, bulleted of 3-5 business benefits, screen shots of proposed
new system and reference the data in the recommendation paragraph]….
The following information is kept about each product: a product identification number name, price, weight,
value.
Ford keeps the following information about the flow and cost data for all distribution centers to dealer
channels: distribution center identification number, dealer identification number, product identification
number, the number of miles between each distribution center and its dealers using the road network, the
quantity of products being shipped and the dollar value of the shipment.