DATA
- basic facts and figures, generally raw info simply includes basic texts and numbers
- In computers, it may be in the form of different types of files such as, images, texts, graphics and videos
DATA MANAGEMENT
- practice of collecting, organising, managing, and accessing data to support productivity, efficiency and decision-
making.
DATABASE
- electronically stored systematic collection of data.
- you can use DBMS to store, retrieve, and edit data
DATABASE ENTITY
- thing/object you are recording information about
ATTRIBUTES
- characteristics that describe the enity
WHY USE A DATABASE?
1. It can store very large number of records efficiently
2. Very quick and easy to find information
3. Easy to add new data and to edit or delete old data
4. Security may be better than in paper files
DATABASE MANAGEMENT SYSTEM (DBMS)
- used to define, manipulate, retrieve, store and manage data in databases
EXAMPLES OF DBSM
1. MySQL Database - 1995. famous due to its high efficiency, reliabiLity and cost
2. MS Access - create and maintain computer based database on desktop computers
3. Oracle Database- mostly used by big companies that need to manage large amount of data
4. IBM DB2 - store data for large companies, costs high
5. Microsoft SQL Server - create computer database for MS-Windows
FOUR BASIC OPERATIONS
DESIGN
- defining the tables and specifying field
DATA ENTRY
- adding actual data by hand or imported from other files
- basic facts and figures, generally raw info simply includes basic texts and numbers
- In computers, it may be in the form of different types of files such as, images, texts, graphics and videos
DATA MANAGEMENT
- practice of collecting, organising, managing, and accessing data to support productivity, efficiency and decision-
making.
DATABASE
- electronically stored systematic collection of data.
- you can use DBMS to store, retrieve, and edit data
DATABASE ENTITY
- thing/object you are recording information about
ATTRIBUTES
- characteristics that describe the enity
WHY USE A DATABASE?
1. It can store very large number of records efficiently
2. Very quick and easy to find information
3. Easy to add new data and to edit or delete old data
4. Security may be better than in paper files
DATABASE MANAGEMENT SYSTEM (DBMS)
- used to define, manipulate, retrieve, store and manage data in databases
EXAMPLES OF DBSM
1. MySQL Database - 1995. famous due to its high efficiency, reliabiLity and cost
2. MS Access - create and maintain computer based database on desktop computers
3. Oracle Database- mostly used by big companies that need to manage large amount of data
4. IBM DB2 - store data for large companies, costs high
5. Microsoft SQL Server - create computer database for MS-Windows
FOUR BASIC OPERATIONS
DESIGN
- defining the tables and specifying field
DATA ENTRY
- adding actual data by hand or imported from other files
