Preview

National Restaurant Chain Database

Good Essays
Open Document
Open Document
821 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
National Restaurant Chain Database
Using a database management system (DBMS) is a wise decision for any business that plans to implement the use of a database as part of their IT infrastructure. A database management system, also referred to as a database manager (Rouse, 2005), allows one or many computers to create, query, and manipulate data in the database (Rouse, 2005). The database management system also manages request from users and applications, making the database much more user friendly, since the users nor the applications have to know where the data is physically located for the database (Rouse, 2005). Where multi-user systems are being utilized the database management system does not allow the current user to see who else is accessing the information. The database contains data that needs to be protected from intentional or accidental misuse (Ricardo, 2012). The database management system is instrumental to securing the database; and that system allows the database administrator to setup security restrictions and enforce them on multiple levels, making sure only those with the proper credential have access to the data (Ricardo, 2012). The DBMS also adds to the overall security by having the functionality to encrypt the data before it is stored in the database (Ricardo, 2012). The database management system also helps to ensure database integrity, making sure data is readily accessible and is organized as intended by the database administrator (Rouse, 2005). The DBMS also allows the database administrator to define integrity constraints, which are consistency rules that the database must obey (Ricardo, 2012). Many small businesses are storing their data in programs such as Microsoft Works or Microsoft 's spreadsheet application Excel. These systems can be very difficult for new staff to pickup on and can over complicate and greatly delay the day to day business operations ("db net solutions,”). A database management system like Microsoft Access will give a small to medium sized


References: Ricardo, C. (2012). Databases illuminated. (Second ed., pp. 7-11, 13). Sandbury, MA: Jones and Bartlett Learning, LLC. Rouse, M. (2005, September 25). Searchsql.com. Retrieved from http://searchsqlserver.techtarget.com/definition/database-management-system db net solutions. (n.d.). Retrieved from http://www.dbnetsolutions.co.uk/Articles/ManagingData.aspx Davis, G. B. (1982). Strategies for information requirements determination. 21(1), 13-15. Retrieved from http://zonecours.hec.ca/documents/A2009-1-2145780.Davis-1982.pdf
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Is335010 Assessment Worksheet
    • 575 Words
    • 3 Pages

    Is335010 Assessment Worksheet

    Database administrators should monitor their SQL databases for unauthorized or abnormal SQL injections and write scripts for alarming as well as Simple Network Management Protocol (SNMP) alerts. Additional safeguards can be placed that include encrypting the data elements that reside in long-term storage of the SQL…

    • 575 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Nt1330 Unit 1 Assignment
    • 2207 Words
    • 9 Pages

    Nt1330 Unit 1 Assignment

    This paper gives an idea regarding the important aspects of the database security. It mainly focuses on the security parameters such as confidentiality, authenticity and availability of the data. It also explains the different threats for the security in an organization in relation to the database. The basic steps which are required to control the loss of data are explained in detail. Among the controls the encryption process is the one which has to be followed to control the access into an…

    • 2207 Words
    • 9 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Bis/220 Proposal
    • 315 Words
    • 2 Pages

    Bis/220 Proposal

    Microsoft Access is a system that allows users to manipulate large amounts of data. The different areas and features of Microsoft provide quick learning and easy to use software which can benefit both small and large business environments. The different parts that make up Access are queries, reports, tables, modules and macros. Queries allow the user to pull information from the given tables and calculate using the information filled into the table. Tables associated with Access are used to store data. Information on the tables can be entered on the forms and printer-ready information is displayed on the report portion of Access, These reports can also be exported to Microsoft Excel or Word. The automation of database tasks are done using macros. Modules are used for advanced programming within the database. Microsoft Access is beneficial in the work environment because it incorporates features that are also found in other Microsoft Office applications, the learning curve with Access is not steep at all it is a very easy system to operate. Because of wizards, it is easier to create a database in less than an hour. Another benefit of Access is that it allows the user to integrate large amounts of data not having to sacrifice performance of the system. Information that has already been made available can be transferred over to the Access program. Microsoft Access can e used for both small and large business environments. However, a large office environment allows access to be programmed from the enterprise resource software.…

    • 315 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    ACC T1: Creating A Database Paper
    • 585 Words
    • 3 Pages

    ACC T1: Creating A Database Paper

    A(n) relational database management system provides protection for your data through the use of security, control, and recovery facilities. _________________________…

    • 585 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Database Environment Week 2
    • 799 Words
    • 3 Pages

    Database Environment Week 2

    Each individual workstation will use Microsoft Windows 7 professional x64 service pack 1 for the operating system. The Main database server will use Microsoft Server 2008 R2 x64 for the operating system. The DBMS that will be used will be Microsoft Office Access. A form will be created to add data to the database and make it easy to retrieve data when needed. Reports can be downloaded and printed to show results of the data base inquiry.…

    • 799 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Database Environment
    • 1121 Words
    • 5 Pages

    Database Environment

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Efficiency and Collaboration Proposal
    • 400 Words
    • 2 Pages

    Efficiency and Collaboration Proposal

    Possessing the right collaborative tools when conducting business is essential; we have been using Microsoft Excel at Party Plates for quite some time now. In the search for a database that will be more compatible to hold and organize the data of the company, the capabilities of Microsoft Access will be what we are looking for. We want to highlight some keys elements that would help us in making that for the future of our business.…

    • 400 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Assignment 2- Database Modeling and Normalization
    • 782 Words
    • 4 Pages

    Assignment 2- Database Modeling and Normalization

    References: Coronel, C., Morris, S., & Rob, P. (2012). Database systems. (10th ed.). Independence, KY: Cengage.…

    • 782 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Chapter Review Questions: SOX, Primary CBIS Functions, Event Monitoring
    • 367 Words
    • 2 Pages

    Chapter Review Questions: SOX, Primary CBIS Functions, Event Monitoring

    Consolidating both tasks threaten database integrity. Database Administration is responsible for database security, assigning database access authority to users, monitoring database usage, and planning for future expansion, thus, a need of separating it to other computer center functions must be established.…

    • 367 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    A Discussion of Some of the Nuances of Database Security
    • 2857 Words
    • 12 Pages

    A Discussion of Some of the Nuances of Database Security

    When it comes to the topic of database security head just do not turn the way benchmarking world records and reports of ever-shorter downtimes do. However, security breaches do turn heads as well as undermine customer confidence, as the well-publicized thefts of credit card numbers from a few e-businesses showed in 2000. Databases introduce a number of unique security requirements for their users and administrators. On one hand, databases are designed to promote open and flexible access to data. On the other hand, this same open access makes databases vulnerable to many kinds of malicious activity. Moreover, as more businesses participate in the e-space, it becomes particularly important to separate private from public data. Securing a database involves not only establishing a strong policy, but also establishing adequate access controls. In this paper, we will discuss several of the various nuances of Database security.…

    • 2857 Words
    • 12 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Brief Introduction to Database Concepts
    • 4703 Words
    • 19 Pages

    Brief Introduction to Database Concepts

    Information and data are different. Information is understood by a person. Data are values stored on a passive medium like a computer disk. The purpose of a database management system (DBMS) is to bridge the gap between information and data - the data stored in memory or on disk must be converted to usable information. The basic processes that are supported by a DBMS are: • Specification of data types, structures and constraints to be considered in an application. • Storing the data itself into persistent storage. • Manipulation of the database. • Querying the database to retrieve desired data • Updating the content of the database A database is a model of a real world system. The contents (sometimes called the extension) of a database represent the state of what is being modeled. Changes in the database represent events occurring in the environment that change the state of what is being modeled. It is appropriate to structure a database to mirror what it is intended to model. Databases can be analyzed at different levels: • Conceptual Modeling • Logical Modeling • Physical Modeling…

    • 4703 Words
    • 19 Pages
    Powerful Essays
    Read More
  • Better Essays

    CRITICAL SUMMARY OF ADVANCED DATABASE FUNCTIONS FOR DISTANCE EDUCATION SYSTEM: VIEW CLASSROOM
    • 1166 Words
    • 4 Pages

    CRITICAL SUMMARY OF ADVANCED DATABASE FUNCTIONS FOR DISTANCE EDUCATION SYSTEM: VIEW CLASSROOM

    Due to the mass of data that revolves around us today, a systematic datamanagement system needs to be developed and implemented for organization and quick retrieval of important data. In distance learning systems especially, a large amount of data is communicated and shared between students and educators. Hence, a database is needed for organization of this huge mass of data. Database refers to an organized collection of digital data in a repository and allows users to input, organize, and retrieve data quickly. Database controls redundancy of data, which is prevalent in traditional file systems. It is easier to share files through database and editing can be done by more than one person in a synchronous manner if necessary. Database management system is software that manages the database and the data stored in it. A database management system model describes the protocols for the organization of data in the database and viewing of the data. Examples of database management system models include hierarchical model, network model, object oriented model and relational model (Aznil, 2013).…

    • 1166 Words
    • 4 Pages
    Better Essays
    Read More
  • Better Essays

    Oracle Database 11 G
    • 1761 Words
    • 8 Pages

    Oracle Database 11 G

    Security refers to activities and measures to ensure the confidentiality, integrity, and availability of an information system and its main asset, data. (Coronel, 2010). Database security consists of the mechanisms that protect the database against intentional or accidental threats. Security considerations apply not only to the data held in a database but security breaches can affect other parts of the system. Database security takes into consideration hardware, software, users and the data. To effectively implement security requires appropriate controls, which are defined in specific mission objective. This need for security, while often having been neglected or overlooked in the past , is now increasingly recognized by organizations. The reason for this turnaround is the increasing amounts of crucial corporate data being stored on computer and the acceptance that any loss or unavailability of this data could prove to be disastrous. . ( Connolly, 2005).…

    • 1761 Words
    • 8 Pages
    Better Essays
    Read More
  • Good Essays

    Oracle Features
    • 6482 Words
    • 26 Pages

    Oracle Features

    The main use of the Oracle database system is to store and retrieve data for applications. The features of the Oracle database and related products described in this section are used to create applications. We’ve divided the discussion in this section into…

    • 6482 Words
    • 26 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Database
    • 3760 Words
    • 16 Pages

    Database

    Systems Concepts, 6th Edition, McGraw-Hill 2009. (The 4th and 5th editions are also OK to use.)!…

    • 3760 Words
    • 16 Pages
    Satisfactory Essays
    Read More

Related Topics