Shared Flashcard Set

Details

Intro to Database Chapter 1-3
Quizes Plus Bold Face Words.
41
Computer Science
02/25/2008

Additional Computer Science Flashcards

 


 

Cards

Term

 

 

The purpose of a database is to help people keep track of things? (T or F)

Definition

 

 

 

True 

Term

 

 

An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurences of the same data item in other rows will be automatically updated as well. ( T or F)

Definition

 

 

False 

Term

 

 

One problem with storing duplicated data is the potential for inconsistent values.( T or F) 

Definition

 

 

True 

Term

 

 

A relational database stores data in the form of lists. ( T or F) 

Definition

 

 

FALSE 

Term

 

By separating data into tables containg data on only one theme each, making changes to the data is simplified. ( T or F

Definition

 

True 

Term

 

A relational database can be defined as a self-describing collection of related tables. ( T or F) 

Definition

 

 

True 

Term

 

Refential integrity constraints must be enforced by the application program. ( T or F) 

Definition

 

False. 

Term
Most commercial databases are base on ______?
Definition
hierarchical model.
Term

 

 

Relational database stores data in the form of ________? 

Definition

 

Tables. 

Term

 

SQL stands for? 

Definition
Structured Query Language.
Term
What are the four baisc components of a database system?
Definition

 

1) Database, 2) user, 3) DBMS, 4) Database Application 

Term
The component of a database that makes it self-describing is the________?
Definition

 

Metadata 

Term
The creation of a database and its tables is a functrion of which component of the database system?
Definition

 

 

DBMS 

Term
Microsoft Access is an example of a _______?
Definition
Database Management System
Term
What are the three things that make a relation?
Definition

The order of the columns in a relation must go from largest to smallest.

All entries in any column must be of the same kind.

A relation may have duplicate column names. 

Term
What does tuple mean?
Definition

A row.

 

Term
A key that contains more than one attribute is called a(n)__________?
Definition
composite key
Term
A candidate key is ____?
Definition
..............
Term
When the primary key of one relation is placed into a second relation, it is called a ______.
Definition
foreign key
Term
A rule that requires that the values in a forein key must have a matching value in the primary key to which the foreign key corresponds, is called _____.
Definition

 

Referential integrity constraint 

Term
What are three true things about surrogate keys?
Definition

They are usually hidden on forms and reports.

They are unique.

They are numeric 

Term

Which of the following is not a function of the database application in a database system?

a) Execute Application Logic

b) Control Concurrency

c) Create and process reports

D) Create and transmit queries

E) None of the above 

Definition
B) Control Concurrency. All the other three are functions of a database.
Term
Name something true about a key.
Definition

It may be unique.

It may be nonunique.

It may identify more than one row.

 

Term
What is the function of the DBMS in a database system?
Definition
.....
Term
What is an example of something thats not metadata and something that is metadata?
Definition

 Names of tables in a database is (METADATA)

Random numbers.(NOT)

Properties of tables in a database(METADAtA)

NAmes of columns in a database of which they belong(METADATA) 

Term
Name two data types in Microsoft access
Definition
Text, Num
Term
Name two other things that have the same meaning as field.
Definition
column and attribute both mean the same as field.
Term
Name the three types of objects in Microsoft access.
Definition
forms reports and quieres
Term
What is a relation?
Definition
A Table.
Term
Each relation is a ____ dimensional table.
Definition
2
Term
The attributes of an entity become the ____ in a table.
Definition

 

columns 

Term
Rows are also called ________.
Definition
tuples.
Term
The ____ key of a table is the column that uniquely identifies a row in a table.
Definition
Primary Key
Term
What is a primary key?
Definition

It is a unique.

Used to represent rows in relationships

Can be candidate key

Used to identify unique rows

 

Term

 

 

STUDENT(SID, S-Name, Major, AdvisorID)

ADVISOR(AdvisorID, A-Name, Office, Phone) 

What is the foreign key? 

Definition
AdvisorID
Term

 

In Microsoft Access the data type of a surrogate key is called a _______? 

Definition
........
Term
The first step of the Normalization process is to _____?
Definition
Identify all candidate keys of a relation.
Term

What is true about null values?

 

Definition

Null values cannot be avoided

Null value can mean that the value is known to be blank

a null value can mean that the vaule is unknown

value is amibuous. 

Term
Name an example of a popular DBMS software 
Definition
SQL, Oracle, Microsoft access, many more.
Term
The relationships between two attributes that denotes that given the value of the first attribute is known,m the value of the second attribute can be determined, is called a(n) ___________?
Definition

 

 

funtioncally dependent.

Term
What does the primary key of the relation determine?
Definition
It funtionally determines all of the attributes in the relation.