Changes between Initial Version and Version 1 of Normalization

Timestamp:

01/28/26 22:12:43 (4 weeks ago)

Author:

213257

Comment:

--

Normalization

@@ +1 @@
+= Normalization
+
+== De-normalized database form ==
+
+'''Unified Relation:'''
+{{{
+PROPERTY_MANAGMENT_SYSTEM(
+    admin_id, admin_name, admin_email, admin_password,
+    building_id, building_name, building_address, building_description,
+    architect_id, architect_full_name, architect_contact_info,
+    floor_id, floor_number, floor_layout_image,
+    unit_id, unit_number, unit_room_number, unit_floor_area, unit_status, 
+    unit_price, unit_image, unit_floorplan, unit_vector_image,
+    agent_id, agent_name, agent_email, agent_phone,
+    timeslot_id, timeslot_date, timeslot_time_start, timeslot_time_end, timeslot_status,
+    appointment_id, appointment_status,
+    client_id, client_name, client_email, client_phone
+)
+}}}
+
+Note: some attributes were renamed due to having multiple attributes with the same name, e.g. email...
+
+'''Functional dependencies:'''
+
+
+FD1:  admin_id → admin_name, admin_email, admin_password
+
+FD2:  building_id -> building_name, building_address, building_description, admin_id
+
+FD3:  architect_id -> architect_full_name, architect_contact_info
+
+FD4:  floor_id -> floor_number, floor_layout_image, building_id
+
+FD5:  unit_id -> unit_number, room_number, floor_area, status, price, image, floorplan, vector_image, floor_id
+
+FD6:  agent_id -> agent_name, agent_email, agent_phone
+
+FD7:  timeslot_id -> date, time_start, time_end, status, agent_id
+
+FD8:  client_id -> client_name, client_email, client_phone
+
+FD9:  client_email -> client_id
+
+FD10: appointment_id -> appointment_status, client_id, unit_id, timeslot_id
+