Changes between Version 3 and Version 4 of Logical and Physical Design - Database creation (with SQL Scripts)
- Timestamp:
- 11/19/22 23:59:16 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Logical and Physical Design - Database creation (with SQL Scripts)
v3 v4 9 9 * '''Останати атрибути''': без ознака 10 10 11 1. Reservation('''__reservation_id__''', '''start_date''', '''end_date''', '''number_guests''', '''adults''', children, '''villa_id*''', '''payment_id*''', '''room_id*''')11 1. ''Reservation'' ('''__reservation_id__''', '''start_date''', '''end_date''', '''number_guests''', '''adults''', children, '''villa_id*''', '''payment_id*''', '''room_id*''') 12 12 * '''*'''Референцира villa_id кон Villa 13 13 * '''*'''Референцира payment_id кон Payment 14 14 * '''*'''Референцира room_id од Room 15 2. Events('''__event_id__''', '''event_type''', '''price''', '''number_of_interested_guests''')16 3. Activities('''__activity_id__''', '''activity_type''', '''price''', '''number_of_interested_guests''', '''location''')17 4. Rooms('''__room_id__''', room_type, price,availability, villa_id*)15 2. ''Events'' ('''__event_id__''', '''event_type''', '''price''', '''number_of_interested_guests''') 16 3. ''Activities'' ('''__activity_id__''', '''activity_type''', '''price''', '''number_of_interested_guests''', '''location''') 17 4. ''Rooms'' ('''__room_id__''', room_type, price,availability, villa_id*) 18 18 * '''*'''Референцира villa_id од Villa 19 5. Service('''__service_id__''', '''service_type''', '''price''', '''user_id*''', '''room_id*''')19 5. ''Service'' ('''__service_id__''', '''service_type''', '''price''', '''user_id*''', '''room_id*''') 20 20 * '''*'''Референцира user_id од Server 21 21 * '''*'''Референцира room_id од Rooms 22 6. Payment('''__payment_id__''', '''total_payment''', '''pay_date''', '''rec_id''', '''customer_id''', '''user_id*''')22 6. ''Payment'' ('''__payment_id__''', '''total_payment''', '''pay_date''', '''rec_id''', '''customer_id''', '''user_id*''') 23 23 * '''*'''Референцира user_id од Guests 24 7. Villa('''__villa_id__''', '''location''', '''name''', villa_view_type)25 8. Beverage('''__beverage_id__''', '''beverage_type''', '''price''')26 9. Product('''__product_id__''', '''number_of_products''', '''product_type''')27 10. Meal('''__meal_id__''', '''price''', '''meal_type''')28 11. Log in('''__login_id__''', '''password''', '''username''', '''user_id*''')24 7. ''Villa'' ('''__villa_id__''', '''location''', '''name''', villa_view_type) 25 8. ''Beverage'' ('''__beverage_id__''', '''beverage_type''', '''price''') 26 9. ''Product'' ('''__product_id__''', '''number_of_products''', '''product_type''') 27 10. ''Meal'' ('''__meal_id__''', '''price''', '''meal_type''') 28 11. ''Log in'' ('''__login_id__''', '''password''', '''username''', '''user_id*''') 29 29 * '''*'''Референцира user_id од User 30 12. User('''__user_id__''', '''EMBG''', '''address''', '''email''', '''phone_number''')31 13. Server('''__user_id*__''', '''shift''', '''salary''')30 12. ''User'' ('''__user_id__''', '''EMBG''', '''address''', '''email''', '''phone_number''') 31 13. ''Server'' ('''__user_id*__''', '''shift''', '''salary''') 32 32 * '''*'''Референцира user_id од User 33 14. Receptionist('''__user_id*__''', '''shift''', '''salary''')33 14. ''Receptionist'' ('''__user_id*__''', '''shift''', '''salary''') 34 34 * '''*'''Референцира user_id од User 35 15. Chef('''__user_id*__''', '''shift''', '''salary''')35 15. ''Chef'' ('''__user_id*__''', '''shift''', '''salary''') 36 36 * '''*'''Референцира user_id од User 37 16. Guests('''__user_id*__''', '''passport_number''')37 16. ''Guests'' ('''__user_id*__''', '''passport_number''') 38 38 * '''*'''Референцира user_id од User 39 17. Prepared_Meal('''__prepared_meal_id__''', '''meal_id*''', '''user_id*''')39 17. ''Prepared_Meal'' ('''__prepared_meal_id__''', '''meal_id*''', '''user_id*''') 40 40 * '''*'''Референцира meal_id од Meal 41 41 * '''*'''Референцира user_id од Chef 42 18. On_Site('''__payment_id*__''', '''currency''', '''payment_type''', '''user_id*''')42 18. ''On_Site'' ('''__payment_id*__''', '''currency''', '''payment_type''', '''user_id*''') 43 43 * '''*'''Референцира user_id од Receptionist 44 44 * '''*'''Референцира payment_id од Payment 45 19. Online('''__payment_id*__''', '''card_number''')45 19. ''Online'' ('''__payment_id*__''', '''card_number''') 46 46 47 20. reservation_for_events('''__reservation_id*, event_id*__''')47 20. ''reservation_for_events'' ('''__reservation_id*, event_id*__''') 48 48 * '''*'''Референцира reservation_id од Reservation 49 49 * '''*'''Референцира event_id од Event 50 21. reservation_for_activity('''__reservation_id*, activity*__''')50 21. ''reservation_for_activity'' ('''__reservation_id*, activity*__''') 51 51 * '''*'''Референцира reservation_id од Reservation 52 52 * '''*'''Референцира activity_id од Activities 53 22. reservation_for_prepared_meal('''__reservation_id*, (prepared_meal_id*, meal_id*)__''', '''quantity''')53 22. ''reservation_for_prepared_meal'' ('''__reservation_id*, (prepared_meal_id*, meal_id*)__''', '''quantity''') 54 54 * '''*'''Референцира reservation_id од Reservation 55 55 * '''*'''Референцира meal_id и prepared_meal_id од Prepared_Meal 56 23. service_for_beverages('''__service_id*, beverage_id*__''', '''quantity''')56 23. ''service_for_beverages'' ('''__service_id*, beverage_id*__''', '''quantity''') 57 57 * '''*'''Референцира service_id од Service 58 58 * '''*'''Референцира beverage_id од Beverage 59 24. meal_madeof_product('''__meal_id*,product_id*__''')59 24. ''meal_madeof_product'' ('''__meal_id*,product_id*__''') 60 60 * '''*'''Референцира meal_id од Meal 61 61 * '''*'''Референцира product_id од Product 62 25. guests_make_reservation('''__user_id*,reservation_id*__''')62 25. ''guests_make_reservation'' ('''__user_id*,reservation_id*__''') 63 63 * '''*'''Референцира user_id од Guests 64 64 * '''*'''Референцира reservation_id од Reservation
