Changes between Version 6 and Version 7 of Normalization

Timestamp:

09/23/25 02:37:42 (2 days ago)

Author:

215010

Comment:

--

Normalization

@@ -5 +5 @@
 === Функционални зависности
 
-Users
-user_id → first_name, last_name, phone, email, password
+- user_id → first_name, last_name, phone, email, password. (FD1)
 
-Customer (extends User)
-user_id → {customer role}
+- customer_id → first_name, last_name, phone, email, password. (FD1a; исто како user_id)
 
-Manager (extends User)
-user_id → {manager role}
+- staff_id → first_name, last_name, phone, email, password. (FD1b)
 
-Staff (extends User)
-user_id → {staff role}
+- manager_id → first_name, last_name, phone, email, password. (FD1c)
 
-Hotel Building
-building_id → address, city, floors, num_rooms
+- building_id → address, city, floors, num_rooms, manager_id. (FD2)
 
-Room (слаб ентитет)
-(building_id, room_number) → room_type, number_of_beds, price_per_night, available
+- (building_id, room_number) → room_type, number_of_beds, price_per_night, available. (FD3)
 
-Reservation
-reservation_id → start_date, end_date, reserv_date, status, user_id (customer), manager_id, room_number, building_id
+- reservation_id → start_date, end_date, reserv_date, status, room_number, building_id, customer_id, manager_id. (FD4)
 
-Payment
-p_id → p_method, amount, p_date, reservation_id
+- p_id → p_method, amount, p_date, reservation_id, customer_id. (FD5)
 
-Service
-service_id → service_type, service_date, service_status, staff_id, room_number, building_id
+- service_id → service_type, service_date, service_status, room_number, building_id, staff_id. (FD6)
+
+- staff_id → staff_building_id. (FD7) (секој ред на персоналот ја чува зградата каде што работи тој персонал)
+
+(За јасност, атрибутите customer_id, manager_id, staff_id се сите user_id само поделени според класификацијата на различните видови на корисници на апликацијата (нивната улога е определена според user_id - бројот)
  
 === Класификација на атрибути