Lesson 1: Database Flashcards
It is an organized collection of data stored in a computer system and usually controlled by database management systems.
Database
A database is a structured collection of data that allows you to ___, ___, and ___ information easily.
store, manage, retrieve
It is an essential part of our life.
Database
It is the thing or object you are recording information about.
Entity
These are the characteristics that describe the entities.
Attributes
A database stores and organizes data in an organized manner and offers tools for quickly ___, ___, and ___ that data.
retrieving, updating, and managing
What are 5 real-world examples of relational databases?
- Retail Industry - Inventory Management
- Health Care - Electronic Medical Records
- Finance - Banking and Trading Systems
- E-commerce - Customer and Order Management
- Social Media and Online Platforms
Why use a database?
- It can store very large number of records efficiently.
- It is very quick and easy to find information.
- It is easy to add new data and to edit or to delete old data.
- Security may be better than in paper files.
What are database management systems in charge for?
- Defining rules to validate and manipulate data.
- Interacting with databases, applications, and end users.
- Retrieving, storing, and analyzing data.
- Updating data.
What are examples of DBMS?
- MySQL Database
- MS Access
- Oracle Database
- IBM D2
- Microsoft SQL Server
What are the four basic operations in a database?
- Design
- Data Entry
- Queries
- Reports
In this basic operation, you create the database by defining the tables and specifying the fields.
Design
In this basic operation, you add the actual data by hand or imported from other files. Easy to make errors.
Data Entry
In this basic operation, you ask questions about the data.
Queries
In this basic operation, you produce a document with information.
Reports
