[go: up one dir, main page]
Scribd
Upload
458 views4 pages

Components of DB Environment

The document outlines the key components of a database environment including CASE tools, DBMS, repositories, databases, application programs, user interfaces, database administrators, system developers, and end users. Repositories contain metadata while databases contain actual data. Databases can be classified as personal, workgroup, departmental/divisional, or enterprise depending on the number of users. The proposal suggests finding a company that needs improved database management to develop a case study.

Uploaded by

Rayven Yor Esplanada
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
458 views4 pages

Components of DB Environment

The document outlines the key components of a database environment including CASE tools, DBMS, repositories, databases, application programs, user interfaces, database administrators, system developers, and end users. Repositories contain metadata while databases contain actual data. Databases can be classified as personal, workgroup, departmental/divisional, or enterprise depending on the number of users. The proposal suggests finding a company that needs improved database management to develop a case study.

Uploaded by

Rayven Yor Esplanada
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Components of a DB environment

Components of a DB environment
● Computer-aided Software Engineering (CASE) Tools - automated tools used to design databases
and application programs. These tools help with the creation of data models.
● DBMS - Software for managing the database.
● Repository - Centralized storehouse of metadata.
● Database - Storehouse of the data.
● Application programs - Programs intended for the needs of the user and that access and maintain
the database.
● User Interface - What the user sees within a service.
● Database administrator - People who monitor and manage the DBMS.
● System Developers - People who are responsible for designing databases and software.
● End users - People who interact with the system for their own benefit.

Repositories contain definitions of data (metadata), while databases contain the actual data.
Range of databases
● Personal databases - standalone desktop database
● Workgroup databases - LAN (< 25 users)
● Departmental/Divisional databases - LAN (25-100 users)
● Enterprise databases - (100+)
○ Enterprise resource-planning (ERP) systems
○ Data warehousing
DB Proposal
● Look for a company or a business who:
○ Needs improvement in terms of their database management (inventory, employee or customer
records, sales, data organization, etc.)
○ Have no systems in terms of working with the data that they need to manage
○ Have inefficient systems that are in need of improvement
○ Are open to working with and be interviewed by students when needed
● Look for case studies regarding database management systems online and
use it as a reference for your group.

You might also like