COMM 205 Quiz 2

Question 1

Database

Answer 1

1. An organized collection of logical related data>
2. A. structured collection of data accessed and utilized by many different applications and users.
3. A collection of records about various business categories (entities).

Question 2

An effective information system provides

Answer 2

1. Timely information
2. Quality information
3. Relevant information

Question 3

Why put data into databases?

Answer 3

1. No data redundancy
2. Data can be shared in a way that does not violate privacy and confidentiality
3. There is data integrity or consistency

Question 4

Problems with traditional file-based systems

Answer 4

1. Data redundancy
2. Data inconsistency
3. Data isolation

Question 5

Data redundancy

Answer 5

Duplicate data in multiple data files.

Wastage of storage space and inefficient processing.

Question 6

Data inconsistency

Answer 6

Various copies of the data do not agree.

Different representations of the same piece of data in different places.

Question 7

Data isolation

Answer 7

Applications cannot access data associated with other

applications.

Question 8

Database Management System (DBMS) is the software used to

Answer 8

1. Reduce data redundancy;
2. Share data in a controlled way
3. Reduce data integrity problems.

Question 9

Enterprise systems include

Answer 9

1. Internal Databases (Operational databases; Data warehouses)
2. External Databases

Question 10

Database Management Systems (DBMS) is

Answer 10

1. Software through which users and application programs interact with a database.
2. Software used to create, manage, maintain, and manipulate a database.

Question 11

Examples of DBMS

Answer 11

Microsoft Access
Microsoft SQL Server
Oracle
MySQL (open source database)
IBM DB2
FileMaker Pro (a subsidiary of Apple Inc.)

Question 12

Data Security

Answer 12

Databases have high security measures in place to deter mistakes and attacks.

Question 13

Data Integrity

Answer 13

Data meet certain constraints, such as no alphabetic characters in a Social Insurance Number field.

Question 14

Data Independence

Answer 14

Applications and data are not linked to each other, so

that all applications are able to access the same data.

Question 15

Benefits of DBMS

Answer 15

1. Data Security
2. Data Integrity
3. Data Independence

Question 16

Data hierarchy

Answer 16

1. Database
2. File (Table)
3. Record
4. Field

Question 17

Ratioanal Databases - Table

Answer 17

1. Data organized as two-dimensional tables.
   Table (File)
   Row (Record)
   Column (Field or Attribute)
2. Tables are linked by matching fields
3. Primary Key and Foreign Key are used to create logical relationships between tables

Question 18

Composite primary key

Answer 18

A primary key that consist of more than one field

Question 19

Atomic primary key

Answer 19

A primary key that consist of only one field

Question 20

Primary Key

Answer 20

Primary Key is an attribute that uniquely identities each record in a table (parent table).

Question 21

Foreign Key

Answer 21

Foreign Key is an attribute in a table (child table) that reference a primary key of parent table.