CH_Database_Management.txt

CH_Database_Management.txt - Chapter 7 Managerial Overview...

This preview shows 1 out of 3 pages.

Chapter 7 Managerial Overview: Database Management LECTURE NOTES 7-1 Foundation Data Concepts: [Figure 7.2] A hierarchy of several levels of data has been devised that differentiates between different groupings, or elements, of data. Data are logically organized into: Character - A character is the most basic logical data element. It consists of a single alphabetic, numeric, or other symbol. Field - A field consists of a grouping of characters. A data field represents an attribute (a characteristic or quality) of some entity (object, person, place, or event). Record - Related fields of data are grouped to form a record. Thus, a record represents a collection of attributes that describe an entity. Fixed-length records contain a fixed number of fixed-length data fields. Variable-length records contain a variable number of fields and field lengths. File - A group of related records is known as a data file, or table. Files are frequently classified by the application for which they are primarily used, such as a payroll file or an inventory file, or the type of data they contain, such as a document file or a graphical image file. Files are also classified by their permanence, for example, a master file versus a transaction file. A transaction file would contain records of all transactions occurring during a period, whereas a master file contains all the permanent records. A history file is an obsolete transaction or master file retained for backup purposes or for long-term historical storage called archival storage. Database - A database is an integrated collection of logically related records or objects. A database consolidates records previously stored in separate files into a common pool of data records that provides data for many applications. The data stored in a database is independent of the application programs using it and of the type of secondary storage devices on which it is stored. 7-2 The Database Management Approach: The development of databases and database management software is the foundation of modern methods of managing organizational data. Database Management Approach - Is a method whereby data records and objects are consolidated into databases that can be accessed by many different application programs. Database Management System - (DBMS) serves as a software interface between users and databases. Thus, database management involves the use of database management software to control how databases are created, interrogated, and maintained to provide information needed by end users and their organizations.
Image of page 1

Subscribe to view the full document.

The database management approach involves three basic activities: 1. Updating and maintaining common databases to reflect new business transactions and other events requiring changes to an organization s records.
Image of page 2
Image of page 3
You've reached the end of this preview.
  • Fall '16

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern