Database Design Flashcards
system that provides for data collection, storage, and retrieval
Information System
An information system is composed of
- hardware,
- the DBMS and other software, database(s),
- People
- Procedures
the process that establishes the need for an information system and its extent.
System Analysis
System Development
System Development
three factors an information system depends on
Database design and ______________
implementation
three factors an information system depends on
________ design and implementation
Application
three factors an information system depends on
____________ procedures
Administrative
the process of database design and implementation
Database Development
to create complete, normalized, no redundancy, and fully integrated conceptual, logical, and physical
database models is the primary objective of what?
Database Design
This phase includes creating the database storage structure, loading data into the database, and providing for data management.
implementation
a cycle that traces the history of an information system.
System Development Life Cycle (SDLC)
System Development Life Cycle (SDLC)
This phase yields a general overview of the company and its objectives
PLANNING
System Development Life Cycle (SDLC)
This phase of the SDLC is, in effect, a thorough audit of user requirements.
ANALYSIS
System Development Life Cycle (SDLC)
This phase includes all the necessary technical specifications for the screens, menus,
reports, and other devices that might help make the system a more efficient information
generator
DETAILED SYSTEMS DESIGN
System Development Life Cycle (SDLC)
This phase is where actual database is created, and the system is customized by the creation of table
views, user authorization and so on.
IMPLEMENTATION
System Development Life Cycle (SDLC)
This phase is where the system is operational and end users begin to request changes in it
MAINTENANCE
system maintenance activities
maintenance in response to systems errors
Corrective maintenance
system maintenance activities
maintenance due to changes in the business environment
Adaptive maintenance
system maintenance activities
maintenance to enhance the system
Perfective
A cycle that traces the history of a database within an information system.
DATABASE LIFE CYCLE
The overall purpose of the database initial study
- Analyze the company situation
- Define problems and constraints
- Define objectives
- Define scope and boundaries
most critical DBCL phase since it will make sure that the final product meets the user and system requirements.
DATABASE DESIGN
Two views of data
data as a source of
information
business view
Two views of data
data structure, its access, and the activities required to transform the data into information.
designer’s view
includes creation of tables, attributes, domains, views, indexes, security constraints and storage and performance guidelines
IMPLEMENTATION AND LOADING
It describe the general condition in which the company operates, its organizational structure, and its mission.
Analyze the company situation
Should answer questions like:
* How does the existing function?
* What input does the system require?
* What document does the system generated?
* By whom and how the is the system output used?
Define problems and constraints
The database designer must address the
following questions:
* What is the proposed system’s initial objective?
* Will the system interface with other existing or future systems in the company?
* Will the system share the data with other systems or users?
Define Objectives
It helps define the required data structures, the type and number of
entities, the physical size of the database, and so on.
Define Scopes and Boundaries
defines the extent of the design according to operational requirements.
system’s scope
Actions in database implementation and loading
a technique that creates logical representations
of computing resources that are independent of the underlying physical computing resources.
Install DBMS, Virtualization
Actions in database implementation and loading
creation of special storagerelated constructs to house the end-user tables.
Create Database(s)
Actions in database implementation and loading
Data will be migrated from the prior version of the system.
Load or Convert the data
DBA test and fine-tunes the database to ensure that is performed as expected
TESTING AND EVALUATION
