Question 1

Data administration is mainly ____ function.

Accepted Answer

A)  a programming 
B)  a planning and analysis 
C)  a hardware maintenance 
D)  an operational, day-to-day monitoring and management 
E)  a finance and accounting 
A)  a programming 
B)  a planning and analysis 
C)  a hardware maintenance 
D)  an operational, day-to-day monitoring and management 
E)  a finance and accounting

Question 2

The term metadata means data about data.

Accepted Answer

A) True 
 B)False

Question 3

Having data administration enforce data standards is helpful in establishing supply chains with other companies.

Accepted Answer

A) True 
 B)False

Question 4

Grand Travel Airlines.
a. You have just been named Director of Data Administration of Grand Travel Airlines. Grand Travel Airlines has a centralized, mainframe-based information systems environment at its headquarters with telecommunications links to a server at each airport that it services. Each server, in turn, controls a LAN that includes a microcomputer at each check-in counter and gate. Check-in and other data taken in at the counters and gates is immediately transmitted to the mainframe at headquarters. You have been given the responsibility of creating data administration and database administration departments for Grand Travel Airlines. Design these data administration and database administration departments describing their responsibilities.
b. Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for the following Grand Travel Airlines database. Your TABLES table should have Table Name, Table Length, and Disk Number columns. Your ATTRIBUTES tables should have Attribute Name, Attribute Type, and Attribute Length columns. Use your judgement in developing the values for these columns.
 $$\begin{array} { | l | l | l | l | } 
\hline \text { Pilot } & \text { Pilot } & \text { Date of } & \text { Date of }\
\text { Number } & \text { Name } & \text { Birth } & \text { Hire } \
\hline
\end{array}$$ PILOT
 $$\begin{array} { | l | l | l | l | l | l |} 
\hline \text { Flight } & & \text { Departure } & \text { Arrival } & \text { Pilot } & \text { Serial } \
\text { Number } & \text { Date } & \text { Time }&\text { Time } &\text { Number }&\text { Number }\
\hline
\end{array}$$ FLIGHT
 $$\begin{array} { | l | l | l | l | } 
\hline \text { Passenger } & \text { Passenger } & & \text { Telephone } \
\text { Number } & \text { Name } & \text { Address } & \text { Number } \
\hline
\end{array}$$ PASSENGER
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { Flight }&&\text { Passenger }&&\text { Reservation }\
\text { Number }&\text { Date }&\text { Number }&\text { Fare }&\text { Date }\
\hline
\end{array}$$ RESERVATION
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { serial } & & \text { Passenger } & \text { Year } & \
\text { Number } & \text { Model } & \text { Capacity } & \text { Built } & \text { Manufacturer } \
\hline
\end{array}$$ AIRPLANE 
c. Create a RELATIONSHIPS table for this tables and attributes data.

Accepted Answer

a. The centralized Grand Travel Airlines

Question 5

Among the responsibilities of data administration are DBMS performance monitoring and DBMS troubleshooting.

Accepted Answer

A) True 
 B)False

Question 6

A passive data dictionary is one that interacts with the IS environment on a real-time basis.

Accepted Answer

A) True 
 B)False

Question 7

Among the responsibilities of database administration are data planning and arbitration of disputes.

Accepted Answer

A) True 
 B)False

Data administration is mainly ____ function.

The term metadata means data about data.

Having data administration enforce data standards is helpful in establishing supply chains with other companies.

Among the responsibilities of data administration are DBMS performance monitoring and DBMS troubleshooting.

A passive data dictionary is one that interacts with the IS environment on a real-time basis.

Among the responsibilities of database administration are data planning and arbitration of disputes.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 10: Data Administration, Database Administration, and Data Dictionaries

Data administration is mainly ____ function.

The term metadata means data about data.

Having data administration enforce data standards is helpful in establishing supply chains with other companies.

Among the responsibilities of data administration are DBMS performance monitoring and DBMS troubleshooting.

A passive data dictionary is one that interacts with the IS environment on a real-time basis.

Among the responsibilities of database administration are data planning and arbitration of disputes.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters