IEOR 115 Industrial and Commercial Data Systems

Download Report

Transcript IEOR 115 Industrial and Commercial Data Systems

IEOR 115
Industrial and Commercial Data Systems
Fall 2013, Lab 1
Animesh Garg
PhD Student, IEOR
Intro to MS Access
• Database creation and
management program
• We will learn
– Relational Databases
– Implementation in MS Access
2
Access to MS Access
• Install on Personal Laptops
– Windows
Get from UC Berkeley Software Central
http://ist.berkeley.edu/MS-DL-instructions
– Mac / *nix
Bootcamp / Parallels / VM
• Use Lab Machines- Guest Accounts
UserID: !ieor-e10-15, Pwd: zxc!@#123
• Still Facing problems? Meet me in OH
3
What are Databases
• Collection of Correlated Lists/Tables
4
What are Databases
5
Why Database? Why not Excel?
• Excel: Good for numerical analysis
• No way of capturing Correlation
• DB Maintenance is
a problem?
• Hence we need,
Relational Database
to create, maintain,
search and analyze
data in multiple tables
at once
6
Main Features of Access
•
•
•
•
Tables
Queries
Forms
Reports
7
Tables
8
Tables
• Data is stored as Rows and Columns
9
Tables
• Columns = Fields
Fields organizes data by Type
• Rows = Records
Record is Unit of information: Tuple
10
Forms
11
Queries
• Analyze data
12
Reports
• Present data
13
Case Study: Library Management
14
Terminology
MS Access (Lab)
Lecture/Text
Table (Lab 3)
Relation (Ch. 5)
Column/Field (Lab 3)
Attribute (Ch. 3)
Row/Record (Lab 3)
Tuple (Ch. 5)
Relationship View
(Lab 4)
Lines indicate foreign
keys (Ch. 7)
Relationship View is NOT the same as ER Diagram from lectures
15
Quiz
• Lab Notes and Quiz posted
http://www.ieor.berkeley.edu/~ieor115/labs.html
• Deadline: Friday, 13 Sept.
• Reminder: Contact Report Due 9, Sept.
Template Posted, please download
and use it
16
How to submit HW/Quizzes
• Pandagrader.com
• You will receive a invite, Sign up!
• Download HW template from Class
Website (pdf/word)
• Fill out answers in Assigned Spaces
without changing Template
• Submit as pdf on Pandagrader.com
• Make Pdf using: Save as PDF, Scanner or
Photo Scanner Apps (e.g. CamScanner)
17