SQL DB2

I am doing a facilities reservation database. Situation as below:
Every member has a membership which is authorized some facilities. Therefore, if a member reserve a facilities which is not authorized to his membership, it need to be charged and store into the reservation record table as an attribute reservation_fees.
How can i do the constraint? or check?

2

Contributors

1

Reply

3 Months

Discussion Span

2 Months Ago

Last Updated

4

Views

kevin7807

Newbie Poster

2 posts since Nov 2012

Reputation Points: 0

Solved Threads: 1

Skill Endorsements: 0

2 Months Ago

0

@kevin7807

How can i do the constraint? or check?

Try to provide a table and explain with the table so it would be easier to visualized the query.

This is the table I came up with base on your words:

Table: facilities
--------------------
Field Name: ID
Data Type: Member

Field Name: Authorized
Data Type: Membership

Field Name: Reservation
Data Type: Date/Time

Field Name: Fees
Data Type: Number

LastMitch

Industrious Poster

4,132 posts since Mar 2012

Reputation Points: 132

Solved Threads: 334

Skill Endorsements: 45