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