Shared Flashcard Set

Details

ITEC 110 Ch. 6
Chapter 6
50
Internet/New Media
Undergraduate 3
05/03/2013

Additional Internet/New Media Flashcards

 


 

Cards

Term
Without a databade most applications would be useless.
Definition
T
Term
A database management system (DBMS) provides an end-user interface with the database.
Definition
T
Term
A DBMS delegate the task of ensuring data integrity to the operating system.
Definition
F
Term
A DBMS manages multiple users' access to the database.
Definition
T
Term
An attribute is also called a relation.
Definition
F
Term
A collection of columns referring to one item is called a row or tuple.
Definition
T
Term
Indexes do not require additional storage space in the database.
Definition
F
Term
The information stored in a database is kept in natural or sequential order.
Definition
T
Term
From a database design point of view, first nomal form is better than second normal form.
Definition
F
Term
You could define a database table based on unnormalized tables, but redundancies and dependencies can cause problems when the table is in use.
Definition
T
Term
A determinant is also called a composite key.
Definition
F
Term
A column is functionally dependent on another column if for each value of the first column, there is only one value for the second column.
Definition
T
Term
The third normal form creates columns that are independent of the primary key.
Definition
F
Term
The main rules in database design are the second and third normal forms.
Definition
F
Term
A one-to-many relationship is the most common relationship.
Definition
T
Term
One-to-one relationships are very common.
Definition
F
Term
The RETURN BY clause enables you to change how data is returned from the SELECT statement.
Definition
F
Term
There are many SQL commands for maintaining, defining, and administering the data in a database.
Definition
T
Term
SQL deals with only the data you want to see.
Definition
T
Term
SQL commands may not be lowercase.
Definition
F
Term
Every column must be initialized with data.
Definition
F
Term
The order of the fields in the SELECT statement doesn't have to match that of the defined table structure.
Definition
T
Term
The MORE clause in a SQL SELECT statement specifies additional criteria for retrieving data from a table.
Definition
F
Term
In relation to refining searches, the keyword AND indicates that all criteria must be met.
Definition
T
Term
By default, the SELECT statement returns data in no particular order.
Definition
F
Term
Data that has been organized and logically related to allow access, retrival, and use of that data is called a ___.
Definition
database
Term
A special language known as ___ is used to query or extract information from databases.
Definition
Structured Query Language
Term
___ was one of the computer scientists at IBM creating a theoretical model for designing data structures.
Definition
E.F. Codd
Term
A DBMS helps manage date and extract information from a database by using a(n) ___ language.
Definition
query
Term
A ___ or entity is arranged into rows or columns much like a spreadsheet.
Definition
table
Term
The set of possible values for each column is called the ___ of that column.
Definition
domain
Term
A(n) ___ is a special type of file that occupies its own space and specifies one or more columns that determine how information stored in a table can be accessed more efficiently.
Definition
index
Term
When the columns are used to determine the sort order of information, they are called sort ___.
Definition
keys
Term
The set of rules that dictates how databases are designed is called ___.
Definition
normalization
Term
To put the table into the ___ normal form, any columns containing two values need to be separated into two rows.
Definition
first
Term
A ___ key is simply a column or combination of columns that uniquely identifies a row within a table.
Definition
primary
Term
A(n) ___ key is a primary key made up of more than one column.
Definition
composite
Term
Placing a table into second normal form eliminates ___ of data.
Definition
repetition
Term
A(n) ___ dependency exists when one column is dependent on another column that isn't the primary key.
Definition
transitive
Term
A(n) ___ defines how one table (entity) works with or relates to another.
Definition
relationship
Term
A(n) ___ key is a column in one table that relates to the primary key in another.
Definition
foreign
Term
A visual representation of how all the tables or entities interact and relate to each other in a database is called a(n) ____ relationship model.
Definition
entity
Term
___ shows the numeric occurences between entities in an ER model.
Definition
Cardinality
Term
Which of the following is a valid SQL command for constructing a table?
Definition
CREATE TABLE
Term
The keyword ___ indicates that data is not required for a specified column.
Definition
NULL
Term
SQL statements are closed with a(n) ___.
Definition
semicolon
Term
The ___ statement is used to add new rows of data to a table.
Definition
INSERT INTO
Term
The ___ statement is the most commonly used SQL statement.
Definition
SELECT
Term
If you want to arrange the data more meaningfully when using the SELECT statement, you can specify the ___ column names.
Definition
ORDER BY
Term
If you want data returned in descending order, you simply place the keyword ___ next to the column in the ORDER BY clause.
Definition
DESC
Supporting users have an ad free experience!