AFM241 Study Guide - Midterm Guide: Database Theory, Database, Data Dictionary
30 May 2018
School
Department
Course
Professor
E.g. when BlueBikes purchases a bike from one of its suppliers on credit, the AP will have to
be updated to reflect the amount outstanding and inventory account too
A DSS is more complicated, offers more extensive information generation and processing, as well as
management capabilities
Focuses on the information requirements instead of the transaction requirements
characteristic of production databases
The most popular DSS databases are called datawarehouses- primarily storage facilities
dedicated to processing existing data taken from production databases into useful
information
updated infrequently because of lower volume of transactions to record
data about the data is referred to as metadata which is kept in a data dictionary – a
compilation of all the components of the data, their names, their characteristics, and also
facts about the nature of relations between the different sets of data
the program that manages all this data and metadata is called a database management
system (DBMS). Performs the following functions:
manages metadata in a data dictionary
produces complex data storage functions, including enforcing data input
requirements
creates and enforces a secure environment for the storage of data
manages the complex needs of a multi-user environment
enforces data integrity at all levels of the database
four different database models
1. Hierarchical
2. Network
3. Relational
4. Object-oriented
The most prevalent is the relational database, implemented in the form of a relational Database
management system (RDBMS)
E.g. Microsoft access
Data is conceptually represented in two-dimensional tables (files, relations) consisting of
rows (records) and columns (attributes, fields)
Uses attributes to associate data from different tables
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
E. g. when bluebikes purchases a bike from one of its suppliers on credit, the ap will have to be updated to reflect the amount outstanding and inventory account too. A dss is more complicated, offers more extensive information generation and processing, as well as management capabilities. Focuses on the information requirements instead of the transaction requirements characteristic of production databases. The most prevalent is the relational database, implemented in the form of a relational database management system (rdbms) Data is conceptually represented in two-dimensional tables (files, relations) consisting of rows (records) and columns (attributes, fields) Uses attributes to associate data from different tables. Allows user to link sets of data in a tabular format, creating relations that are easy to visualize. Databases generally store data about entities and their attributes. An entity (also referred as table or file or relation) is something that users want to track. Entity can be a person, a concept, or event.
