Transcript cos346day1

COS 346
Day 1
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-1
Agenda
•
•
•
•
•
•
Roll Call
Introduction
WebCT Overview
Syllabus Review
Contract for Classroom Behavior
Introduction To Database Processing
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-2
INSTRUCTOR
• Tony Gauvin, Assistant Professor of ECommerce
• Contact info
– 216 Nadeau
– [email protected]
– (207) 834-7519 or ext 7519
– WebCT (Tony Gauvin COS 346)
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-3
Instructional Philosophy
• Out-Come based education
• Would rather discuss than lecture
– Requires student preparation
• Hate grading assignments
– Especially LATE assignments
• Use class interaction, assignments,
quizzes and projects to determine if
outcomes are met.
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-4
COS 346 Survival Primer
• Read Material BEFORE the class discussion
• Check WebCT Often
• Use the additional resources identified in syllabus
• ASK questions about what you didn’t understand in
readings
• DON’T do assignments and projects at last minute.
• REVEIW lectures and notes
• Seek HELP if you are having difficulties
• OFFER feedback and suggestions to the instructor in a
constructive manner
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-5
Computer Accounts
• Computer login
– Sys admin
• Ray Albert for desktops
• Tony Gauvin for servers
– Applications
• MSDN Academic Alliance
– Free Stuff
– See Dr Ray Albert
• Access Cards
– $10 deposit
– See Lisa Fournier
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-6
WebCT
• http://webct.umfk.maine.edu
• Login
– First name. Last Name
– John Doe  John.Doe
– Initial password is webct
• Help with WebCT available from Blake Library
staff
• All quizzes and assignments will be
administered from WebCT
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-7
Syllabus review
•
•
•
•
•
•
Requirements
Grading
Course outline
Special Notes
Subject to change
Classroom Contract
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-8
David M. Kroenke’s
Database Processing:
Fundamentals, Design, and Implementation
Chapter One: Introduction
Part One
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-9
Chapter Objectives
• To understand the nature and characteristics of
databases
• To survey some important and interesting database
applications
• To gain a general understanding of tables and
relationships
• To describe the components of a Microsoft Access
database system and explain the functions they perform
• To describe the components of an enterprise-class
database system and explain the functions they perform
• To define the term database management system
(DBMS) and describe the functions of a DBMS
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-10
Chapter Objectives
• To define the term database and describe what is
contained within the database
• To define the term metadata and provide examples of
metadata
• To define and understand database design from existing
data
• To define and understand database design as new
systems development
• To define and understand database design in database
redesign
• To understand the history and development of database
processing
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-11
The Characteristics of Databases
• The purpose of a database is to help people
track things of interest to them
• Data is stored in tables, which have rows and
columns like a spreadsheet. A database may
have multiple tables, where each table stores
data about a different thing
• Each row in a table stores data about an
occurrence or instance of the thing of interest
• A database stores data and relationships
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-12
Naming Conventions in this Textbook
• Table Names are written with all capital
letters:
– STUDENT, CLASS, GRADE
• Column names are written with an initial
capital letter, and compound names are
written with a capital letter on each word:
– Term, Section, ClassNumber, StudentName
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-13
Data in Tables
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-14
The Key Characteristic of
Databases: Related Tables
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-15
Databases Create Information
• Data = Recorded facts and figures
• Information = Knowledge derived from
data
• Databases record data, but they do so in
such a way that we can produce
information from the data
– The data on STUDENTs, CLASSes and
GRADEs could produce information about
each student’s GPA
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-16
Database Examples
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-17
Components of a Database
System: Microsoft Access
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-18
Microsoft Access
• Microsoft Access is a low-end product intended
for individual users and small workgroups
• MS Access tries to hide much of the underlying
database technology from the user
• A good strategy for beginners, but not for
database professionals
• NOTE: MS Access is discussed in detail in
Appendix A
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-19
MS Access in Detail
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-20
Example SQL
SELECT StudentNames, EmailAddress
FROM STUDENT
Where StudentNumber > 200
If Exists
( SELECT *
FROM SYSOBJECTS
WHERE [Name] = ‘CLASS’
AND type = ‘U’)
DROP TABLE CLASS
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-21
Applications, the DBMS and SQL
• Applications are the computer programs
that users work with
• The Database Management System
(DBMS) creates, processes and
administers databases
• Structured Query Language (SQL) is an
internationally recognized standard
database language that is used by all
commercial DBMSs
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-22
What Is MS Access?
• MS Access is a DBMS plus an application
generator:
– DBMS creates, processes and administers MS
Access databases
– The application generator includes query, form and
report components
• The MS Access DBMS engine is called Jet,
which is not sold as a separate product
• MS Access 2000 and later can be used as an
application generator for the MS SQL Server
DBMS
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-23
Enterprise-Class Database
Systems
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-24
Prominent DBMS Products
• Microsoft Access
• Microsoft SQL Server
– New: Microsoft SQL Server Express
• IBM DB2
• Oracle Corporation ORACLE
• And don’t overlook MySQL
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-25
DBMS Power vs. Ease of Use
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-26
The Database
• A database is a self-describing collection
of integrated tables
• The tables are called integrated because
they store data about the relationships
between the rows of data
• A database is called self-describing
because it stores a description of itself
• The self-describing data are called
metadata, which is data about data
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-27
Typical Metadata Tables
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-28
Database Contents
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-29
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-30
For next Class
• Get familiar with resources
• Read Chap 1 & 2 of Kroenke text
• Assignment 1 is posted in WebCt
– Due Jan 25 at beginning of Class
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-31
David M. Kroenke’s
Database Processing
Fundamentals, Design, and Implementation
(10th Edition)
End of Presentation:
Chapter One - Part One
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
1-32