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?
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:
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