Preview

relational database summary

Good Essays
Open Document
Open Document
485 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
relational database summary
Accounting Information System
Summary of Relational Database
1. Relational databases underlie most modern integrated AISs.
a. They are the most popular type of database used for transaction processing.
b. In this chapter, we’ll define the concept of a database.
2. Database systems were developed to address the problems associated with the proliferation of master files.
a. For years, each time a new information need arose, companies created new files and programs.
b. The result: a significant increase in the number of master files.
3. A database is a set of inter-related, centrally coordinated files.
4. A database management system (DBMS) serves as the interface between the database and the various application programs.
5. Database technology provides the following benefits to organizations:
a. Data integration
b. Data sharing
c. Reporting flexibility
d. Minimal data redundancy and inconsistencies
e. Data independence
f. Central management of data
g. Cross-functional analysis
6. The DBMS handles the link between the physical and logical views of the data.
a. Allows the user to access, query, and update data without reference to how or where it is physically stored.
b. The user only needs to define the logical data requirements.
7. Schemas
a. A schema describes the logical structure of a database.
b. There are three levels of schema.
i. Conceptual level ii. External level iii. Internal level
8. Changing a database
a. The set of commands used to change the database is known as data manipulation language (DML). DML is used for maintaining the data including:
i. Updating data ii. Inserting data iii. Deleting portions of the database
9. A DBMS is characterized by the type of logical data model on which it is based.
a. A data model is an abstract representation of the contents of a database.
b. Most new DBMSs are called relational databases because they use the relational model developed by E.F. Codd in 1970.
10. The relational data

You May Also Find These Documents Helpful

  • Powerful Essays

    Pt2520 Unit 6

    • 1447 Words
    • 6 Pages

    DBMS, a collection of programs that are stored, managed and simultaneously given controlled access to the end users to create, modify and delete.…

    • 1447 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Unit 6 True

    • 287 Words
    • 1 Page

    SQL is the programming language used to manipulate data and data objects in a relational database management system. TRUE…

    • 287 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    unit 6

    • 360 Words
    • 2 Pages

    4) DML, or Data Manipulation Language, contains all the commands for selecting and modifying data.…

    • 360 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    data to be ready for producing meaningful output from the DBMS?d) 5 What are two main forms of output from a DBMS? Provide one example of each form of output using…

    • 1445 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    4. Building the physical database: The database model will be constructed into the actual database program.…

    • 358 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    3. The database scheme: the specifications of the logical structure of the data stored in the database.…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    MIS Section3&4

    • 255 Words
    • 2 Pages

    7. The specialized language programmers use to add and change data in the database is called:…

    • 255 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    During the Enlightenment, American colonies and established European countries faced the difficulties of shifting economic system, religious system, and a shift in mindset. The monarchs of the European countries used enlightened ideas in order to advance. Colonization was at its peak and the rise of mercantilism and the price revolution broke its breaks. Due to the shifting economic structure, slaves were utilized as an alternative to paid laborers. This however, was not reasonable from the perspective of the enlightened. They viewed it as unreasonable, selfish, and manipulative. The supporters of slavery argued that slaves were a necessity in the shifting economic structure. Supporters also argued that slavery wasn’t as severe as it was…

    • 981 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Week 3

    • 754 Words
    • 4 Pages

    6. The type of logical database model that treats data as if they were stored in two-dimensional tables is the (Points : 1)…

    • 754 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Fated4Life

    • 971 Words
    • 4 Pages

    a. Database stores information about each data item just once and makes it immediately available to all functions in an organization (avoiding redundant data)…

    • 971 Words
    • 4 Pages
    Powerful Essays
  • Better Essays

    Prescription Drug Abuse

    • 1483 Words
    • 6 Pages

    The audience I will be addressing is parents, caregivers and school educators about the dangers of prescription drugs and how we can better educate teenagers and young adults on the dangers of abusing them. There are many ways that we can teach and educate our teenagers and young adults, but it’s important that families, schools and communities are involved. The rate of prescription drug overdose among teenagers and young adults have sky rocketed over the past several years. This has become a growing epidemic and if we don’t step in and do something, this problem will only get worse. No parent or caregiver ever wants to lose a child and it can be especial harder knowing that you could have helped prevent it. Some people say it’s the schools job to education this subject and others say that education starts at home. Where can our parents/caregivers get the information they need to help better understand the problem itself and to help safe guard their children? Who would be the best influence to talk to our teens and young adults? In my essay I will explain why it’s so important that schools and parents/caregivers need to both educate and talk to our young adults and teens. (205)…

    • 1483 Words
    • 6 Pages
    Better Essays
  • Good Essays

    “A database is a tool for collecting and organizing information ("Database Basics", 2012).” This is the simplest definition of a database. A database can take many different forms, it can be an address book, a box of recipes, even a collection of business cards. For the purposes of this paper I will be referring to a database as the electronic version found on a computer, such as Microsoft Access.…

    • 432 Words
    • 2 Pages
    Good Essays
  • Good Essays

    The evolution of the information age demanded robust management systems for storing large volume of data, efficiency in retrieval, and enhanced data security and sharing; hence, the development of databases from flat file systems. Despite this advancement in technology, many organizations such as Colorado Financial Reporting System (COFRS) continue to use legacy database systems.…

    • 1007 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Data Base Mangement System

    • 1292 Words
    • 6 Pages

    A Database Management System (DBMS) is a software program that typically operates on a database server or mainframe system to manage structured data, accept queries from users, and respond to those queries. A typical DBMS has the following features (Stair and Reynolds, 2004):…

    • 1292 Words
    • 6 Pages
    Better Essays