Premium Essay

Database Program

In: Business and Management

Submitted By mritchie
Words 647
Pages 3
New Database Program for ACCC
Michele Ritchie
SCI110 – Introduction to Physical Science
Instructor Casey Bethel
February 17, 2016

The Scientific Method
The scientific method is a way to ask and answer scientific questions by making observations and doing experiments. The steps of the scientific method are to ask a question, do background research, construct a hypothesis, test your hypothesis by doing an experiment, analyze your data and draw a conclusion, and communicate your results.

Problem Statement

At American Classic Carpet Care, a nationwide commercial and retail carpet cleaner, we have several different databases that we use for our client base. Each database contains a certain type of business contact. For example, one database is for hotels only, another is for restaurants only. Then, we also have separate databases for local work and out of state work. As you can see, one restaurant or hotel could potentially be put in more than one database. Currently, we use the Pro 2011 version of ACT!. This version is not set up to transfer information from one database to the other automatically. Manually transferring information one client at a time is very time consuming.

Overview of Alternatives

Alternative #1- Upgrade to ACT! Premium: This application allows you to transfer data from one database to the other, along with many other updated features of the ACT! Program. For example, optimized template storage makes it easy to quickly navigate and locate all your templates from one organized library, while keeping compatibility with the latest enhancements to popular business tools like Google Chrome. There is also a Cloud version of this for employees that work off site. This software is priced at $25 per month or $250 for the web version per year and $35 per month or $420 per year for the Cloud version.

Alternative #2- Purchase a new program...

Similar Documents

Premium Essay

Database Program vs. Spreadsheet Program

...Database program Vs. Spreadsheet program When choosing which type of program you should use to manage your customer records, you need to know what the difference is between the two. Spreadsheets are designed to analyze data and sort list items, not for long-term storage of raw data. A spreadsheet should be used for ‘crunching’ numbers and storage of single list items. Spreadsheet programs provide the means for keeping inventory, statistical data modeling, and computing data. They also include graphing functions that allow for quick reporting and analysis of data. Spreadsheet programs are relatively easy to use, require little training to get started, and have the advantage that most data mangers are somewhat familiar with them. The disadvantages of spreadsheets include having to re-copy data over and over again to maintain it in separate data files, the inability to efficiently identify data errors, the lack of detailed sorting and querying abilities, and sharing violations among users wishing to view or change data at the same time. Additionally, spreadsheets are restricted to a finite number of records, and can require a large amount of hard-drive space for data storage. Databases require little or no duplication of data between information tables, and changes made to the data do not corrupt the programming. Databases offer better security to restrict users from accessing privileged information, and from changing coded information in the programming. Furthermore, the......

Words: 415 - Pages: 2

Free Essay

Growth Pattern of Outsourcing

...You are to enter all answers or Prtscrn requirements into this Word Document. You are not permitted to submit any other document format, e.g., Wordpad, PDFs, etc. that is not based on this original Word document. This document contains hidden internal markers and applications that will track the version of this assignment and your assignment progress. You MUST submit the assignments using the Word document(s) provided you. You may not use any other word processor, except Microsoft Word. Do not use Open Office DOCX files. When an instructor has possession of an electronic document it is very easy to detect plagiarism. Many instructors use Turnitin assignments, which is applicable to assignments that permit cut-and-paste as this assignment. It is very easy to compare multiple copies of word documents (see link below). Microsoft provides a variety of FREE anti-plagiarizing tools. And there is a wide variety of tools that can analyze hidden information within a Word document (see sample link below). Changing fonts, margins and spacing does not do it anymore. Even when individuals try to artificially change content, a Word document contains hidden markers that may provide an audit trail to find previous authors and computer systems who have edited the document. Comparing and merging Microsoft Word documents - http://support.microsoft.com/kb/306484 Compare documents side by side -......

Words: 6416 - Pages: 26

Free Essay

Ch. 1 Review Question

...association between entities. One to many relationships is when one entity associates with many other entities but many entities associate with just one. 5. Database is a structure that can store information about multiple types of entities the attributes of those entities, and the relationship between the entities. 6. Using common columns in the two tables creates it. 7. Visual way to represent a database. 8. Program, collection of programs through which users interacts with a database. 9. Determine the structure of the required database. 10. Screen objects used to maintain, view, and print data from a database. 11. The DBMS ask questions about desired content and appearance of each report and then creates the report automatically based on the answer. 12. Data of various users can be combined and shared among authorized users, allowing all users to access greater pool of data. 13. A person or group to be in charge of the database. 14. With the database approach, changing a customer’s address means making on change instead of multiple changes, keeping the consistency. 15. A rule that data must follow in the database 16. Prevention of unauthorized access to the database. 17. Property that let you change the structure of a database without requiring you to change the programs. This prevents them from expending a great deal of effort to update. 18. Occupy a...

Words: 426 - Pages: 2

Free Essay

Determining Databases and Data Communications

...Determining Databases and Data Communications Lucinda Degarmo BIS/320 November 02, 2015 Karl Jaufmann | Scenario 1 As the marketing assistant, I would definitely have to use a program that would track ordering, delivery and losses of any equipment used. The typical fields that would be needed for such database would be the following: Event Name, Event Date, Name of equipment/display, Serial Number, Date ordered, Date shipped, Date delivered, Date packed, Date shipped, Date received, Loss remarks. The first tracking relationships would be of course the Event Name, Event date and Name of equipment, Date ordered. By tracking these fields, I would be able to figure out what types of equipment or displays to order for the event and ensure timely delivery for the event. The second tracking relationships would be the return of the equipment which would include packing date, shipping date and date received and any losses incurred. By tracking the return of the equipment, I would be sure that the equipment has been accounted for and safely returned back to the warehouse. By using a tracking program for each event, the accountability for the equipment is monitored from the day it leaves the warehouse and is returned safely back to the warehouse. A database would definitely be needed to track the inventory. Excel could handle the tracking input and output; however, since the shipping and receipt of the equipment would not be readily available another......

Words: 628 - Pages: 3

Free Essay

Distributed Systems

...Server Training (16 Courses) Training on how to build and manage SQL Server databases. Our SQL Server Training Courses provide the skills needed to build a solid foundation for SQL Server development. Introduction An overview of DBMS technology * How data is accessed, organized and stored * The database development process * Query and application development tools * CASE tools for database analysis and design * Tables, attributes and relationships * Primary and foreign keys * Relational integrity constraints * Manipulating data: selection, projection, join, union, intersection, difference * An integrated, active data dictionary * The query optimizer * Developing the logical data model * Mapping the data model to the relational model * Specifying integrity constraints * Defining the data in the data dictionary * Capturing entities, attributes and identifiers * Describing relationships: one-to-one, one-to-many, many-to-many * Optional and mandatory relationships * Resolving many-to-many relationships for implementation * Generating the SQL to build the database * Reverse engineering to capture the design of an existing database * SQL Programming Language Introduction 1 Days * Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures * Update database content with SQL and transaction handling * Retrieve data with filter conditions and......

Words: 1010 - Pages: 5

Premium Essay

Dbms

...CHAPTER 1 – The Database Environment Database – organized collection of logically related data Data – stored representations of meaningful objects and events Structured – numbers, text, dates Unstructured – images, video, documents Information – data processed to increase knowledge in the person using the data Metadata – data that describes the properties and context of user data Disadvantages of File Processing Program-Data Dependence - All programs maintain metadata for each file they use Duplication of Data - Different systems/programs have separate copies of the same data Limited Data Sharing - No centralized control of data Lengthy Development Times - Programmers must design their own file formats Excessive Program Maintenance - 80% of information systems budget Problems with Data Dependency - Each application programmer must maintain his/her own data - Each application program needs to include code for the metadata of each file - Each application program must have its own processing routines for reading, inserting, updating, and deleting data - Lack of coordination and central control - Non-standard file formats Problems with Data Redundancy - Waste of space to have duplicate data - Causes more maintenance headaches The biggest problem: - Data changes in one file could cause inconsistencies - Compromises in data integrity SOLUTION: The DATABASE Approach - Central repository of shared data - Data is managed by a controlling agent ...

Words: 391 - Pages: 2

Free Essay

Notes on Rdbms

...Relational Database Management Systems TVSN Murthy Assistant Professor – DFT NIFT Hyderabad Disclaimer: These slides are just for the purpose of easy reading and are not comprehensive in nature. Thus the slides have to be read together with the class lectures, reading material, and statutes dealing with the subject RDBMS/Slide 1 Introduction Flat files - 1960s - 1980s Hierarchical – 1970s - 1990s Network – 1970s - 1990s Relational – 1980s – present Object-oriented – 1990s – present Object-relational – 1990s – present Data warehousing – 1980s – present Web-enabled – 1990s - present RDBMS/Slide 2 1 Introduction Data Models Classification Data models can be classified as: 1. 2. 3. File-based systems Traditional Data Models Semantic Data Models File-based Systems: Entities or objects of interest are represented by records that are stored together in files. Relationships between objects are represented by using directories of various kinds. RDBMS/Slide 3 Introduction Data Models Classification Traditional Data Models: Traditional data models are the Hierarchical, Network and Relational Models. Hierarchical Model:- Evolved from the file based system Network Model:- Is a superset of the Hierarchical model. Relational Model:- Is based on the mathematical concept of relation. Semantic Data Models: This class of data models was influenced by the semantic networks developed by artificial intelligence researchers. Semantic networks were developed......

Words: 4443 - Pages: 18

Free Essay

Sd1430 Final

...Chapter 1 Major Topics for Database: 1. Software 2. Software version 3. license agreement 4. machine 5. machine location 6. install date 7. software requests 8. availability 9. software location 10. access level (by who, e.g., student, teacher, admin user, etc.) STATEMENT OF WORK [Draft] History The law requires that any business, including a school, track its software. It is important to know what software the school owns, in what versions, and what the license agreement for that software is. Whatever the license agreement for particular software, it is essential for the institution to know which software is installed on which machine, where that machine is located, and which users have access to that machine. It is also important to track when the software is uninstalled from a machine and when a machine is retired. Grandfield college currently uses several spreadsheets to track this information. They also track requests for new software, software checkouts to faculty with administrative privileges on their machines, and if installs are successful or run into any problems. When requests for software are received, the software management team must manually access a spreadsheet to see if the school has the data. When new software arrives, they must manually check the licensing agreement online when they don’t know off the top of their head. These agreements vary between being accessible to any computer on site via a server install or having a......

Words: 2494 - Pages: 10

Premium Essay

Mis Tutorial Answer Sheet

...file environment and how are they solved by a database management system? List and describe each of the components in the data hierarchy. Figure 6–1 shows the data hierarchy. The data hierarchy includes bits, bytes, fields, records, files, and databases. Data are organized in a hierarchy that starts with the bit, which is represented by either a 0 (off) or a 1 (on). Bits can be grouped to form a byte to represent one character, number, or symbol. Bytes can be grouped to form a field, such as a name or date, and related fields can be grouped to form a record. Related records can be collected to form files, and related files can be organized into a database. Define and explain the significance of entities, attributes, and key fields. • Entity is a person, place, thing, or event on which information can be obtained. • Attribute is a piece of information describing a particular entity. • Key field is a field in a record that uniquely identifies instances of that unique record so that it can be retrieved, updated, or sorted. For example, a person’s name cannot be a key because there can be another person with the same name, whereas a social security number is unique. Also a product name may not be unique but a product number can be designed to be unique. List and describe the problems of the traditional file environment. Problems with the traditional file environment include data redundancy and confusion, program-data dependence, lack of flexibility, poor......

Words: 1013 - Pages: 5

Premium Essay

Efficiency and Collaboration

...changing form Microsoft Excel to Microsoft Access. These two products can be compatible to each other; however each as its own purpose and one can help our sales department better than the other (Sanger, 2012). Functions that are different between them are that Access is a relational database management system and can manage large amounts. Accesses can creat4 relationships between data because it uses flat files and can handle thousands of records. Excel is a spreadsheet and dose math. Excel has limited functionality and can handle up to 15,000 records. (Sanger, 2012). On the effort to increase sales, the corporation decided to use Microsoft Excel systems; it helps not also to increase sales but to have a better communication between the employees. The benefits are highly quantify, starting with the internal work environment, with the use of it the communication between employees is clear and faster, the corporation now can use applications that help to create documents, or prevent the duplication of data. With the use of it the company can avoid errors that can cost money and legal problems to the corporation. It gives the ability to have a better and faster access documents and programs to...

Words: 859 - Pages: 4

Premium Essay

Data Management

...Database Partitioning JOHN OWENS West Florida University Data Management March 18, 2014 Data partitioning is a tool that can help manage the day-to-day needs of an organization. Each organization has unique values that drive business. All organizations have policies and processes that are influenced by their environment and industry. The use of data partitioning can help productivity by recognizing the need to categorize data to tailor unique needs. This approach does require some effort. To transition to a new database approach, organizations need to assess the pros and cons of a database transition. The scale of an organization’s database may be the one factor that drives an adoption of this approach. Data partitioning has been developed to address issues that traditional database queries have created. One main problem that partitioning was created to solve is the performance of database queries. According to Alsultanny (2010), “System performance is one of the problems where a significant amount of query processing time is spent on full scans of large relational tables. Partitioning of the vertical or horizontal partitioning or a combination of both is a reliable way of solving the problem” (p.273). By separating queries into either horizontal or vertical processes, the user can avoid delays and strains on a database. This saves time which can be used to improve the productivity an organization has towards their day-to-day operations. Large-scale......

Words: 1572 - Pages: 7

Premium Essay

What Title ?

...The University Student Registration System: a Case Study in Building a High-Availability Distributed Application Using General Purpose Components M. C. Little, S. M. Wheater, D. B. Ingham, C. R. Snow, H. Whitfield and S. K. Shrivastava Department of Computing Science, Newcastle University, Newcastle upon Tyne, NE1 7RU, England. Abstract Prior to 1994, student registration at Newcastle University involved students being registered in a single place, where they would present a form which had previously been filled in by the student and their department. After registration this information was then transferred to a computerised format. The University decided that the entire registration process was to be computerised for the Autumn of 1994, with the admission and registration being carried out at the departments of the students. Such a system has a very high availability requirement: admissions tutors and secretaries must be able to access and create student records (particularly at the start of a new academic year when new students arrive). The Arjuna distributed system has been under development in the Department of Computing Science for many years. Arjuna’s design aims are to provide tools to assist in the construction of fault-tolerant, highly available distributed applications using atomic actions (atomic transactions) and replication. Arjuna offers the right set of facilities for this application, and its deployment would enable the University to exploit the......

Words: 8052 - Pages: 33

Premium Essay

Management

...Database Management System is a System Software or an Application Software System Software: System software is computer software or an operating system designed to operate and control the computer hardware and to provide a platform for running application software. Actually, system software is any computer software which manages and controls computer hardware so that application software can perform a task. Operating systems, such as Microsoft Windows, Mac OS X or Linux, are prominent examples of system software. System software is not meant to be run by the end user. For example, while you might use your Web browser every day, you probably don't have much use for an assembler program. System software runs at the most basic level of your computer. Application Software: Application software, also known as an application or an app, is computer software designed to help the user to perform specific tasks. Examples include enterprise software, accounting software, office suites, graphics software. Application software applies the power of particular system software to a particular purpose. Applications software (also called end-user programs) includes database programs, word processors, and spreadsheets. Applications software sits on top of systems software because it is unable to run without the operating system and system utilities. Example of system software and application software given in a chart: Database Management System(DBMS): A database management system......

Words: 635 - Pages: 3

Premium Essay

Database Environment

...The Getty Provenance Institute’s database (The Gettys research institute, 2012) contains 1.1 million records. All of these records can be used for a wide variety of research. According to the institute the database can be used for assistance in finding information for Projects, and for the Study of Collecting. According to the Database, “The J. Paul Getty Museum acquired The Entombment (ca. 1612) by Peter Paul Rubens in a Christie's sale in 1992. At that time, the provenance of the painting could only be traced as far back as the mid-19th century. The number 146, located on the face of the painting, appeared to be an inventory number (the Getty Research Institute, 2012). A search in the Provenance Index's Archival Inventories database retrieved a single record in which the artist name (Rubens) and item number (146) matched. The search lead to a 1651 inventory preserved in the Archivo de la Casa de Alba, Palacio de Liria in Madrid, which lists this Rubens painting. Possibly its first owner was Gaspar de Haro y Guzmán Carpio (1629–1687)”. Other Institutions are not as lucky some. Some Museums are not so fortunate to find the item number associated with the picture. When it is time to introduce the collections into a database, curators of small museums find themselves in a little bit of trouble. The features and capabilities offered by the newer commercial and professional collection systems are more than they will ever need, more than they can support and more than......

Words: 1164 - Pages: 5

Premium Essay

Data Base Concepts

...20. Composite keys: In database design, a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence. Each attribute that makes up the compound key is a simple key in its own right. Crow’s feet notation: A type of notation for entity relationships in entity relation diagrams that depicts the many side of a relationship with a three-pronged end called a “crows foot.” This type of notation provides more information about the cardinality of a relationship than the arrow notation for relationships. Domain entities: Those database entities that relate directly to the business problem under consideration. Entity relation diagrams: A diagram that shows entities, their attributes, and the relationships among them. Linking entity: An entity used to resolve a many-to-many relationship into two one-to-many relationships. Logical entity: The design of a database without regard to the physical 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...

Words: 1477 - Pages: 6