Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Introduction to Database Theory and Microsoft Access

No description
by

Tiffany Tawzer

on 27 June 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Introduction to Database Theory and Microsoft Access

Introduction to Database Theory and Microsoft Access
Tiffany Tawzer, NN/LM GMR
Why Databases?
The world runs on them
Content Management Systems
Citation Databases
Integrated Library Systems
Health Information Technology
Big Data
What is a Database?
Persistent storage of organized data
Database Models
Databases have evolved as technology, need, and ideas changed

Navigational
Relational
Post-relational
What is a Relational Database?
Table-based
Links data based on relationships
Entity-relationship (ER) model
WikiMedia Commons by RobH CC/SA
Entity
Something we want to describe.
Attribute
A characteristic of an entity.
Record
A single instance of an entity with all its attributes.
May also be called a "row" or "tuple."
Table
Collection of all records of an entity.
sharp
blue
four wheels
red
slow
old
reprint
200 pages
four wheels
red
slow
old
two wheels
red
slow
new
Relationship
Links between entities, attributes, and tables
Vehicles
Drivers
Students
Instructors
Classes
Student ID
First Name
Last Name
Email
Class ID
Title
Time
Day
Location
Employee ID
First Name
Last Name
Email
Office
Primary Key
Attribute or group of attributes that is unique for every instance of an entity
Roster
ID
Student ID
Class ID
Employee ID
Why Microsoft Access?
Relational Database Management System (RDMS)
Software or collection of software, often with a graphical interface, designed to create and manipulate relational databases
File Maker Pro
MySQL
Open Office Base
Oracle Database
Microsoft Access
…many, many more

Types of Relationships
One-to-One
One-to-Many
Many-to-Many
xxx-xx-xxxx
People
Agreements
Tools
Buildings
Vehicles
Wikimedia commons user Mattes. Public domain.
Data Exercise
Full transcript