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

Database administration is a planning and analysis function that is responsible for setting data policy and standards, for promoting the company's data as a competitive resource, for accounting for the use of data, and for providing liaison support to systems analysts during application development.

One of the advantages of data and database administration is efficiency in job specialization.

A tables table is part of a data dictionary in a relational database environment.

Among the responsibilities of data administration are data coordination and data planning.

Data administration is not concerned with performance monitoring because that is the responsibility of the company's systems programmers.

Database administration is mainly ____ function.

All of the following are realizations of the metadata concept, except ____.

Due to the nature of data, it is not considered to be a "scarce" resource as other corporate resources are.

Data administration personnel serving as liaisons to systems analysts and programmers help determine which of the data items needed for an application already exist in the database.

All of the following are responsibilities of database administration, except ____.

Managing Enterprise Resource Planning (ERP) databases would be most directly characterized as ____.

The Central Zoo. a. You have just been given the responsibility for data management at the Central Zoo. The Central Zoo maintains a modest information systems environment with a server and a LAN that connects all of the zoo's departments. You have been asked to design and manage the typical data administration and database administration functions at the Central Zoo. Do so, describing the tasks necessary to maintain the zoo's data. b. Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for the following Central Zoo 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. Enclosure Date Nurmber Type Location Size Built ENCLOSURE Animal Animal Country Enclosure Number Species Name Gender of Birth Weight Number ANIMAL Employee Employee Year Supervisor Number Name Title Hired Number ZOOKEEPER Animal Employee Service Number Number Type Date Time CARES FOR c. Create a RELATIONSHIPS table for this tables and attributes data.

Among the typical entities stored in a data dictionary are attributes, disks, and queries.

Data administration typically carries out many of the policies set by database administration.

A data dictionary is a program that the IS function uses to help manage itself.

All of the following are responsibilities of data administration, except ____.

Informing potential users of what data already exists in the database would be most directly characterized as ____.

All of the following are likely data dictionary entities in the relational database environment, except ____.

All of the following are characteristics of relational DBMS catalogs, except ____.

A data repository is a large-scale data dictionary with advanced entity types.