Upgrade to remove ads
COSC 341 Midterm
Terms in this set (41)
The part of the real world for which a database will be used to model and store data is called:
Universal Discourse or Mini-World
A set of database updates that is performed as an atomic unit(all or nothing) is called
Data describing data:
The feature of a database system to allow multiple users to access the database at the same time is called:
The software used to define, populate, query, and maintain a database is called a:
Database Management System (DBMS)
The statements (or subset of database language) that is used to enter and change data in the database is called:
Data Manipulation Language (DML)
In addition to defining entities and attributes, between entities we can define:
To help maintain data integrity, we can define:
The data model expressed in terms of a specific database system is called:
Program statements that are stored and executed inside a database system is called:
Should a fault occur in the database system (either hardware or software), the ability to restart the database system such that all committed changes up to the point of failure reside in the database is called:
The low-level data model which expresses the data structure in disk is called the:
File systems may exhibit redundancy, and redundancy may compromise:
The four basic operations used to access and modify data in the database are Create, Read, Update, and :
The schema that expresses the database as a whole in terms of things understood by the end-user is called:
A database stat in which all constraints are met is called:
The ability to change the physical schema without impacting the upper level schemas is called:
A physical data model where relationships are implemented as linked lists is called the:
A low-level database language requires specification of how to execute statements whereas a high-level database language specifies:
What to execute
A database architecture where everything (e.g. the database software, database, application programs, and utilities) reside and execute on a single platform is called a:
A three-tier architecture has presentation software for an application running on the users computer, the database server on the back end, and what is in the middle:
What changes frequently (intension or extension)
The database user responsible for managing the database (e.g. creating accounts, adjusting the physical model, monitoring performance and identifying bottlenecks, performing backups) is the:
Who is responsible for developing the database software that manages the physical model?
One reason a database may not be used:
Too much money
A disadvantage of the hierarchical model is:
Not good query optimization
An advantage of the relational model is:
Good query optimization
An advantage of a database system over a file system is:
Interface and setup of the database is easily used and viewed.
Double line on relation:
Double line around entity:
Dotted line under attribute name:
Dotted line around attribute:
Derived Attribute, which can be determined by other attributes
Double line between entity and relationship:
Double line around attribute:
Underline under attribute name:
A _____________ is the formal name of a table of a relational database.
A ______________ is an entry inserted, updated, or deleted from a table.
A table is one of the schema constructs that can be defined within a relational schema. Another schema construct is ____________.
______________ requires that all attributes that compare a primary key cannot be null.
______________ ensures that there must exist a tuple in the referenced table with a value of its primary key is equal to the value of the foreign key for every tuple in the referencing table.
_____________ is the set of possible values for a column.
YOU MIGHT ALSO LIKE...
Chapter 5 Using MIS
ch 15 databases
OTHER SETS BY THIS CREATOR
COSC 319 Exam 1
HDFS Exam 3
History 020 Terms 1 Chapters 1-4