Changes between Version 4 and Version 5 of Normalization

Timestamp:

09/15/25 12:43:52 (3 days ago)

Author:

215010

Comment:

--

Normalization

@@ -97 +97 @@
 Да не се чува amount во Payment, туку да се пресметува.
 
-
+{{{#!sql
 ALTER TABLE Payment DROP COLUMN amount;
-
+}}}
 Да се додава VIEW:
-
+{{{#!sql
 CREATE VIEW reservation_total AS
 SELECT r.reservation_id,
@@ -107 +107 @@
 FROM Reservation r
 JOIN Room rm ON r.room_number = rm.room_number AND r.building_id = rm.building_id;
-
+}}}
 Service – историја на статуси
-
+{{{#!sql
 CREATE TABLE service_history (
     history_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
@@ -117 +117 @@
     FOREIGN KEY (service_id) REFERENCES Service(service_id)
 );
-
+}}}
 ==== BCNF
 Прекршоци
@@ -126 +126 @@
 
 Во Room, комбинацијата (building_id, room_number) е единствен идентификатор.
-
+{{{#!sql
 ALTER TABLE Hotel_User ADD CONSTRAINT uq_phone UNIQUE(phone);
 
 ALTER TABLE Room ADD CONSTRAINT uq_room UNIQUE(building_id, room_number);
+}}}