Docstoc

Database Application Pine Valley Furniture

Document Sample
Database Application Pine Valley Furniture Powered By Docstoc
					Database Application Pine Valley Furniture
MGIS 641
Koç University

Learning objectives






 

Identify the steps in the development of a DB Understand the skills needed to design & develop a DB application Use the rudimentary features of a DBMS Explain the various components of a DBMS Read E-R diagrams & draw E-R diagrams to describe a DB Construct simple tables, queries, forms etc using MS Access

Introduction
Gain basic understanding of developing IS apps. using DB technology - what you will be able to do  A concrete example -helps understanding  Information to help you to work on the DB Course Project


The development of a DB application




DB App. System : The data definitions, stored data, transaction inquiries, screens, reports & other programs needed to capture, maintain, & present data from a DB. Steps : analysis of business needs, functional design of a system that meet these needs, physical design that meets time & space expectations , programming, testing, documentation, installation & training – not all the activities will be illustrated here

DB development outline


Enterprise Modeling
– Analyse current DP – Analyse general business functions & their DB needs – Plan DB development Project


– Design screens, reports, & applications

Physical DB Design
– Define DB to DBMS – Decide on physical organisation of data – Design programs



Conceptual Data Modeling
– Analyse overall data requirements for business functions supported by DB – Develop a preliminary conceptual data model


DB Implementation
– Code & test programs – Complete documentation – Install & convert from previous system



Logical DB Design
– Analyse in detail the Bus.Func.s – Normalise transactions & reports – Integrate views into conceptual data model


DB Maintenance
– Analyse DB & apps. for Info requirements met – Tune DB – Fix Errors

Pine Valley enterprise data model
: 0 to many Places CUSTOMER mandatory 1 mandatory 1 to many Bills

ORDER

Fulfills

INVOICE

Requests

PRODUCT

Ships

Builds RAW MATERIAL Uses

WORK ORDER

Supplies

VENDOR

PVF conceptual data model
Places
CUSTOMER

ORDER

Requests

PRODUCT

TP requirements for PVF


Business transaction : All the data about a business event which might cause several DB transactions to add, delete or change DB records
– In PVF concentrate on order entry, customer service, & product management areas

Product entry
ROOM

FINISH

PRODUCT DISPLAY PRODUCT NO : PRODUCT NAME : ROOM : FINISH : UNIT PRICE : QUANTITY IN STOCK : 1234 TABLE DINING TEAK 2345.80 23

NAME

UNIT PRICE

PRODUCT NO PRODUCT

QUANTITY IN STOCK

E-R Diagram for product display Product Display

Customer entry
ADDRESS

CITY

CUSTOMER DISPLAY CUSTOMER NO : NAME : ADDRESS : CITY STATE ZIP CODE : DISCOUNT % : AHMET AHMET A.S. XXXX ISTANBUL 8

NAME

DISCOUNT

CUST NO CUSTOMER

E-R Diagram for customer display Customer Display

Design for product management menu
PRODUCT MANAGEMENT Enter Data About a New Product Change Data About a Product Delete All Data About a Product Display Data About a Product Exit Product Management

Sample customer order
CUSTOMER ORDER ORDER No :17774 Customer No: 5647 Name : Koc university Address Istinye , istanbul Order date : 21/3/1996 Promised Date : 28/3/1996 Product No S4536 M655 Description Chair Desk Quantity 360 120 Unit price 400,000 1,200,00

Order Entry Screen

E-R Diagram for order-entry
NAME ADDRESS

CUST NO
ORDER NO Places CUSTOMER CITY

ORDER

PROMISED DATE

NAME

ORDER DATE Requests

PRODUCT

PRODUCT NO

QUANTITY UNIT PRICE

E-R Diagram for all TP
NAME ADDRESS

CUST NO
ORDER NO Places CUSTOMER DISCOUNT ORDER PROMISED DATE CITY

NAME

ORDER DATE Requests

PRODUCT

PRODUCT NO

QUANTITY ON HAND QUANTITY ROOM UNIT PRICE

MI requirements for PVF
DISCOUNT INQUIRY CUSTOMER ID : AHMET NAME : AHMET A.S.
DISCOUNT % : 8 CUST NO CUSTOMER

NAME
DISCOUNT

Discount rate inquiry E-R Diagram for Discount rate inquiry

Daily order log
DAILY ORDER LOG 13-Feb-96 CUSTOMER NAME AHMET A.S. MEHMET A.S. ORDER NO 1589 2389 PROMISED DATE 22-Feb-95 10-Mar-95

ORDER NO

Places CUSTOMER

NAME

ORDER

PROMISED DATE

ORDER DATE

customer order history
CUSTOMER ORDER HISTORY Feb 13, 1996 to Feb 22 1996 ORDER DATE ORDER NO PRODUCT NO QUANTITY ORDERED
CUSTOMER AHMET 13-Feb-95 1234 22-Feb-95 2345

34567 7689 TOTAL

30 22 52

ORDER NO

screen

ORDER

Places CUSTOMER

NAME

ORDER DATE Requests PRODUCT

PRODUCT NO

QUANTITY

E-R diagram


				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:527
posted:11/9/2009
language:English
pages:17