Airbnb Management System Entity Relationships Diagram B Employees
Airbnb Management System Entity Relationships Diagram B Employees ID (PK) ERD_Ver_02 D Club Members Fix Club Member Code (PK) Reported on Taking care of Malfunction Code(PK) Transportation Can become D Transportation Number (PK) B Customers uses Customer ID (PK) having Attractions uses Complaints D Orders Complaints Number (PK) Make D Legend Tracking Number (PK) About Entity B D PK Relation Apartments Owner B Apartments Owner ID (PK) Apartments own B Apartments Code (PK) for D Attractions Name (PK) Reported on Taking care of DB Entity Basic Entity Dependant Entity Primary Key Relation 1: 1 1: N N: M Self Relationship Mandatory Optional
DSD_Ver_03 Employees_Tbl Apartments B Apartments_code_Fld(PK) Apartments_city_Fld Apartments_state_Fld Apartments_address_Fld Apartments_size_Fld Apartments_content_Fld Apartments_price_Fld Apartments_owner_ID_Fld(FK) Emp_Code_Fld(PK) Emp_F_Name_Fld Emp_L_Name_Fld Emp_Address_Fld Emp_Tel_Fld Emp_Email_Fld Emp_S_work_time_Fld Emp_F_work_time_Fld Complaints_Tbl Complaints_Num_Fld(PK) Complaints_Name_Fld Apartments_code_Fld(FK) Complaints_Status_Fld Emp_Code_Fld(FK) Costumers_ID_Fld(FK) Malfunction_Tbl D Malfunction_Code_FLD(PK) Malfunction_Type_Fld Malfunction_Stauts_Fld Malfunction_Fix_Time_Fld Emp_Code_Fld(FK) Apartments_code_Fld(FK) Customer_ID_Fld(FK) AIRBNB Data Structures Diagram Legend Entity B Orders_Tbl Apart_Order_Tbl A Apartments_code_Fld(FPK) Orders_Tracking _Num(FPK) D Orders_Tracking _Num(PK) Orders_arival_date_Fld Orders_dep_date_Fld Orders_payment_Fld Orders_stauts_Fld Customer_ID_Fld(FK) D PK Relation Entity Basic Entity Dependant Entity Primary Key Relation 1: 1 1: N N: M Self Relationship Mandatory Optional D Apartments_Owner_Tbl B Apar_Own_ID_Fld(PK) Apar_Own_F_Name_Fld Apar_Own_L_Name_Fld Apar_Own_Tel_Num_Fld Club_Members_Tbl Club_Members_Code_Fld (PK) Club_Members_B_Date_Fld Club_Members_Wed_Date_Fld Customer_ID_Fld(FK) D Customers_Tbl Customer_ID_Fld(PK) Customer_F_Name_Fld Customer_L_Name_Fld Customer_Address_Fld Customer_B_Date_Fld Customer_Tel_Num_Fld Customer_Family_stuatus_Fld D Transportation_Tbl D Tran_Number (PK) Tran_Type_Fld Tran_Comp_Fld Tran_Color_Fld Tran_Gearbox_Fld Tran_rant_comp_Fld Customer_ID_Fld(FK) B Attractions_Tbl Attrac_Name_Fld (PK) Attrac_type_Fld Attrac_open_time_Fld Attrac_age_rang_Fld Customer_ID_Fld(FK) D
DSD_Ver_03 Employees_Tbl Apartments B Apartments_code_Fld(PK) Apartments_city_Fld Apartments_state_Fld Apartments_address_Fld Apartments_size_Fld Apartments_content_Fld Apartments_price_Fld Apartments_owner_ID_Fld(FK) Emp_Code_Fld(PK) Emp_F_Name_Fld 1 Emp_L_Name_Fld Emp_Address_Fld Emp_Tel_Fld Emp_Email_Fld Emp_S_work_time_Fld Emp_F_work_time_Fld Complaints_Num_Fld(PK) Complaints_Name_Fld Apartments_code_Fld(FK) Complaints_Status_Fld Emp_Code_Fld(FK) Costumers_ID_Fld(FK) 3 Entity Orders_Tbl Apartments_code_Fld(FPK) Orders_Tracking _Num(FPK) A 3 D Orders_Tracking _Num(PK) Orders_arival_date_Fld 2 Orders_dep_date_Fld Orders_payment_Fld Orders_stauts_Fld Customer_ID_Fld(FK) D PK Relation Entity Basic Entity Dependant Entity Primary Key Relation 1: 1 1: N N: M Self Relationship Mandatory Optional D 3 Apartments_Owner_Tbl B 1 Apar_Own_ID_Fld(PK) Apar_Own_F_Name_Fld Apar_Own_L_Name_Fld Apar_Own_Tel_Num_Fld Customers_Tbl Customer_ID_Fld(PK) Customer_F_Name_Fld Customer_L_Name_Fld Customer_Address_Fld Customer_B_Date_Fld Customer_Tel_Num_Fld Customer_Family_stuatus_Fld Club_Members_Tbl Club_Members_Code_Fld (PK) Club_Members_B_Date_Fld Club_Members_Wed_Date_Fld Customer_ID_Fld(FK) D Malfunction_Code_FLD(PK) Malfunction_Type_Fld Malfunction_Stauts_Fld Malfunction_Fix_Time_Fld Emp_Code_Fld(FK) Apartments_code_Fld(FK) Customer_ID_Fld(FK) Legend B 2 Complaints_Tbl Malfunction_Tbl D AIRBNB Data Structures Diagram D 2 Transportation_Tbl D Tran_Number (PK) Tran_Type_Fld Tran_Comp_Fld Tran_Color_Fld Tran_Gearbox_Fld Tran_rant_comp_Fld Customer_ID_Fld(FK) 2 Attractions_Tbl D B 1 Attrac_Name_Fld (PK) Attrac_type_Fld 2 Attrac_open_time_Fld Attrac_age_rang_Fld Customer_ID_Fld(FK)
- Slides: 3