Upgrade to remove ads
Only $2.99/month

Database Introduction CH 1

Terms in this set (19)

database
What is a collection of related data called?
database management system (DBMS)
What is a collection of software that manages and controls access to the database?
database system
What is a collection of application programs that interact with the database along with the DBMS and the database itself.
program-data dependence
In a file-based system, what does it mean to identify all the affected programs, modify them and retest them?
metadata
This description of data is refereed to as the system catalog or data dictionary?
data abstraction
How can the internal definition of an object be changed without affecting the users of the object, provided that the external definition remains the same?
entity
What is a distinct object (person, place, thing, concept or event) in the organization that is to be represented in the database?
attribute
What is a property that descries some aspect of the onbect that w wish to record?
relationship
What is an association between entities?
Data Definition Language (DDL)
What allows users to specify the data types and structures and the constraints on the data to be stored in the database?
Data Manipulation Language (DML)
What has a central repository for all data and data descriptions?
Query language
When data description allows DML to provide a general inquiry facility to data from database, this is called what?
Structural Query Language (SQL)
What common query language provides controlled access to the relational database?
(Database) Application programsWhat is some subset of the database?
What programs are used to create and maintain the database and generate information, thereby allowing users to interact with the database?
View
...
Views provide: a level of security; a mechanism to customize appearance of the database; and, can present a consistent, unchanging picture of the structure of the database.
What are some benefits of views?
Backend of the DBMS
What is the part of the DBMS that manages and controls access to the database while showing several computers at various locations rnning the front end of the DBMS? ?
Frontend of the DBMS
What is the part of the DBMS that interfaces with the user?
Client-server architecture
What is meant by saying the backend of the server and the frontends are the clients?
YOU MIGHT ALSO LIKE...