Assg > Assign 1 > Erd

TCS 2033 Object Oriented Analysis & Design _____________________________________________________________________________

ERD equipment

1,1

court

b o o k

1,M m a d e

member

1,1

1, M 1,1 1,M booking jo in

1,1 m a d e

team

1,1

B o o k

0,1

1,m

member noid - primary key ic Name Sports teamNo – foreign key address tel_no team teamNo – primary key team_name sports

equipment itemNo - primary key type bookNo – foreign key status

booking bookNo - primary key noid – foreign key date sesseion courtNo itemNo cost

court courtNo – primary key sports rate

*assumptions – index card represent by equipment table Member register at Treebank Sports Club to use their facilities. A member may join a team, it’s optional there could be member without team. Bookings can be made by team or member. Each member r team can made one or more booking. But each booking only can made by 1 member or team. A court can be booked for use my members or team. Only one booking can made against a court at each time. That mean if court of booked in one booking record at a given time that particular court cannot booked at that same time. Equipment also can be booked to be used by members and team. Each equipment by one member or team.

Prepared by BALA SINGAM – B00349

TCS 2033 Object Oriented Analysis & Design _____________________________________________________________________________

Context Diagram

New member profile

member

new booking info return equipment

payment

1.0 booking receipt

Treebank Sports Club Management System

equipment report

booking report

management new equipment profile

Prepared by BALA SINGAM – B00349

TCS 2033 Object Oriented Analysis & Design _____________________________________________________________________________

Data Flow Diagram

member

new member profile

1 Create new member record

new record D1 member

new booking details receipt for booking

3

booking info

Generate Receipt

new record

2 Process Booking

D2

booking

update

D3 equipment booking information 5 Return equipment

update

4 Generate report

report management

Prepared by BALA SINGAM – B00349