Database Applications PDF
Database Applications PDF
Database Applications PDF
Lesson Objectives
Library
University
Banking
Credit Card Transactions
Billing
Stock Broker
S l
Sales
Manufacturing
Payroll
Inventory
Insurance
Airlines
Rental
Employment
Transportation
R lE
Real
Estate
t t
Fuel Station
Hotel
Health
Taxi
Land Registry
Registration of Births
Passport
Print bill
Produce large volumes of output on a reoccurring basis
Hospital Information
Systems
Clinic Administration
Accounting
Laboratory Information
P
Processing
i
Pharmacy Management
Hospital IS
Hospital IS
Sorting, Selecting, Summarising and Reporting Data
Sorting
Selecting
Summarising
By room number
Reporting
Retail Store
Computer System
Print invoice
Print Daily Sales Report
Print Re-order Items
Air Lines
Rapid Retrieval
Hotels
Rapid Retrieval
Availability of Rooms,
reservation
ti
Telephone Operator
Rapid Retrieval
Stock Broker
Rapid Retrieval
Financials
Asset Management
Financial Planning
Financial Analysis
y
Financial Consolidation
Expenditure
p
Management
g
Billing and Cash Collection
Cash Management
Accounting
Inventory Control
Accounting Receivable
Accounting
g Payable
y
Payroll
General Ledger
g
Human Resource
Effective Recruitment
Effective Training, Retention
and Career Planning
Compensation Management
and Flexible, Scaleable Payroll
Flexible Organisation Planning
Management Sciences
Projects
Project Tracking
Cost Collection
Revenue Accrual and Billing
g
Capitalisation of Project Costs
Cross Project
j
Analysis
y
Manufacturing
Bill of Materials
Processing
Material
Reimbursements
Planning
J bC
Job
Costing
ti C
Control
t l
Order Entry / Inventory
Management
Production Control
Purchasing
Manufacturing
Library
Membership
Reference
Borrow
Return
Order
INVENTORY
y
Store Name | Part No | Q
Quantity
ORDERS
Store Name | Part No | Vendor No | Order No | Q
Quantity
y
PRODUCT
Product No | Description
p
SUPPLIER
Supplier
pp
No | Supplier
pp
Name
ORDERS
Store 1 | P3 | 3428 | 0052 | 10
Store 2 | P2 | 3428 | 0098 | 7
Store 2 | P3 | 3428 | 0098 | 15
Store 2 | P4 | 5726 | 0099 | 1
PRODUCT
P1 | Printer
P2 | Diskette
P3 | Disk Drive
P4 | Modem
STORE
Store 1 | Colombo
Store 2 | Kandy
INVENTORY
St
Store
1 | P1 | 50
Store 1 | P3 | 20
Store 2 | P2 | 100
Store 2 | P1 | 30
SUPPLIER
3428 | East West
5726 | DMS
Data - Suppliers
Data - Orders
Information -
Relationships
To integrate data and provide required information