Review Questions: Chapter 1 Essay

2496 Words Sep 18th, 2013 10 Pages
Review Questions: Chapter 1

1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application.

• Data – known facts that can be recorded and that have implicit meaning. • Database – a collection of related data with an implicit meaning. • DBMS – a collection of programs that enables users to create and maintain a database • Database system – not only contains the database itself bit also a complete definition or description of the database structure and constrains. • Database catalog – the information about the database
…show more content…
• Deductive Database System – some database systems provide capabilities for defining deduction rules for inferencing new information from the stored database facts. • Persistent Object – object-oriented database systems are compatible with programming languages such as C++ and Java, and the DBMS software automatically performs any necessary conversions. Hence, a complex object in C++ can be stored permanently in an object-oriented DBMS. Such an object is said to be persistent, since it survives the termination of a program execution and can later be directly retrieved by another C++ program. • Meta-Data – the information stored in the catalog. It describes the structure of the primary database. It is basically data about data or data describing another data. • Transaction-Processing Application – the DBMS must include concurrency control software to ensure that several users trying to update the same data do so in a controlled manner so that the result of the update is correct.

1.2. What four main types of actions involve databases? Briefly discuss each.

Defining a database involves specifying the data types, structures, and constraints for the data to be stored in the database. Constructing the database is the process of storing the data itself on some storage medium that is controlled by the DBMS. Manipulating a database includes such functions as querying the database to retrieve specific…