Upgrade to remove ads
Database Introduction CH 1
Terms in this set (19)
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?
What is a collection of application programs that interact with the database along with the DBMS and the database itself.
In a file-based system, what does it mean to identify all the affected programs, modify them and retest them?
This description of data is refereed to as the system catalog or data dictionary?
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?
What is a distinct object (person, place, thing, concept or event) in the organization that is to be represented in the database?
What is a property that descries some aspect of the onbect that w wish to record?
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?
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?
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?
What is meant by saying the backend of the server and the frontends are the clients?
YOU MIGHT ALSO LIKE...
Database Systems Exam 1
Isom 413 - Chapter 1
Computer Analysis - Chapter 9
OTHER SETS BY THIS CREATOR
MKTG Ch 18 - Assignment 7 - Additional Perspective…
MKTG Ch 12 - Assignment 6 - Managing the Marketing…
MKTG Ch 11 Assignment 5 - Pricing Issues in Channe…
MKTG Ch 10 Assignment 4 - Managing the Marketing C…