Transcript Databases

Databases
Christopher M. Pascucci
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.
Database Structure
Database
Table(s)
Record(s)
Field(s)
Database Structure
• Table
Chris Pascucci Grad Student
Joe Shmoe
Undergrad
Jane Dough
Undergrad
Tom Jackson
Grad Student
Fields
UPENN
Temple
Drexel
Villanova
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
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.
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
More Definitions
• Filter
• Query