Intro to Database Pt.2 Flashcards
Database System and its Environment
can range from a PC to a network of computers.
Hardware
a computerized system whose overall purpose is to maintain information and make that information available on demand.
Database Systems
Database System and its Environment
- Operating Systems Software
- DBMS Software
- Application programs and utility software
Software
Database System and its Environment
- Systems Administrators
- Database Administrators
- Database Designers
- Systems Analysts and Programmers
- End Users
People
Database System and its Environment
instructions and rules that should be applied to the design and use of the database and DBMS.
Procedures
Database System and its Environment
- used by the organization and a description of this data called schema.
Data
Description of data
schema
Database System
Development and maintenance of standards, policies and procedures
Data Administrator
Database System
- Physical realization of the
database - Physical database design
and implementation
Database Administrator
Database System
- Logical
- Physical
Database Designers
Importance of Database Design
refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data
Database Design
____________ specifications and/or poor logical data ________
Insufficient, modeling
Importance of Database Design: Transformations
Transforming entities to …
tables
Importance of Database Design: Transformations
Transforming attributes to
columns
Importance of Database Design: Transformations
Transforming domain into data types and
constraints
