2.Outline the advantages of a database management approach to managing the data resources of a business, compared to a file processing approach.
3.Explain how database management software helps business professionals and supports the operations and management of a business.
4.Provide examples to illustrate each of the following concepts:
Major types of databases.
Data warehouses and data mining.
Logical data elements.
Fundamental database structures.
Database development.
A smallest unit of data
Byte: Combination of BITS which represent a CHARACTER
Field: Collection of BYTES which represent a DATUM or Fact
Record: Collection of FIELDS which reflect a TRANSACTION
File: A collection of similar RECORDS
Database: An organization’s Electronic Library of FILES
Entity: A person, place, thing, or event about which information must be kept; A record describes an entity
Attribute: A piece of information describing a particular entity
Key Field (Primary Key, Pointer or Index): Field in each record uniquely identifies this record for retrieval, updating, sorting
Definition: Organization’s electronic library stores & manages data in a convenient form
DBMS: Software to create & maintain data enables business applications to extract data independent of specific computer programs
Act as an interface between applications program and physical data file

분야