cornstarch宠物医院大作业实验报告(英文版)

1. Experience Scheme

Experimental goals

a)

Design the pet hostipal database

b)

Define the application functionalities the project will provide with the database.

c)

Implement this application using developing tools.

By finishing these three basic goals, we try to understand deeply the knowledge of database we

study this term. What

’

s more, we should know how we can do better to apply database into our

project. To improve our ability of team work is also one of the goal.

Experiment places, apparatus, equipment and materials

Experiment places

：

Jobs are mostly done on our own computers.

Apparatus, equipment and materials:

During

the

experiment

we

need

both

software

tools

and

computers.

The

software

includes

Dreamweaver 8.0, Tomcat 6.0,JDK1.60,JSP

＋

SQL server 2000 and Eclips.

Experimental scheme

This project is started for the goal of understanding the database concepts and leaning to make

SQL Server into an application. Two main tasks will be done in the project, one is database design,

and the other is to implement a web- based application with the using JSP+SQL SERVER 2000.

The following lists the experiment procedures:

(1)

Determine domain:

a)

a) A description of the application domain of the project.

b) State as clearly as possible what we will accomplish.

c) A description of the functionalities what the project plan to offer.

(2)

Requirement analysis:

a) Define the function modules specifically.

b) Finish a global chart of the function for the whole project

(3)

Determining business rules

(4)

Conceptual model design:

a) Entity sets and attributes determining b) Relational sets and attributes determining

c) Overall E-R diagram

(5) Logical structure design

a) Relational table reduction

b) Constraints definition

c) Table and attributes description

d) Views design

(6) Physical design

(7) Interface design

(8) Programming the database application to finish all the SQL sentences associate to the

Project.

(8) Implementing using JSP+SQL SERVER 2000 with the help of Dreamweaver 8.0.

(9) Design a plan for testing and make it.

Task division:

The

project

is

to

accomplish

by

a

team

of

three

students.

Xushaojun

and

Hewei

will

be

responsible for directing and controlling the whole procedures. They will also mainly take part in

designing the database and finish the implementation. Shenzhen take part in the work design the

functional modules and database to decide the basic frame of what we try to accomplish. For more

details, Xu does most of the work on entities and handles data on the whole tables. Hewei does

most of the jobs on draw the relational table forms and handle data on all the products.

The opinions of the adviser to the experiment scheme

The adviser

’

s signature

：

Date(Y ear/Month/Day)

：

I. Experiment Procedures

1. Requirement Description

With the increasing number of urban pets, many of the emerging pet industry in the park cities

expected. Professional pet bathing, pet tailors, pet photography, pet matchmaking business services

and other specialized industries such as sprung up to develop, and formed a huge industry for the

pet, the inevitable result is more professional pet services, exclusive of .

Pet Clinic pet care industry is accompanied by the emergence of a new industry. Large and

medium

cities

in

China

such

as

Beijing,

Shanghai

and

other

pet

hospitals,

pet

beauty

salons

are

already many, there are a number of universities or research institutes to open the pet clinic. Many

pet hospital services include not only medical care, operating income also includes sale of pets, pet

supplies and food sales, pet foster care, pet grooming and so on. Along with the universality of pet,

pet clinics in the future the industry is bound to have a rapid development. In order to improve the

efficiency of the treatment of pets, most pet hospital uses a computer office.

From the Internet to collect information on a number of pet hospitals, pet clinics, staff work

needs

to

access

and

manage

the

following

information:

veterinary

clinics,

customers

and

clients

pets.

Veterinary clinics

have different

expertise, such as dental, some good, some good medicine

and

so

on.

If

these

are

manually

office

flowers,

which

will

greatly

reduce

the

speed

of

office,

increasing the company's costs and reduce the company's profits.

Therefore, a need to

develop

a

clinic

office

systems,

clinic

staff

can

be

in

the

company's

access

to

any

computer

on

the

pet

information, customer information, veterinary information. Pet Clinic members can register users,

log

system,

query

Pet

related

information,

visit

the

pet

information,

reservation

services,

and

ordering pet products. Visitors browsing static content only.

2. Requirement Analysis

The system should have the corresponding functions

：

(1)Employee:

1)

login system.

2)

browse veterinary clinics, as well as their expertise.

3)

view pet owners (ie, members of the clinic) and related information.

4)

updated information about pet ownership.

5)

view pet related information.

6)

updated pet related information.

7)

to the system to add a new pet.

8)

browse visit pet history.

9)

pet's visit to the historical record to add a visit.

10) updated regularly static content (ie, pet information).

11) received orders for services and goods.

(2) Member:

1)

registered members.

2)

login system.

3)

booking service (medical, beauty).

4)

order pet products.

5)

query information on pets and pet reminders

3. Determining Business Rules

(1)

All users can browse pet information, but only registered members can submit orders for

goods and services in a single; only registered staff in order to maintain the system information

and accept orders.

(2)

Each member is uniquely identified by a membership number.

(3)

Each staff member is uniquely identified by staff numbers.

(4)

product number is the unique identification of goods. System needs to record the number

of

the

current

inventory

for

each

commodity,

when

the

inventory

falls

below

a

certain

threshold, then notify the replenishment.

(5)

purchase of goods must be placed in shopping cart before generating orders, subscription

services must generate a ticket.

(6)

Each order is uniquely identified with the order number. Order number is

generated by

the system in chronological order, orders submitted after the greater number of orders.

(7)

Each

service

alone

a

single

number

that

uniquely

identifies

service.

Single-number

service in chronological order by the system generated and submitted to a single service with

greater service to a single number.

(8)

orders

and

tickets

need

to

record

the

current

state,

including

the

unaudited,

back,

moderated, so the state has dealt with the end.

(9)

the same order can order a variety of goods, and the quantity can be different. Therefore,

an

order

may

include

multiple

product

details,

including

the

number

of

goods

trade

names,

order quantity, order price. Orders for each product required to document their status, including

non-delivery, has been delivery, has been sent to other states.

(10)

agree

that

the

Service

alone

can

order

a

variety

of

services,

service

single

including

service numbers, service name and service hours.

(11)

before receiving orders to allow members to delete the selected commodities, modify the

number of purchase of goods, delivery information and invoice unit, or even cancel the order.

However, after the adoption of orders reviewed, then not allowed to do any changes.

(12)

before receiving a single service allows members to delete the selected service, modify

the service number, service name, or even cancel a ticket. But the service after the adoption of

a single examination, it is not allowed to do any changes.

(13)

orders and tickets to the principle of first come first serve.

(14)

distribution by just a single number identity distribution. Orders and service orders for

each delivery order number from a single number is coupled with the system in chronological

order, the composition of the generated serial number.

(15)

When the orders are delivered in a commodity, then update the status of the book

been sent to.

order status as

(16)

a member may make a number of messages, a staff member can get back to more than

one message.

figure 1

Pet hospital system business processes

begin

register

member

？

N

register

login

Y

service choice

pet

shop

pet

hospital

pet

information

Fill

service

information

choice payment type

pay online

？

Y

Financial settlement

N

Order create

end

figure 2

Visitors Business Process

begin

vistor

(access directly)

service interface

pet

information

end

figure 3

System Administrator Business Process

：

begin

login

update

system

serviec

order

？

Y

audit

return

N

true

？

N

Y

invoice create

send

create

end

4. Conceptual model design

4.1 Determining entity sets and attributes

er(

cust_id

,p_word,cust_name,sex,mail,adress,cost,rank)

figure 4

customer

cust_name

sex

mail

rank

cust_id

p_word

address

cost

customer

(

pet_no

,

cust_id,

< br>pet_name,pet_type,species,sex,age)

figure 5

pet

pet_name

type

sex

pet

species

age

pet_no

ee(

emp_no

,p_word,emp_name,sex,titl e,salary,address,tel_no,rank)

figure 6

employee

address

emp_name

p_word

sex

salary

tel_no

rank

employee

emp_no

t(

prod_id

,prod_name,price,prod_place, tel_no,amount,information)

figure 7

product

prod_place

price

prdo_name

prod_id

product

tel_no

information

n

qty

e(

service_no

,service_name,unit_price,cont ent)

figure 8

service

unit_price

service_name

service_no

content

service

< br>e_record(

dise_no

,pet_no,d oc_id,dise_name,sick_time,symptoms,curetime,prescr iption)

figure 9

disease_record

dise_no

sicktime

symptoms

dise_name

curetime

prescriptions

doc_id

disease_record

_ form(

order_no

,cust_id,emp_no ,tot_amt,order_date,ship_date,invoice_no,status)

figure 10

order_form

emp_no

cust_id

order_no

ship_time

tot_amt

invoice_no

order_status

order_form

order_time

(

doc_id

,doc_name,title,salary,information)

figure 11

doctor

doc_name

doc_id

title

information

doc

salary