DataBase CH1 Flashcards
what is an Information?
- refers to the data that is accessed by the user
What is a Data?
- A fact that can be stored or accessed
The definition of Database
- A structured collection of related data stored on a computer medium
What is a Database Management System (DBMS)
- Used for inserting , creating, maintaining and storing database
What is a Database system?
- Enabling interaction between the user and the information captured in a database
- The DBMS together with the data itself
The definition of Database Metadata
- The structure of database
(Data About Data)
Description of database structures , data types and the constraints on the database.
DataBase Schema
The database content at the moment
DataBase State
which database changes frequently and which changes every time the database is updated?
Database schema changes frequently
Database state changes with every update
The definition of valid state
- Satisfies the structure and the constrains of the database
Data Definition language is used
- by database DBA and designers to specify conceptual schema of a database
- used also to define external and internal schemas
Data Manipulating Language
- Used to specify database retrievals and updates
- stand-alone DML commands can be applied directly
Front-end applications
easy interaction between the users and the DBMS
users using a database system to support their tasks and processes
End-users (business-users)
Indirect interaction
end-user communicating with the database through front-end applications
