Databases

1
Databases

• Christopher M. Pascucci

2
What is a Database

• a database is a collection of records stored in a
  computer in a systematic way, so that you to find
  useful information.
• Collection of all the data related to a
  particular topic or purpose -- for example,
  student data, customer data or product data.
• Most common type of database is a Relational
  database, which is a collection of related tables
  that share information.

3
Database Structure
4
Database Structure

• Table

Chris Pascucci Grad Student UPENN Joe Shmoe
Undergrad Temple Jane Dough
Undergrad Drexel Tom Jackson Grad
Student Villanova
Fields
5
Definitions

• Data Field
• A single piece of information
• Name, Age, City, State, Date, etc
• Data Record
• A complete set of related data fields
• Student, Customer, Employee

6
Why Use A Database?

• To enter data quickly and easily that is stored
  for later use.
• Organize records in different and useful ways.
• Locate specific records quickly.
• Eliminate data.
• Create Queries.
• Create Reports.

7
Data Management Software

• Database Management Systems (DBMS)
• A collection of programs that enables you to
  enter, organize, and select data in a database.
• Examples
• SQL Server
• Oracle
• Access

8
More Definitions

• Filter
• Query