ISMG6080
Database Management
Introduction
Zhiping Walter
Associate Professor of Information Systems
1
Content of This Video
• Overview of this video
– What a database is
– Topics to be covered
2
Database Examples
• Retrieving information from the web using a
search engine, e.g. Google
• Course registration system
• Payroll system
• Library catalog
3
Introduction to DBMS
What is a database management system and why do we need it?
Consider information processing requirements of the following
company:
International Product Distribution
Inventory
Purchasing Sales
Control
Manufacturer Warehouse Retailer
Accounting 4
Report
IPD Operations and Decisions
• Operations and Decisions
– Inventory replenishment
– Place purchasing orders
• from which supplier?
• How much to order
– Fullfill customer orders
• Information essential to these operations and
decisions
– How many units of product x has been sold last
quarter?
5
Customer Data
Cust-Id Cust-Name Address Country Beginning- Month-to-Date-
Balance Payments
100 Watabe Bros Box 241, Tokyo Japan 45,551 40,113
105 Jefferson B 918, Chicago USA 49,333 49,811
110 Gomez Santiago Chile 27,400 28,414
Sales-Reps Data
SalRep-Id SalRep-Name Manager-ID Office Commission(%)
10 Rodney Jones 27 Chicago 10
14 Masaji Matsu 44 Tokyo 11
39 Goro Azuma 44 Tokyo 10
Product Data
ProdId Desc SupplierId Cost Regular Price Inventory
1035 Sweater 210 22.00 35.00 20
2241 Coat 317 60.00 120.00 19
Sales Data
SaleId SaleDate RepId ProdId UnitPrice Quantity Total
21034 2/8/2017 14 2241 60 1 60
21034 2/8/2017 14 1035 33 2 66
21035 2/12/2017 39 2241 20 2 40
6
Solution: DBMS
You write a query:
Select salrep-name
From Sals-Reps
Where office=‘Tokyo’
DBMS instantaneously returns:
Masaji Matsu and Goro Azuma
You need some
Information
DBMS Database
7
Solution: DBMS
Database Management Systems
User
Database
Database
Management
User System (DBMS)
Database
•User Queries Allocating and Retrieving
•Application Development data from database, etc.
8
Course Objectives
• Design a database
– capture what users want stored, conceptual design
(Entity Relationship Diagram)
• systematic way of determining what data should be
stored in the database
– model useful data to be stored in a relational
database in an efficient way, logical design
(Normalization)
• Using Oracle to implement your design
9
Course Objectives, cont’d
• Query the database
– query languages for retrieving and extracting
information from DBMS
– using Oracle SQL Developer client to query the
database you designed
• We’ll use SQL Developer, downloadable free from
Oracle.com
10
What you would be able to do
• Go to any company, design a database for
its daily operation!
– electronic commerce: on-line bookstore, on-
line grocery store
– payroll system: keeps track of different types of
employees, different hourly rates, etc.
– campus-wide student registration system:
keeps track of instructors, students, courses
offered, grades, etc.
11
Who should NOT take this course
• This is an introductory database course
– designed for students with no prior database
knowledge and no database experience
• You should NOT take this class if
– You’ve taken an undergraduate database class
– You have extensive database work experience
– You’re proficient in SQL
• Take ISMG6480 Advanced database instead
12
Conclusions
• Databases are prevalent in businesses and in
our lives.
• It’s the foundation of other technologies.
• This course focuses on database design and
SQL
• Students will be able to
– design databases
– Implement databases using SQL
– Use SQL to interact with a database
13
