BMGT 301 EXAM 2 VERIFIED STUDY GUIDE
Database - Answers - single table or collection of related tables
database management systems - Answers - software for creating, maintaining, and
manipulating data
Structured query language (SQL) - Answers - used to create and manipulate databases;
it is non-procedural language; it is declarative language
database hierarchy - Answers - bit-->byte-->field-->record--> file-->database
problems with the traditional file environment - Answers - -data redundancy
-data-inconsistency
-poor security
-lack of data sharing and availability
data definition language - Answers - specifies structure of database content, used to
create tables and define characteristics of fields
data dictionary - Answers - automated or manual file storing definitions of data elements
and their characteristics
data manipulation language - Answers - used to add, change, delete, retrieve data from
database
database - Answers - group of related files
file - Answers - group of RECORDS of the same type
record - Answers - group of related fields
field - Answers - group of words or numbers
-entity (person, place, or thing)
-attribute: each characteristic, or quality, describing entity
attribute example - Answers - attribute date/ grade which belongs to an entity
201 of BMGT 201
Problems with the traditional file environment (files maintained separately by different
departments) - Answers - --Data redundancy:
Presence of duplicate data in multiple files
--Data inconsistency:
, Same attribute has different values
--Poor security
--Lack of data sharing and availability
how does database help organize data? - Answers - Serves many applications by
centralizing data and controlling redundant data
how does DBMS solve issues with traditional file environment? - Answers - -Controls
redundancy
-Eliminates inconsistency
-Uncouples programs and data
-Enables organization to centrally manage data and data security
What is the purpose of Database management systems? - Answers - -Interfaces
between applications and physical data files
-Separates logical and physical views of data
-Solves problems of traditional file environment
Relational DBMS - Answers - --Represent data as two-dimensional tables called
relations or files
--Each table contains data on entity and attributes
Table: grid of columns and rows - Answers - Rows (tuples): Records for different entities
Fields (columns): Represents attribute for entity
Primary key: Field in table used to uniquely identify a table
Foreign key: Primary key used in second table as look-up field to identify records from
original table
Rows (tuples) - Answers - Records for different entities
Fields (columns) - Answers - Represents attribute for entity
Capabilities of Database Management Systems - Answers - --Data Definition Language
--Data dictionary
--Data Manipulation Language
--Many DBMS have report generation capabilities for creating polished reports
Data Definition Language - Answers - Specifies structure of database content, used to
create tables and define characteristics of fields
Data dictionary - Answers - Automated or manual file storing definitions of data
elements and their characteristics
Data Manipulation Language - Answers - Used to add, change, delete, retrieve data
from database
--Structured Query Language (SQL)
Database - Answers - single table or collection of related tables
database management systems - Answers - software for creating, maintaining, and
manipulating data
Structured query language (SQL) - Answers - used to create and manipulate databases;
it is non-procedural language; it is declarative language
database hierarchy - Answers - bit-->byte-->field-->record--> file-->database
problems with the traditional file environment - Answers - -data redundancy
-data-inconsistency
-poor security
-lack of data sharing and availability
data definition language - Answers - specifies structure of database content, used to
create tables and define characteristics of fields
data dictionary - Answers - automated or manual file storing definitions of data elements
and their characteristics
data manipulation language - Answers - used to add, change, delete, retrieve data from
database
database - Answers - group of related files
file - Answers - group of RECORDS of the same type
record - Answers - group of related fields
field - Answers - group of words or numbers
-entity (person, place, or thing)
-attribute: each characteristic, or quality, describing entity
attribute example - Answers - attribute date/ grade which belongs to an entity
201 of BMGT 201
Problems with the traditional file environment (files maintained separately by different
departments) - Answers - --Data redundancy:
Presence of duplicate data in multiple files
--Data inconsistency:
, Same attribute has different values
--Poor security
--Lack of data sharing and availability
how does database help organize data? - Answers - Serves many applications by
centralizing data and controlling redundant data
how does DBMS solve issues with traditional file environment? - Answers - -Controls
redundancy
-Eliminates inconsistency
-Uncouples programs and data
-Enables organization to centrally manage data and data security
What is the purpose of Database management systems? - Answers - -Interfaces
between applications and physical data files
-Separates logical and physical views of data
-Solves problems of traditional file environment
Relational DBMS - Answers - --Represent data as two-dimensional tables called
relations or files
--Each table contains data on entity and attributes
Table: grid of columns and rows - Answers - Rows (tuples): Records for different entities
Fields (columns): Represents attribute for entity
Primary key: Field in table used to uniquely identify a table
Foreign key: Primary key used in second table as look-up field to identify records from
original table
Rows (tuples) - Answers - Records for different entities
Fields (columns) - Answers - Represents attribute for entity
Capabilities of Database Management Systems - Answers - --Data Definition Language
--Data dictionary
--Data Manipulation Language
--Many DBMS have report generation capabilities for creating polished reports
Data Definition Language - Answers - Specifies structure of database content, used to
create tables and define characteristics of fields
Data dictionary - Answers - Automated or manual file storing definitions of data
elements and their characteristics
Data Manipulation Language - Answers - Used to add, change, delete, retrieve data
from database
--Structured Query Language (SQL)
