Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Dear experts, Correcting erd based on requirements given (follow format sample as below) Sample erd: Payment 1. The fue date o pamant is sent by

Dear experts,

Correcting erd based on requirements given

(follow format sample as below)image text in transcribed

image text in transcribed

Sample erd:

image text in transcribed

Payment 1. The fue date o pamant is sent by Owners to Tenants. 2. The paid date of monthly rental by Tenants is reflected cnce after pa:ma. 3. Tenant able to bad and save the redit o debit card. + Tenant required to attack md upload the pawet slip to pater, 5. The payment details, such as Payment D.Parmant Type. Method and Amount are recorded in system as evidence 6. History Dpaymat made by tenants will be shown to gns required. Review :. The tenants can vote the services provided by owner during their period of rental Rental lume: The result of vottug affects the ratwg of the yster. Service .. Services for properties room 10:ludes nantanance, al abilits of Sumituras and cleanmg 501ce. Security 1. L'sers is required to create wemame and password or signing in and oui purposes ? 6 dients pots created by users 33 0233word 3. OTP code is generated and user required to fill in for pament purposes Customer Suppon 1. L'sers can reach out wizn ther face technical 135ues. Sotification 1. Sotification on due date of patient will be sent by cwna to tenants. 2. Yonification on change in amount of rent, udilities and deposit sill be sent by 387e to tenmis The owner will receive notification ou pad payment of rental deposit ir tenant to be validated and approved. +. The notification details such as Sander, Receiver. Date. Time, Description are recorded. Complaint 1 The tenants can post complamts Tenants requred to state the rental address in the complaat. 3. Owners can respond to the complaints by the tenants. 4. The complaint details such as D. Adm. :D. Sander. Recava. Date. Tme. Description are recorded Property 1. The property details such as property's Id, property's type, name, Location and description are recorded. ? The property availabuity is updated by outer from time to time 3. The number of properties owned by owner are recorded. 1 The Okiner can manage update information on their property. Registration 1. The user who registers under Tenancy Management System 15 either ouner or tenant : Users are required for personal informationsuch as IC number name. description. phone number and email during registration 1. Verification link wi: be sent to email for activating the account. Available Property regisnation 1. Owners are required to register property details, such as property's Id property's type, name. Location and description. Onner can add modify new existing unit in property registration 3. Onner can add picture. Cosest facilities of property for property details. 1. The properties(lot room) are shorn as reserved a a new tenants paid deposit. 2 The availability date of property is shown to users by ouders. The duration of tent of tenants are recorded. Room registration 1. Onners are required to register room details, such as room's Id, room's type, name, location and description. ? Owner can add modify new existing unit in room registration Agreement I The ID duration of the sental and property detais ac recorded in the agreement .. The amount of renta, utilities and deposit are modified by owner. Tegant Tenant registration (Room) 1 Tenant can register for rental of room room module 2. Owner can add tenant details unit in room registration. 3. Tenant can choose nationa.ity (Malaysian Yon-Maarsian) Payment ID 1. The tenant detai's such as ID. DOB. first name. Last name Address, Phone, Email. Occupation. Gender. Status is dispaved from registration. 2. The details of unit room rented will be dispiaved 3. The tenant details can be modified and updated. Tenant registration (Full unit) 1. Tenant can register for rental of property (full unit). Owner can add Icnant details unit in property registiation 3. Tenant can choose nationality Malaysian Yon- Maaysian) Order 1 The owner detai's such as 1D. DOB. first naine Last name. Address Phone Email. Occupation. Gender. Status is disp'aved from registration. 2. The onder detaiis can be modified and updated. 3 List of properties owned are recorded Agreement Transaction PAYMENT ID PAYMENT_TYPE CREDIT DEBIT CARD NO PAY AMT PAY DATE PAY_DUTEDATE MESSAGE PAYMENT SLIP HISTORY PAYMENT Tenant Registration (LOD LOT ID TENANT_ID PAYMENT ID AGREEMENT_ID ROOM REGISTRATION (LOTI requires registers 1.1 1.1 Tenant Details LOT ID ROOM ID OWNER NAME TENANT NAME PROPERTY ID ROOM LOT ID ROOM TYPE RENTAL TIME PAYMENT AD 1.1 TENANT registers USER ID ADDRESS OCCUPATION GENDER STATUS requires Tenant Registration froom) 1.1 ROOM ID TENANT ID PAYMENT ID AGREEMENT ID ROOM REGISTRATION UNIT) JO Nonfiction 1. sends MESSAGE Property CNG AMT RENT Registration 1.1 PAY DUEDATE registers P_REGLID PAID PAYMENT P_ADDRESS HISTORY_MESSAGE OWNER ID receives AREA_SIZE IMAGE records 1..1 NUMBER_OF_ROOMS UNIT RENTAL PROPERTY NATIONALITY 1..1 User Security SECURITY ID D PASSWORD SIX DIGIT_PIN TENANT MESSAGE AC 1.1 1.1 display- FIRST NAME SECURITY ID LAST NAME COMPLAINT 1.1 PROPERTY ID P_REG_ID AVAILABLE ID ROOM_REG_ID OWNER_ID ADDRESS P OWNED Availability AVAILABLE ID AVAILABLE DATE ROOM_ID PROPERTY ID PAYMENT_ID 1. USERID has USER_10 1... PHONE NUM OWNER EMAIL Customer Support REPORTID USER ID REPORT DES REVIEW ID COMPLAINT ID SERVICE ID COMPLAINT TENANT AD manages OWNER ID PROPERTY ADD 1.1 records ROOM ID VERIFY UNK - DATE registers PAY manages TME PAYMENT ID ROOM REVIEW records Owner Details View 1.. ROOM ID OWNER D ROOM REG ID AVAILABLE ID R_OWNED Room Registration ROOM_REC_ID 10 ROOM ROOM TYPE ROOM_IMAGE PROPERTY ID ROOM_RENTAL AREA SIZE OWNER ID USER ID 1. 1. Service OWNER_NAME SERVICE ID MAINTENANCE AVAILABLE_FURNITURE CLEANING_SERVICE Payment PAYMENT ID HISTORY PAYMENT PAY_DUE_DATE DEPOSIT_FEE UTILITY_FEE DEPOSIT_FEE ADDRESS OCCUPATION GENDER REVIEW.ID TENANT ID OWNER ID PROPERTY ID ROOM ID HISTORY_REVIEW RATING ID SERVICE ID STATUS PROPERTIES AD PAYMENT_ID RATING ID Payment 1. The fue date o pamant is sent by Owners to Tenants. 2. The paid date of monthly rental by Tenants is reflected cnce after pa:ma. 3. Tenant able to bad and save the redit o debit card. + Tenant required to attack md upload the pawet slip to pater, 5. The payment details, such as Payment D.Parmant Type. Method and Amount are recorded in system as evidence 6. History Dpaymat made by tenants will be shown to gns required. Review :. The tenants can vote the services provided by owner during their period of rental Rental lume: The result of vottug affects the ratwg of the yster. Service .. Services for properties room 10:ludes nantanance, al abilits of Sumituras and cleanmg 501ce. Security 1. L'sers is required to create wemame and password or signing in and oui purposes ? 6 dients pots created by users 33 0233word 3. OTP code is generated and user required to fill in for pament purposes Customer Suppon 1. L'sers can reach out wizn ther face technical 135ues. Sotification 1. Sotification on due date of patient will be sent by cwna to tenants. 2. Yonification on change in amount of rent, udilities and deposit sill be sent by 387e to tenmis The owner will receive notification ou pad payment of rental deposit ir tenant to be validated and approved. +. The notification details such as Sander, Receiver. Date. Time, Description are recorded. Complaint 1 The tenants can post complamts Tenants requred to state the rental address in the complaat. 3. Owners can respond to the complaints by the tenants. 4. The complaint details such as D. Adm. :D. Sander. Recava. Date. Tme. Description are recorded Property 1. The property details such as property's Id, property's type, name, Location and description are recorded. ? The property availabuity is updated by outer from time to time 3. The number of properties owned by owner are recorded. 1 The Okiner can manage update information on their property. Registration 1. The user who registers under Tenancy Management System 15 either ouner or tenant : Users are required for personal informationsuch as IC number name. description. phone number and email during registration 1. Verification link wi: be sent to email for activating the account. Available Property regisnation 1. Owners are required to register property details, such as property's Id property's type, name. Location and description. Onner can add modify new existing unit in property registration 3. Onner can add picture. Cosest facilities of property for property details. 1. The properties(lot room) are shorn as reserved a a new tenants paid deposit. 2 The availability date of property is shown to users by ouders. The duration of tent of tenants are recorded. Room registration 1. Onners are required to register room details, such as room's Id, room's type, name, location and description. ? Owner can add modify new existing unit in room registration Agreement I The ID duration of the sental and property detais ac recorded in the agreement .. The amount of renta, utilities and deposit are modified by owner. Tegant Tenant registration (Room) 1 Tenant can register for rental of room room module 2. Owner can add tenant details unit in room registration. 3. Tenant can choose nationa.ity (Malaysian Yon-Maarsian) Payment ID 1. The tenant detai's such as ID. DOB. first name. Last name Address, Phone, Email. Occupation. Gender. Status is dispaved from registration. 2. The details of unit room rented will be dispiaved 3. The tenant details can be modified and updated. Tenant registration (Full unit) 1. Tenant can register for rental of property (full unit). Owner can add Icnant details unit in property registiation 3. Tenant can choose nationality Malaysian Yon- Maaysian) Order 1 The owner detai's such as 1D. DOB. first naine Last name. Address Phone Email. Occupation. Gender. Status is disp'aved from registration. 2. The onder detaiis can be modified and updated. 3 List of properties owned are recorded Agreement Transaction PAYMENT ID PAYMENT_TYPE CREDIT DEBIT CARD NO PAY AMT PAY DATE PAY_DUTEDATE MESSAGE PAYMENT SLIP HISTORY PAYMENT Tenant Registration (LOD LOT ID TENANT_ID PAYMENT ID AGREEMENT_ID ROOM REGISTRATION (LOTI requires registers 1.1 1.1 Tenant Details LOT ID ROOM ID OWNER NAME TENANT NAME PROPERTY ID ROOM LOT ID ROOM TYPE RENTAL TIME PAYMENT AD 1.1 TENANT registers USER ID ADDRESS OCCUPATION GENDER STATUS requires Tenant Registration froom) 1.1 ROOM ID TENANT ID PAYMENT ID AGREEMENT ID ROOM REGISTRATION UNIT) JO Nonfiction 1. sends MESSAGE Property CNG AMT RENT Registration 1.1 PAY DUEDATE registers P_REGLID PAID PAYMENT P_ADDRESS HISTORY_MESSAGE OWNER ID receives AREA_SIZE IMAGE records 1..1 NUMBER_OF_ROOMS UNIT RENTAL PROPERTY NATIONALITY 1..1 User Security SECURITY ID D PASSWORD SIX DIGIT_PIN TENANT MESSAGE AC 1.1 1.1 display- FIRST NAME SECURITY ID LAST NAME COMPLAINT 1.1 PROPERTY ID P_REG_ID AVAILABLE ID ROOM_REG_ID OWNER_ID ADDRESS P OWNED Availability AVAILABLE ID AVAILABLE DATE ROOM_ID PROPERTY ID PAYMENT_ID 1. USERID has USER_10 1... PHONE NUM OWNER EMAIL Customer Support REPORTID USER ID REPORT DES REVIEW ID COMPLAINT ID SERVICE ID COMPLAINT TENANT AD manages OWNER ID PROPERTY ADD 1.1 records ROOM ID VERIFY UNK - DATE registers PAY manages TME PAYMENT ID ROOM REVIEW records Owner Details View 1.. ROOM ID OWNER D ROOM REG ID AVAILABLE ID R_OWNED Room Registration ROOM_REC_ID 10 ROOM ROOM TYPE ROOM_IMAGE PROPERTY ID ROOM_RENTAL AREA SIZE OWNER ID USER ID 1. 1. Service OWNER_NAME SERVICE ID MAINTENANCE AVAILABLE_FURNITURE CLEANING_SERVICE Payment PAYMENT ID HISTORY PAYMENT PAY_DUE_DATE DEPOSIT_FEE UTILITY_FEE DEPOSIT_FEE ADDRESS OCCUPATION GENDER REVIEW.ID TENANT ID OWNER ID PROPERTY ID ROOM ID HISTORY_REVIEW RATING ID SERVICE ID STATUS PROPERTIES AD PAYMENT_ID RATING ID

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems Uropean Conference Adbis 2020 Lyon France August 25 27 2020 Proceedings Lncs 12245

Authors: Jerome Darmont ,Boris Novikov ,Robert Wrembel

1st Edition

3030548317, 978-3030548315

More Books

Students also viewed these Databases questions

Question

My opinions/suggestions are valued.

Answered: 1 week ago