Chapter 5 Flashcards
What is the most common database
The relational database
=It is a series of related tables, stored together with a minimum of duplication to achieve consistent and controlled pool of data
The stages to approach a database
-Identify all entities
-Identify all relationships between entities
-Identify all attributes
-Resolve all relationships
Define DDL and mention its function
The data definition language is a collection of instructions and commands used to define and describe data and relationships in a specific database
Allows the database’s creator to describe the data and relationships that are to be contained in the schema/model
What are the functions of the data dictionary
Stores meta data, a detailed description of all the data used in the database,
What is the main objective of the data dictionary?/What is the data dictionary trying to achieve?
-Reduced data redundancy
-Increased data reliability
-Assists program development
-Easier modification of data and information
Explain what data manipulation language is
They are commands that are used to manipulate the database
Define a database management system (DBMS)
-a group of programs used as an interface between a database and application programs or a database and the user
List the important characteristics of databases
-Database size
-Database cost
-Concurrent users
-Performance
-Integration
-Vendor
Explain the role of the data base administrator
-Role of the database administrator (DBA) is to plan, design, create, operate, secure, monitor, and maintain databases
-It is responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions; a nontechnical position
What are the common manipulations of databases to produce useful information
-searching
- filtering, synthesizing
-assimilating the data contained in a database using a number of database applications
Define a data warehouse
It is the database that collects business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers
Define data mining
It is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse
What are the functions and usage of data mining
-It is is used extensively in marketing to improve customer retention
Data-mining tools help users find answers to questions they haven’t thought to ask
Define business intelligence an explain its role
It is process of gathering enough of the right information in a timely manner and usable form and analyzing it to have a positive impact on business strategy, tactics, or operations
Turns data into useful information that is then distributed throughout an enterprise
What is a distributed database
Database in which the data may be spread across several smaller databases connected via telecommunications devices
Gives corporations more flexibility in how databases are organized and used
