Modern Database Management for Business Applications - Prof. Bernard T. Han, Study notes of Introduction to Business Management

Download Modern Database Management for Business Applications - Prof. Bernard T. Han and more Study notes Introduction to Business Management in PDF only on Docsity!

Chapter 1 - Introduction to Database

Management

CIS4600 – Business DB

Applications

Lecture 1

Dr. Bernard Han

Welcome to CIS



Learn modern database technology:

 Crucial to the operation/management of modern organizations 

Focus on business transformations

 From business needs to database applications 

Need significant time commitment

 Learn by making mistakes 

How to succeed in this class?



Attend the class (absences ≤ 3; otherwise E)

What do you take away from this class?

Sufficient working knowledge in

 (^) Three-tier DB architecture using client/server approach  (^) Data modeling using graphic diagramming (ERD)  (^) DB inquiry using SQL (Access, SQL 2005, and Oracle)  (^) DB design – normalization and transformation skills  (^) DB administration  (^) Advanced DB programming using views, triggers, and stored procedures…

Lecture #1 Outline



Database characteristics



Three-layered Database Architecture



Organization administrative roles

Data vs. Information

Data Converted Into Aggregated Information Primitive Data Information

Example 2 - Data + Processing

Data converted into Graphic Information

An Example - University Database

University Database Registration Grade Recording Faculty Assignment Course Scheduling Entities: students, faculty, courses, offerings, enrollments Relationships: faculty teach offerings, students enroll in offerings, offerings made of courses, ...

An Example -- Water Utility Database

Billing Meter Reading Payment Processing Service Start/ Stop Entities : customers, meters, bills, payments, meter readings Relationships : bills sent to customers, customers make payments, customers use meters, ...

Database Architecture : An Example

Database Architecture : An Example

DATABASES License Renewal Dept Auto. Registration Dept State Revenue Dept Drivers file Automobile file Traffic violation file Fee payment file (^) Auto accident file Front-end Application Prog. Front-end Application Prog. Front-end Application Prog.

Database Management DBMS

System

Three-tiered Database Architecture

ANSI/Sparc 1975 Model Adopted by almost all existing DBMSs

External Level - End-user View

Conceptual Level - DBA’s View

Physical Level - System Designer’s View

Some synonyms:

User View <=> DB Schema <=> physical Data

Structure

Organizational Roles – Users vs. Builders

I n d i r e c t P a r a m e t r i c P o w e r F u n c t i o n a l U s e r T e c h n i c a l N o n T e c h n i c a l D B A A n a l y s t / P r o g r a m m e r M a n a g e m e n t I n f o r m a t i o n S y s t e m s S p e c i a l i z a t i o n YOU^ YOU DA^ DA

Database Specialists – DBA vs. DA



Database administrator (DBA)



More technical



DBMS specific skills



Data administrator



Less technical



Planning role

Summary



Databases and database technology

vital to modern organizations



Three-tiered DB architecture supports

daily operations and decision making



Numerous opportunities to work with

databases – DBA, DA, DB Designer, SA

Your Assignments



Read Chapter 1 and 2



See you Sept 10!!