What is a database?
-Structured collection of related data.
Examples:Address book, Telephone Directory, Dictionary.
Why use Electronic Database?
- speed
- ease of use
- versatility
What are types of Electronic Database?
- Flat File Database-basically used for simple lists and may have duplication of data.
- Relational Database - data is held in a number of cross-referenced files in order to reduce duplication.They make it easier to find, analyze, maintain and protect your data because it is all held in one place.
- Database is composed of 1 or more tables
- Tables is composed of 1 or more records
- Records is composed of 1 or more fields
- Fields has a Datatype
What is a DBMS?
- stands for DataBase Management System
- a set of software that are used to define, store, manipulate and control the data in a database.
- define --- define data types, structures and constraints.
- store --- store data; provide efficient access.
- manipulate --- perform retrieval and update operations using a query language.
- control --- control access to data.
