Chapter 1 Flashcards
What is database?
A collection of related data
What is Database Management System (DBMS)
A software package/system to
facilitate the creation and maintenance of a computerized database.
Typical functionality of DBMS
Define,make,retrieve,modify,access,share
How do application use database
Queries: access different part of data and give result of request
Transaction: update data or make new data and store in database. Update/modify
Main Characteristics of the Database
Approach
Self describing nature(catalogue stores description of database), insulation(can change data structure and organization without changing access), data abstraction (data model used to hide or show to users with conceptual view) can be viewed many different ways, doesn’t allow unauthorized access,
What does database administrator do.
Authorizes access,
Data base designer job?
To define content ,structure,constraints and transactions
The types of end user:
Casual(access database occasionally) naive(uses predefined functions),sophisticated(business analyst,scientist,engineer) stand alone(keep personal database)
Job of a systems analyst;
Understand user requirements and design app
App programmer job:
Make sure there is no bug before deployment
Business analyst:
Analyze vast amount of data for decision making
Advantages of using the database approach:
Less redundancy, doesn’t allow unauthorized access, Sharing data among multiple user, can be viewed in many different ways,back up and recovery,
Why not use dbms?
When data is small and no change is expected, no need for multiple users to access, more cost, might not fit storage
