Creating a database and tables Flashcards
Software that allows businesses to store and organize information
- inventory
- contact info
- etc
Database software
A collection of info that is organized so it can be easily accessed, managed, and updated
Database
Defining, manipulating, retrieving, and managing data in a database
Database Management
Information in one row
Record
Contains a unique identifier
Primary Field
Describes relationship between tables
One-to-many-relationships
Collection of connected tables and records
Relational Database
How do databases store data?
In tables: records and fields
Provides a convenient interface for database tables to work, by pulling information from different tables on a single datasheet
Queries
Printable summaries of the database information that make it easy to share information in an accessible and streamlines format
Reports
The foundation of relational databases and are used to store information
Tables
This application allows businesses and organizations to manage data
Data Applications
Examples of _____ _____:
- payroll
- employee records
- student info
Examples of business Operations
