CSIT 355 Lecture Notes - Lecture 1: Transaction Processing, Conceptual Schema, Referential Integrity

549 views7 pages
1 Sep 2016
School
Course
Professor

Document Summary

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, transaction-processing application. Data known facts that can be recorded and have implicit meaning. Database represents some aspect of the real world (mini-world). Collection of related data (a random assortment of data is not a database). A db is designed, built, and populated with data for a specific purpose. It has an intended group of users and some a preconceived applications in which the users are interested. Dbms a collection of programs that enables users to create and maintain a database. Metadata about the structure of each file, the type and storage format of each data item, and various constraints on the data. Program-data independence the structure of data files is stored in the dbms catalog separately from the access programs.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents