Automotive Services Data Base Project Plan

In: Business and Management

Submitted By NEONUNIT
Words 1558
Pages 7
Automotive Services Data Base Project Plan
MGMT404 Project Management
DeVry University Online

26 August 2014

Table of Contents

• Project charter
• Scope statement
• Work breakdown structure
• Network diagram
• Risk management plan
• Resource management plan
• Communication management plan

Project Charter
Automotive Services has been having issues tracking and holding all its customers in its current data base. They have hired Nicholas Guillory to make a new and improved data base system to Improved it’s tracking system and hold 10 times the amount of customers in its data base. This will improve automotive services tracking customers and will be able to hold more customers to expand on its data base systems
This project will create a better and faster way of tracking and looking up customer’s information. It will show information on services performed and when the next service is due. This will be a new redefine customer data base that will produce better and more accurate reports.

Objectives
The new customer data base is designed to meet a growing customer data base. It will help the company keep up with the growing demand of car buyers and services provided. The completion of this project will give the company the ability to better track services and customers. It will also give the company the ability to add more customers in the data base to give it more revenue and gain customers and services in turn increase it profits. It could also look in to what system other companies are using and could use the budgeting is 60,000 to produce a new customer data base.
Project plan complete-08/01
Analysis Complete- 08/25
Developed System Buildup-09/01
System Deployment-09/20
Testing Phase-10/01
Update System-11/01
Finished…...

Similar Documents

Mobile Service Data Base

...ORIENTED PROGRAMMING TOPIC: MOBILE SERVICE DATABASE SUBMITTED TO: SUBMITTED BY: MS AMANDEEP AKSHAYA CHOPRA DEPTT. OF CSE ROLL NO. RD6801A17 REGN NO. 10803670 ACKNOWLEDGEMENT I, Akshaya Chopra, a student of B.Tech- ECE , would like to thank Lovely Professional University for introducing the concept of term paper which is really proving to be helpful in increasing the knowledge of students. I would also like to thank my CSE faculty, Ms Amandeep, for her co-ordination and support in completing this term paper. Lastly I would like to thank my friends without whose help this term paper could not be completed in an effective manner. Akshaya Chopra TABLE OF CONTENT • INTRODUCTION TO THE PROGRAM • ABSTRACT • DISCRIPRTION • RESULT • CONCLUSION • FUTURE SCOPE Introduction to the program This is a program to illustrate the concept of “Mobile Service Database Provider”. In this program we have illustrated various records taking place in a in the company. We have made different functions to implement these records. This project is for “bharti airtel database system” Now we have made a class with the......

Words: 352 - Pages: 2

Data Base

...understanding of how SQL works. •Lots of examples with SQL using MySQL that make understanding the process of contructing SQL queries easy and also using MySQL and to illustrate the mechanism of storing and retrieving information from databases. (If you find any errors, please send me an email and I'll promptly set it right. If there's something you'd like to see here let me know too.) -------------------------------------------------------------------------------- What's a database ? A database is a collection of data organized in a particular way. Databases can be of many types such as Flat File Databases, Relational Databases, Distributed Databases etc. -------------------------------------------------------------------------------- What's SQL ? In 1971, IBM researchers created a simple non-procedural language called Structured English Query Language. or SEQUEL. This was based on Dr. Edgar F. (Ted) Codd's design of a relational model for data storage where he described a universal programming language for accessing databases. In the late 80's ANSI and ISO (these are two organizations dealing with standards for a wide variety of things) came out with a standardized version called Structured Query Language or SQL. SQL is prounced as 'Sequel'. There have been several versions of SQL and the latest one is SQL-99. Though SQL-92 is the current universally adopted standard. SQL is the language used to query all databases. It's simple to learn and......

Words: 6659 - Pages: 27

Good Data Base

...1. Poor information is the quickest way to ruin a good database. The case says that data visualization is used for contextualizing the data. Companies will use data visualization to give the date they are showing emotional impact. One place where data visualization is currently being used to is monitor what is being talked about on social media. Digg is a populat website right now delivers the most talked about new stores. You are able to read news stories and shoare them at your computer, on your phone, or tablet. You also get daily emails with popular stories. Stack is a program that creates a data visualization of the stories that are on Digg. Stories drop into a graph and as the topic gets more hits, the bar on the graph grows. Below is an picture of Stack. All Stack is showing is what topics are being looked at, and the amount of times a topic is being accessed. This give the viewer of this data visualization information about what people are interested in currently. This is helpful data that is easy to read. If the devlopers of this program would of put poor inofmation, or unneeded information into this data visualization, it would have become much more confusing, and it would no longer be a beneficial to the viewer. This data visualization is quick and easy to view and come to a conclusion on. Poor data just confuses the person who is using the visualization to gain information. At my last job my bosses loved seeing an overview of the different......

Words: 553 - Pages: 3

Data Base

...Phoenix Material Determining Databases and Data Communications Read Scenario 1 and Scenario 2 below. Write a paper of no more than 1,500 words in which you respond to the questions designated for both scenarios. Scenario 1: You are a marketing assistant for a consumer electronics company and are in charge of setting up your company’s booth at trade shows. Weeks before a show, you meet with the marketing managers and determine what displays and equipment they want to display. Then, you identify each of the components that need to be shipped and schedule a shipper to deliver them to the trade show site. You then supervise trade show personnel as they set up the booths and equipment. After the show, you supervise packing the booth and all the equipment as well as schedule its shipment back to your home office. When the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all the equipment are returned. If there are any problems due to shipping damage or loss, you handle those problems. Your job is important; at a typical show you are responsible for more than a quarter-million dollars of equipment. • In Scenario 1: o You need to track data about booth components, equipment, shippers, and shipment. List typical fields for each type of data. Provide an example of two relationships that you need to track. o Do you need a database system? If not, can Excel® handle the data and the output? What are the......

Words: 436 - Pages: 2

Data Base Concepts

...implementation of the database. Lookup entity: An entity used to store lookup values such as state names or zip codes. Maximum cardinality: The maximum number of instances of one entity that may be associated with each instance of another entity. Minimum cardinality: The minimum number of instances of one entity that may be associated with each instance of another entity. Naming conventions: Conventions for naming database objects in order to maintain consistency and readability. Physical design: The design of the database within a particular DBMS. The physical design takes account of file systems and disk locations as well as DBMS-specific data types. Surrogate keys: A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. Triggers: A trigger is a collection of SQL commands that are executed when a database event occurs such as an INSERT, UPDATE, DELETE. Weak entities: In a relational database, a weak entity is an entity that cannot be uniquely identified by its attributes alone; therefore, it must use a foreign key in conjunction with its attributes to create a primary key. The foreign key is typically a primary key of an entity it is related to. Chapter 5 Normal forms: a defined standard structure for relational databases in which a relation may not be nested within another relation. Update anomalies: Database normalization is the process......

Words: 1477 - Pages: 6

Data Base

........................................................................................................................... 2 INTRODUCTION ................................................................................................................................... 2 DATABASE MANAGEMENT SYSTEMS .................................................................................................. 2 Database ......................................................................................................................................... 2 Database Management System (DBMS) ......................................................................................... 2 Schemas, Instances and Data Independence.................................................................................. 3 DATA MODELS..................................................................................................................................... 3 Hierarchical Model .......................................................................................................................... 3 Network Model ............................................................................................................................... 4 Relational Model ............................................................................................................................. 5 CHAPTER 2 ..................................................................................................................

Words: 4347 - Pages: 18

Data Base Mgmnt

...1. How important are accurate data for on-line businesses? Accuracy of data is very important for on-line businesses because if the data is at risk it is difficult to manage or handle .The data should be accurate, complete, easily accessible, consistent and relevant as all these characteristics of data promote revenues for the businesses. For example in the case of Media Tech Direct Works it uses the customer contact information i.e. addresses, phone numbers and e-mail addresses to establish points of contacts with its customers and these links has provide sales opportunities and profits for the company. 2. Is technology sufficient to guarantee that data errors will not occur? If not, then what other factors should a business need to consider? Technology helps the organizations to manage their data but it is not sufficient to guarantee that the data errors will not occur because the data degrades over the period of time. In the case of Media Tech they faced the same problem, the customer data was degrading as it was incomplete or obsolete. The factors that a business need to consider is data –scanning and data –matching, with this system the company would be able to identify redundant, fragmented and incorrect data and clean them from the data warehouse. 3. Provide examples of cost savings that can be achieved by reducing data errors? An example of cost saving that can be achieved by reducing data errors is that a business can save more than $250,000 annually by...

Words: 262 - Pages: 2

Blackberry Research Project Plan

...Business Research Project Part 4: Sampling Process and Data Analysis QNT 561 Applied Business Research & Statistics University of Phoenix December 9, 2013 Blackberry Business Research Plan Blackberry was once the leadership in the cell phone industry, but today they are one of the least recognized manufactures for cell phones. Team C will discuss how we plan to increase their revenue by indentifying what customers want and need to choose Blackberry, Inc. as their cell phone provider over any other manufacture. We have administered a survey and we will analyze it to see what customer think about Blackberry products. Furthermore, we will explain the final results of the survey and the various ways in which the survey will help us determine the changes the company will need to undertake to make Blackberry Inc. once again the leading manufacturer in their industry. The Sample Process The population will consist of former, current and possible future customers. Surveys will be emailed, mailed or telephoned to the previously mentioned population. The purpose of the survey is to determine the following: 1. How can we increase sales, revenue, and consumer base? 2. Do we need improved or increased focus on customer satisfaction? 3. What are our marketing and customer service strategies? 4. How can we enhance the Blackberry brand appeal to individuals and professionals? 5. What do we need to do to effectively compete with other cellular phone......

Words: 1519 - Pages: 7

Data Base Esign

...Stephen Favor (CPD121) Assignment Lab 2-3 TR10 1. What is an entity? * An entity is something about which we want to keep data. There are physical entities; something physical in our universe (e.g., a person, place, thing, etc.). There is also a logical entity; something non-physical (e.g., a relationship).Three examples of an entity could be a gun, Airline, and a camera. 2. What is a relationship? * A relationship is a logical connection between records from two or more tables. All relationships can be categorized as one-to-one, one-to-many, or many-to-many. An example of a one-to-many relationship would be a pet store owner and the pets. The Pet Store owner (parent) represents the one, and the pets (children), represent the many. That is given the assumption that the store is owned by a single entity. The Pet Store can have many pets, but the pets can’t belong to many stores. * An example of a many-to-many is brand names-to-cookies. There are many brand names and there are many types of cookies. A brand can make many types of cookies and a cookie type can be made by many different brands. 3. What is an attribute? * An attribute is a property or characteristic of an entity. Three entities and their attributes are (A) gun (make, model), (B) airline (name, model), and (C) A camera (make, type). Part Two 3. What column or columns should be selected as the primary key to best meet the desired properties for a primary key in exhibit 2-17? * I......

Words: 483 - Pages: 2

Project Plan It Professional Services

...SENEVIRATNE   Table of Contents Executive Summary 2 1. Project background 3 2. Drivers for change 3 3. Objectives 3 4. Selecting CRM solution 3 4.1 CRM package evaluation criteria 3 4.2 Vendor selection 4 4.2.1 Creating list of vendors 4 4.2.2 Selecting vendor 4 4.2.3 Recommendation 5 5. High level project plan 5 5.1 Introduction and Objectives of the Project Plan 5 5.1.1 Overview of the Organization 5 5.1.2 Current Situation and Problem 5 5.2 Goals and Objectives 6 5.3 Project Scope 6 5.3.1 Product Description 6 5.3.2 Project deliverables 6 5.4 Project Schedule 7 5.5 Project Budget 7 6. Critical success factors 8 7. Risks and recommended responses 8 7.1 Risk Analysis 8 7.2 Strategies for mitigating risks 9 8. Overview of costs 10 9. Benefits 11 10. Cost Benefit Analysis 11 11. Change Management Strategy 12 12. Communication Plan 13 13. Summary 14 14. Recommendation 15 15. Appendices 15 15.1 Figure 4.1: Detailed CRM package evaluation criteria and questions 16 15.2 Figure 4.2: Scoring of detailed requirements of 3 CRM packages 17 15.3 Figure 5.1: Detailed project schedule 22 15.4 Figure 7.1: Risk analysis table 23 15.5 Figure 9.1: List of benefits 24 15.6 Figure 10.1: Cost benefit analysis 25 Executive Summary This report provides an analysis and evaluation to the Executive Partners of KPMG Melbourne Pty Ltd on the business scope available in the IT Professional Services sector of KPMG. The global financial crisis had presented......

Words: 7711 - Pages: 31

Data Base

...Fundamentos Base de Datos 1. Aplicaciones de los sistemas de datos: Las bases de datos son muy usadas y las mas significativas son: • Banca • Líneas aéreas • Universidades • Producción • Recursos humanos • Telecomunicaciones • Tarjetas de crédito • Finanzas • Ventas El uso de base de datos en estas áreas es esencial y hoy la mayoría de las empresas tienen base de datos. Desde los inicios del internet, una de las cosas mas importantes es tener bases de datos porqué te reduce trabajo y hace mejor las cosas, como por ejemplo las librerías, las consultas de estados de cuenta en un banco, etc. 2. Sistemas de Base de Datos Frente a Sistemas de Archivos Para poder cambiar y modificar la información, el sistema debe tener ciertas aplicaciones de un sistema operativo convencional que permite crear nuevos archivos o modificarlos, y para este proceso de almacenamiento se necesita mantener la información en un sistema de procesamiento. Los inconvenientes son : • Redundancia e inconsistencia de datos • Dificultad de acceso a los datos • Anomalías en el acceso recurrentes • Aislamiento de datos • Problemas de integridad (restricciones de consistencia) • Problemas de atomicidad (sujetas a fallo) • Problemas de seguridad 3. Visión de los Datos Un sistema de bases de datos es una colección de archivos interrelacionados y un conjunto de programas que permitan a los usuarios......

Words: 1102 - Pages: 5

Data Base

...Metadata CustTable Central client register table. Statistic and setup values are defined in this table. | Field name | Data type | Field description | AccountNum | NUMBER(5,0) | Unique identifier of a customer | Name | VARCHAR2(50) | Name of the customer. This name is printed on documents, such as invoices and account statements. | InvoiceAccount | NUMBER(5,0) | Invoice account, to which the customer is linked. The invoice account is the account to which the invoice amount is debited. In the event there is not a specific invoice account, the customer’s account is used in this field. | CrediMax | NUMBER(8,0) | Maximum amount that the selected customer is allowed to have as an outstanding account balance.This amount is always stated in the default currency of the customer. | CountryRegionId | INTEGER | Country/region of the customer address. | Address1 | VARCHAR2(100) | First part of street or postal address line | Address2 | VARCHAR2(100) | Second part of street or postal address line | City | VARCHAR2(50) | City of the customer address | ZIpCode | VARCHAR2(5) | Postal/ZIP code of the customer address. This code is often used for searching and sorting. | State | VARCHAR2(2) | State of the customer address. This field is often used for searching and sorting. | Telephone | VARCHAR2(20) | Customer’s contact telephone number | PaymMode_Typical | INTEGER | Stored, typical payment mode of the customer. Related to PaymMode table | LineOfBusinessID |......

Words: 799 - Pages: 4

Data Base

...Chapter 1 Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. Answer : 1.2. What four main types of actions involve databases? Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. 1.7. Discuss the differences between database systems and information retrieval systems. Exercises 1.8. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. 1.9. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples. 1.10. Specify all the relationships among the records of the database shown in Figure 1.2. 1.11. Give some additional views that may be needed by other user groups for the database shown in Figure 1.2. 1.12. Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2. 1.13. Give examples of systems in which it may make sense to use traditional file processing instead of a database approach. 1.14....

Words: 4933 - Pages: 20

Spanner, Google Data Base

...by google. It is a distributed relational database that can distribute and store data in google’s big table storage system in multiple data centers. Spanner is Google’s scalable, multi-version, globally distributed, and synchronously-replicated database. It is the first system to distribute data at global scale and support externally-consistent distributed transactions. Spanner provides the scalability that enables you to store a few trillion database rows in millions of nodes distributed to hundreds of data centers. When you read data, spanner connects you to data center that is geographically closest and similarly when we write the data, it distributes and stores it to multiple data centers. If in case the data center we try to access has a failure we can read the data from another data center that has a replica of the data. Replication is used for global availability and geographic locality clients automatically failover between replicas. Applications can use spanner for high availability even in the face of wide-area natural disasters, by replicating their data within or even across continents. Spanner’s main focus is managing cross-datacenter. Many applications at google have chosen to use Megastore because of its data model and support for synchronous replication despite poor throughput. Applications can specify con-straints to control which datacenters contain which data, how far data is from its users how far replicas are from each other an how many replicas......

Words: 2222 - Pages: 9

Data Base Management

...1. Data dependence Data illustration incorporates with the requisition function. If there is alteration in the Data, then also there is a difference in the application function. Data independence Data depiction incorporates with operation function. If there is a transition in the Data, it won’t cause a shift in the application program. 2. Structured data It is established data which could efficiently be reclaimed and reserved in the databases as well as warehouses. It assign to the substantial case of the user's situation such as phenomenon and development. Unstructured data It consists of combined use of several media data like pictures, sounds, and video clips. Then, it is reserved as the element of the user's field situation 3. Data It is the illustration of articles and episode which are reserved and acknowledged in the system. It persists in a array of form such as numeric, symbols, 3RQ variables, and so on. For example, database in dr's clinic will have information such as patient name, address, diagnosis, symptoms, and phone number. Information These are the refined data which elevates the information of the specific using it. Data are worthless in their current prospective from so it is pre-refined and illustrated as the information to the user 4. Repository It is the rationalised reserved area for data meaning, table, data relationships and other parts of data system. It......

Words: 689 - Pages: 3

Lagrange: The Flower of Rin-ne (12) | Dvd Photo Slideshow 20 Full. | ↳ Seriály