Relational Design

Notation

• Primary keys - underlined and bold
• NOT NULL attributes - bold
• Foreign keys - marked with a * after the foreign key name
• Other attributes - no marking

Tables

• ADMIN (admin_id, name, email, password)

• ARCHITECT (architect_id, full_name)

• BUILDING (building_id, name, address, description, admin_id*)

• DESIGNS (architect_id*, building_id*)

• FLOOR (floor_id, floor_number, layout_image, building_id*, admin_id*)

• UNIT (unit_id, unit_number, room_number, floor_area, status, price, image, floorplan, vector_image, floor_id*, admin_id*)

• AGENT (agent_id, name, email, password)

• CLIENT (client_id, name, email, phone)

• TIMESLOT (timeslot_id, date, time_start, time_end, status, agent_id*)

• INQUIRY (inquiry_id, message, status, created_at, unit_id*, client_id* , agent_id*)

• APPOINTMENT (appointment_id, status, client_id*, unit_id*, timeslot_id*, agent_id*)

DDL script for creating the database schema and objects

​DDL Script

DML script for filling tables with data

​DML Script

Relational Diagram