This paper is a database design for a sales contact system.
Written in 2005; 835 words; 3 sources; APA; $ 29.95
Paper Summary:
This paper explains that the purpose of this database is to provide a means by which sales-persons can track contact information about potential customers including the history for each customer contact. The author relates that this database will be relational, using the Oracle database and will be interfaced with other existing database systems, primarily the employee database. The paper states that the data consistency is maintained in this system by means of the system assignment of values, validation of entries and limitations on access. Charts and diagram.
Table of Contents
Database Overview
Business Requirements
Interfaces
Consistency and Validation
Screens and Reports
Tables
1. Customer
2. Customer History
3. Employee
4. Sales Territories
5. City
6. State
7. Phone Number
Entity Relationship Diagram
From the Paper:
"The main business requirement is to allow salespersons access to customer information. Salespersons need to be able to find the customer's phone number and address, but they will have only the authority to add to the Phone Number table, if the customer's number is not already in the table. They also need to be able to view and update the Customer History. Employees may add customers and phone numbers, but they may not delete them. They will not have update authority on sales territories. They also will have no authority to update the City or State tables, except to relate a Customer to City."
We have thousands of high-quality term papers, research papers, essays, book reports and dissertations on every topic. At AcaDemon, you can download those term papers to help you write yours! You can be sure that the term paper, essay, book report or research paper you download are top-quality, competitively priced and high-level work.
This Free Term Paper Abstract is a part of our Term Paper Library.Here you can purchase research papers, examples of essays, academic dissertations, articles, notes, analytical papers, book reports, stories and poems. We have thousands of persuasive, point-of-view, narrative, critical, compare and contrast and other types of essays in our Library. You can also find here Term papers on "Sales Contact Database Design", Essays on "Sales Contact Database Design", Research papers on "Sales Contact Database Design", Student papers on "Sales Contact Database Design", Book reports on "Sales Contact Database Design", Dissertation on "Sales Contact Database Design", Thesis on "Sales Contact Database Design", Summary of paper on "Sales Contact Database Design", Articles written on "Sales Contact Database Design".