06_DatabaseIntro_2up.pdf - CS 200 Lecture 06 Database...

CS 200
CS 200 Spring 2018
Database Introduction
1
Lecture 06
Database Introduction
CS 200 Spring 2018
Database Introduction
Abbreviations
•
aka also known as
•
DBMS DataBase Management System
•
mutatis mutantis with the necessary changes having been made
2
Miscellaneous Notes

CS 200 Spring 2018
Database Introduction
Please read and highlight BEFORE lab
•
Assignment 6
•
This week’s lecture slides
Reading
•
Database Design (on Learn > Database Resources > Database Design)
Adapted from Access Database Design and Programming by Steven Roman
Today
•
Database basics and Design
•
Creation of a database
•
Reports and Queries
•
Relationships
Please ask questions!
3
Administrativia
CS 200 Spring 2018
Database Introduction
Assumptions
You have used a database before
You understand basic data management
4

CS 200 Spring 2018
Database Introduction
Things to think about
•
What are the data objects in a database?
•
What are different databases you use?
•
How are the databases you are part of used?
•
Is the way data is displayed important?
5
CS 200 Spring 2018
Database Introduction
This is your first pass at databases. By the end of this section you will be able to:
•
design a simple database
•
think about queries and reports
•
understand database terminology and
•
create relationships with a database
Our objectives are
•
to introduce you to database fundamentals
6
Databases

CS 200 Spring 2018
Database Introduction
7
What is a Database?
CS 200 Spring 2018
SQL
Why use a database at all?
•
You have to decide if that effort is worthwhile
Obvious questions: