Podcast
Questions and Answers
What is the primary responsibility of a Database Administrator (DBA)?
What is the primary responsibility of a Database Administrator (DBA)?
What is contained in a data dictionary?
What is contained in a data dictionary?
What is the first phase in the database development process?
What is the first phase in the database development process?
What is represented in an Entity Relationship Diagram?
What is represented in an Entity Relationship Diagram?
Signup and view all the answers
What is the purpose of Logical Database Design?
What is the purpose of Logical Database Design?
Signup and view all the answers
What is data resource management?
What is data resource management?
Signup and view all the answers
What is the primary focus of a data steward?
What is the primary focus of a data steward?
Signup and view all the answers
What type of database stores detailed data needed to support business processes and operations?
What type of database stores detailed data needed to support business processes and operations?
Signup and view all the answers
What is one of the advantages of distributed databases?
What is one of the advantages of distributed databases?
Signup and view all the answers
What is the process of applying changes to each distributed database called?
What is the process of applying changes to each distributed database called?
Signup and view all the answers
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.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
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.
