1,428
13
Essay, 1 pages (250 words)

The entity life history for booking

Question First normal form (1NF) means that Extra_Form entity must have a primary key. Duplicate field is removed. Second normal form (2NF) means that Bar_Lounge_Restaurant is put to the separate table and relationship between it and Extra_Form is created.
Third normal form (3NF). Following attributes that are not dependent upon the primary key:
Hotel, Bar_Lounge_Restaurant_ID, Date, Charge and Signature1. So they must be moved to separate table and relationship between it and Extra_Form must be created.
Boyce-Codd Normal Form (BCNF) differs from the 3NF only when there are more than one candidate keys and the keys are composite and overlapping. In case of Extra_Form it does not differ. Here is the conceptual schemas at each normal form:

E-R diagram

Question 2
Figure below shows the entity life history for Booking. A Booking’s life begins with a ” Booking creation”, and ends with a ” Booking end”. In between, its ” Booking life” consists of some ” Booking events”.

In between an Booking’s definition and its end, Booking is subject to series of ” Booking events”. The iterative nature of ” Booking events” is shown by the asterisk (*) in the upper right corner of that event’s box. The set of events constitute Booking’s ” Booking life”: ” Booking Form is filled”, ” Room Schedule is filled with booking details “, ” Reservation Diary is filled with booking details” and ” Deposit is taken”.
” Booking end” can occur either by ” Rooms are released ” or by ” Cancellation”. Anyone of them must be only one of the optional kinds listed, this is shown by the (o) in the upper right corner.

Thank's for Your Vote!
The entity life history for booking. Page 1
The entity life history for booking. Page 2
The entity life history for booking. Page 3

This work, titled "The entity life history for booking" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'The entity life history for booking'. 21 September.

Reference

AssignBuster. (2022, September 21). The entity life history for booking. Retrieved from https://assignbuster.com/the-entity-life-history-for-booking/

References

AssignBuster. 2022. "The entity life history for booking." September 21, 2022. https://assignbuster.com/the-entity-life-history-for-booking/.

1. AssignBuster. "The entity life history for booking." September 21, 2022. https://assignbuster.com/the-entity-life-history-for-booking/.


Bibliography


AssignBuster. "The entity life history for booking." September 21, 2022. https://assignbuster.com/the-entity-life-history-for-booking/.

Work Cited

"The entity life history for booking." AssignBuster, 21 Sept. 2022, assignbuster.com/the-entity-life-history-for-booking/.

Get in Touch

Please, let us know if you have any ideas on improving The entity life history for booking, or our service. We will be happy to hear what you think: [email protected]