- What is data?
data is known facts that can be recorded and have an implicit meaning.
- What is a Database?
A database is a collection of related data.those are stored and accessed electronically from a computer system.
- There are four types of databases.
- text databases
- desktop databases
- relational database management system
- object-oriented database
- There are two ways to categorize the database according to the logical design.
- Operational database
- Database Warehouse
Example of a database
Mini-world -mini-world is some part of the real world about which data stored in a database.
Mini-world for the example: part of a school environment.
Mini world entities:
- Teacher
- Student
- Extra curriculum activities
- Results
Mini-world relationships
- Students are playing cricket.
- The teacher teaches the students.
Database
Main characteristics of Database Technology
- Self - contained nature of a database system.
- Insulation between programs and data.
- Data abstraction.
- Support for multiple views of the data.
Additional Characteristics of Database Technology
- Data sharing among multiple users.
- Complex relationships are represented among data.
- Providing backup and recovery services.
- Restricting unauthorized access to data.
Classes of Database users on the scene
that's means persons whose job involves daily use of a large database.
- Database administrators.
- Database Designers
- end-users
causal end users
Parametric end users
- Sophisticated end users.
- System analyzers/Application programmers.
- DBMS designers and implementer s.
- Tool Developers.
- Operators and maintenance personal.
- What Is Database Management system?
Database Management System (DBMS) is a software system. It is used to create, organize and manage the database.it facilitates the creation and maintenance of a computerized database.DBMS allows the definition, creation, querying, update and administration of the database.
Examples for DBMS
- MySQL
- Maria DB
- Oracle
- PostgreSQL
- MSSQL
DBMS are using some common terminologies.
- Tuple : tuple is the rows in the database.
- Table : table is a collection of tuples.and also it has related information with key.therefore, table can have duplication of data tuples.
- Schema : Schema is the structure of the relation or a table.
- Data Redundancy : Data redundancy ensure there are no multiple occurrence of some data hence avoids data duplication.
- Key: Keys in a table are related to identify the unique attribute of the table.
- Tuple : tuple is the rows in the database.
- Table : table is a collection of tuples.and also it has related information with key.therefore, table can have duplication of data tuples.
- Schema : Schema is the structure of the relation or a table.
- Data Redundancy : Data redundancy ensure there are no multiple occurrence of some data hence avoids data duplication.
- Key: Keys in a table are related to identify the unique attribute of the table.
- What is Database System?
The Database Management software together with the data itself call as Database system
