= 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