Database Systems In The Organization Flashcards
Database Managment and Desgin Book (Gary&James)
Database
A collection of interrelated, shared, and controlled data
Data Integration
Combining data for common use.
Electronic data processing
Computer automation of paperwork at the operational level of an organization.
Decision support system
Automated system providing strategic information to senior managment.
Distributed database system
A database system is made of several systems at local sites connected by communication lines.
Database planning
Strategic effort to determine information needs for an extended period.
Database development life cycle(DDLC)
A process for designing implementing and maintaining a database.
Database administration
Personnel with responsibility for controlling and protecting the database.
Conceptual database design
Identification of data elements, relationships, and constraints for a database.
Value constraint
A rule defining the permissible values for a specific data item
Physical database design
Determination of storage devices, access methods, and indexes for using a database.
View
A definition of a restricted portion of the database is also called a data view.
Schema
A definition of the logical structure of the entire database.
Information center
An area where users have facilities to do their computing
Retrieve only access
Database access with no update allowed
Data integrity
Accuracy and consistency of data values in the database.
Three level architecture
Standard database structure consisting of conceptual, external and internal levels
Conceptual level
Database structural level defining the logical schema of the database.
External level
Database structural level defining user views.
Internal level
Database structural level defining physical view of the database.
Database development life cycle(DDLC)
A process for designing implementing and maintaining a database system.
System development life cycle(SDLC)
A process for system development.
Function-oriented approach
Views a system from the perspective of the functions it should perform
Data-oriented approach
Focuses on the analysis of data used by functions.
Preliminary planning
Planning for a database that occurs during the strategic database planning process.
Feasibility study
A portion of the DDLC that determines the technological operational and economic feasibility of the database.
Technological feasibility
Determination of hardware and software availability for database system.
Operational feasibility
Determination of availability of expertise and personnel needed for the database system.
Economic feasibility
Cost-benefit study of proposed database system.
Requirements definition
Determination of management and fun
Conceptual Design
Creation of conceptual level schema for database
Database Implementation
The steps required to change a conceptual design to a functioning database.
