Please enable JavaScript.
Coggle requires JavaScript to display documents.
CHAPTER 1 : DATABASE SYSTEM (DATABASE ((Shared, integrated vomputer…
CHAPTER 1 : DATABASE SYSTEM
DATABASE
Shared, integrated vomputer structure that stores a collection of data
End user data : raw facts of interest to the end user
Metadata : data about data
Provides description of data characteristics and relationships in data
Complements and expands value of data
DATABASE MANAGEMENT SYSTEM (DBMS)
manage structure and control access to data
DATA VS INFORMATION
Data are raw facts
Raw data must be formatted for storage, processing, and presentation
Data are the foundation of information, which is the bedrock of knowledge
Building blocks of information
Information is the result of processing raw data to reveal meaning
Information requires context to reveal meaning
Information produced by processing data
Information used to reveal meaning in data
Accurate, relevant, timely information is the key to good decision making and organisational
IMPORTANCE OF DATABASE DESIGN
Poorly designed database
Causes difficult to trace errors
Well- designed database
Facilitates data management
Database design focuses on design of database structure used for end - user data
Designer must identify database's expected use
Generates accurate and valuables information
TYPES OF DATABASE
Single - user database : Desktop database, runs on PC
Multiuser database : Workgroup database supports a small number
Enterprise database supports a large number
Centralized database
Data located at single site
Distributed database
Data distributed across several different sites
Operational database
Supports a company 's day to dat operations
Data warehouse
Stores data used for tactical or strategic decisions
Unstructured data
Exist in their original state
Structured data
Applied based on type of processing to be performed
Semistructured data
Processed to dome element
Extensible markup language (XML)
Represents data elements in textual format
XML database
Supports semistrured XML data
DATABASE SYSTEM ENVIRONMENT
Defines and regulates the collection, storage, management, use of data
Major parts of database system
Hardware
Software
People
Procedures
Data
DBMS FUNCTION
Data storage management
Security management
Multiuser access control
Backup and recovery management
Data integrity management
Database access languages and applications programming interfaces
Data transformation and presentation
ROLES OF DBMS
DBMS is the intermediary between user and the database
Database structure stored as file collection
Access database through the DBMS
DBMS enables data to be shared
DBMS integrates many user's views of data
THE ADVANTAGES OF DBMS
improved data sharing
Improved data security
Better data integration
Minimized data inconsistency
Improved data access
Improved decision making
Increased end user productivity