Podcast Beta
Questions and Answers
What is the role of a Database Administrator (DBA)?
In charge of enterprise database development, improves the integrity and security of organizational databases, uses Data Definition Language (DDL) to develop and specify data contents, relationships, and structure, and stores these specifications in a data dictionary or a metadata repository.
What information is stored in a data dictionary?
What are the phases involved in the Database Development Process?
Data Planning Process, Entity Relationship Diagram, and Database Design Process.
Logical Design in database development includes defining the physical storage of data on storage devices.
Signup and view all the answers
Data resource management focuses on managing data resources to meet the information needs of ______ stakeholders.
Signup and view all the answers
Match the following types of databases with their descriptions:
Signup and view all the answers
Study Notes
Database Development
- A Database Administrator (DBA) is in charge of enterprise database development, improving the integrity and security of organizational databases.
- DBA uses Data Definition Language (DDL) to develop and specify data contents, relationships, and structure.
- Data specifications are stored in a data dictionary or metadata repository.
Data Dictionary
- A data dictionary contains data about data (metadata).
- It relies on specialized software to manage a database of data definitions.
- It contains information on:
- Data record names and descriptions, and their interrelationships.
- Requirements for end users' access and use of application programs.
- Database maintenance and security.
Database Development Phases
- Database development is a top-down process.
- It involves:
- Developing an enterprise model that defines the basic business process of the enterprise.
- Defining the information needs of end users in a business process.
- Identifying key data elements needed to perform specific business activities.
Entity Relationship Diagram
- An entity relationship diagram is used to identify key data elements and their relationships.
Database Design Process
- Data relationships are represented in a data model that supports a business process.
- The model is used to base the physical design of the database and development of application programs.
- Logical design involves:
- Schema: overall logical view of relationships.
- Subschema: logical view for specific end users.
- Data models for DBMS.
- Physical design involves:
- How data is physically stored and accessed on storage devices.
Data Resource Management
- Data resource management is a managerial activity that uses data management, data warehousing, and other IS technologies.
- It manages data resources to meet the information needs of business stakeholders.
- Data stewards are dedicated to establishing and maintaining the quality of data.
Types of Databases
- Operational databases:
- Store detailed data needed to support business processes and operations.
- Examples: customer, human resource, inventory databases.
- Distributed databases:
- Are copies or parts of databases stored on servers at multiple locations.
- Improve database performance at worksites.
- External databases:
- Are available for a fee from commercial online services or free from the Web.
- Examples: hypermedia databases, statistical databases, bibliographic and full-text databases.
- Hypermedia databases:
- Contain hyperlinked pages of multimedia.
- Interrelated hypermedia page elements, rather than interrelated data records.
Data Warehouses
- Store static data that has been extracted from other databases in an organization.
- Are a central source of data that has been cleaned, transformed, and cataloged.
- Data is used for data mining, analytical processing, analysis, research, and decision support.
- Data warehouses may be divided into data marts, which are subsets of data that focus on specific aspects of a company (department or business process).
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
This quiz covers the role of a Database Administrator (DBA) in enterprise database development, including improving database integrity and security, using Data Definition Language (DDL), and storing data specifications. Learn about the responsibilities of a DBA and how they manage organizational databases.
