10 Questions
What is the primary responsibility of a Database Administrator (DBA)?
To improve the integrity and security of organizational databases
What is contained in a data dictionary?
Information on data, including metadata, descriptions, and relationships
What is the first phase in the database development process?
Data Planning Process
What is represented in an Entity Relationship Diagram?
Data relationships and interrelationships
What is the purpose of Logical Database Design?
To create a schema or subschema for end users
What is data resource management?
A managerial activity that uses data management, data warehousing, and other IS technologies to manage data resources
What is the primary focus of a data steward?
To establish and maintain the quality of data
What type of database stores detailed data needed to support business processes and operations?
Operational database
What is one of the advantages of distributed databases?
Protection of valuable data
What is the process of applying changes to each distributed database called?
Replication
Study Notes
Database Development
- A Database Administrator (DBA) is responsible for enterprise database development, improving database integrity and security, and specifying data contents, relationships, and structure using Data Definition Language (DDL).
- A DBA stores data specifications in a data dictionary or metadata repository.
Data Dictionary
- A data dictionary contains metadata, which is data about data.
- It relies on specialized software to manage a database of data definitions.
- A data dictionary contains information on:
- Names and descriptions of all data record types and their interrelationships.
- End-user access and use requirements for application programs.
- Database maintenance and security.
Database Development Phases
- The data planning process involves:
- Developing an enterprise model defining business processes.
- Defining end-user information needs for business processes.
- Identifying key data elements for specific business activities using entity-relationship diagrams.
Database Design Process
- Data relationships are represented in a data model supporting business processes.
- This model is the basis for:
- Physical database design.
- Developing application programs for business processes.
- Logical design involves:
- Schema: overall logical view of relationships.
- Subschema: logical view for specific end users.
- Data models for Database Management Systems (DBMS).
- Physical design involves:
- How data is physically stored and accessed on storage devices.
Data Resource Management
- Data resource management uses data management, data warehousing, and other IS technologies to manage data resources and meet business stakeholders' information needs.
- Data stewards are responsible for establishing and maintaining data quality, requiring business, technology, and diplomatic skills, with a focus on data content.
Types of Databases
Operational Databases
- Operational databases store detailed data to support business processes and operations.
- Examples include customer, human resource, and inventory databases.
Distributed Databases
- Distributed databases are copies or parts of databases stored on servers at multiple locations.
- Advantages include:
- Improved database performance at worksites.
- Protection of valuable data.
- Data can be distributed into smaller databases.
- Each location has control over local data.
- All locations can access any data, anywhere.
- Disadvantages include maintaining data accuracy.
- Methods for distributed databases include replication and duplication.
External Databases
- External databases are available from commercial online services or free from the Web.
Learn about the roles and responsibilities of a Database Administrator (DBA), including database development, integrity, and security. Understand the use of Data Definition Language (DDL) and data dictionaries.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
