Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I NEED ERD IN THIS QUESTION AND CONCEPTUAL DESIGN AND BUSINESS RULES ARE AS FOLLOWS. I NEED ERD ON LUCIDCHART OR ON VISIO PLEASE. YOU

I NEED ERD IN THIS QUESTION AND CONCEPTUAL DESIGN AND BUSINESS RULES ARE AS FOLLOWS. I NEED ERD ON LUCIDCHART OR ON VISIO PLEASE. YOU CAN EMAIL ME THE ANSWER TOO.

Conceptual design of a database for a real world application and corresponding entity relationship diagram (ERD): Recently you have joined a software development team of a real estate company Burwood real estate as a database designer. Your first assignment in this role is to design a database for a specific business process of the company-related to the home maintenance services. You and your team have completed an initial study through a comprehensive reading of the company documents/reports, physical observations of the business process and interviews with the staff members. Then you have prepared a report based on your initial study. Your initial study report includes company situation, organizational structure, the operating environment (operational descriptions of the required business process- maintenance services), description of the current problem of the business process and the objective of the new software system (application) for the maintenance services. You also prepared a description of data analysis and requirements. Your report and descriptions are presented in the following: 1) Initial Study (company situation and background): a) Analysis of the company situation and brief organizational structure of Burwood real estate: Burwood real estate is a renowned real estate company in the eastern suburb of Melbourne which has a highly competitive property market. Recently company achieves a huge growth with a large number of properties to manage. The company has different types of real estate services including property sales, property management, auctions and property development. Burwood real estate also provides home maintenance services for the properties it manages. A senior executive manager leads a service of the company. A number of property managers work under a senior executive manager. However, maintenance service (business process) of the company is not automated; instead, a manual business process is used which is very time-consuming. b) The operational descriptions of the business process- maintenance services A property owner has at least one property for leasing with Burwood real estate. The company may have more than one property to manage from a single property owner. Each property is managed by a property manager. A property manager may manage more than one property. Some managers may have other official duties such as conducting auctions and sales. Therefore, they are not assigned to manage a property. Burwood real estate has a large number of contractors for maintenance services. A property manager has a primary/preferable contractor. A contractor can be preferable to more than one property manager because of his reputation. Company wants to keep the record of preference relationships. However, a contractor cannot have more than five preference relationships with the managers.

i) Maintenance Job creation and Quotation invitation sub-process: A property generally requires more than one maintenance job per year. In the current system, a job is described by the related property and a short note which describes the tasks and requirements of the job. For every job, quotations are invited from the contractors. Quotation invitation date for a job is also recorded. Every job is assigned to a manger. A manager can be assigned to more than one job. ii) Sub-process for approval of a quotation: The quotations for a particular job are reviewed and approved by a property manager. A quotation has a list of required products and number of hours to complete a job. The products in the quotations are building and home maintenance materials/supplies. Manager verifies the brand of each product, per unit price of each product, quantity for each product (in terms of units) and completion hours for the job as listed in the quotation. After verification, the manger approves only one quotation per job and marks its status as accepted and other quotations for the job are marked as rejected. Manger also writes a comment of the reason for approval/rejection on the quotation. c) Descriptions of the Problems: Managing all maintenance contractors and properties and ensuring the quality of maintenance works are getting very difficult day-by-day for Burrowed real estate. A company staff needs to spend significant amount of time to generate reports for scheduling of the maintenance jobs. It does not have any quick method to reply queries from its property owners and contractors, e.g. whether a quotation has been approved or not, or which contractor has won the quotation. There is too much data duplication and inconsistency due to human error in the existing manual system, which is wasteful and time consuming for staff members. The maintenance services leader takes long time to find how many maintenance jobs need to be completed at a particular time. When the company CEO wants to review the approval process it takes hours to find and review a quotation submitted by a contractor. The tax-time is the worst season for the company when it wants to prepare the financial statements for its property owners such as yearly maintenance expenses. Therefore, the staff-cost burden is increasing. The company wants to reduce staff cost, provide faster maintenance services for its clients and generate more revenue. d) Objective of the proposed software system for maintenance services: The main objective of the project is to develop a database and an application program that will automate its home maintenance business process. Several sub-objectives are identified by you and your team members for the database design and implementation phase of the project which are listed in the following. (1) To facilitate a faster report generation on a regular basis for the maintenance business process, (2) to provide appropriate responses to the queries from its stakeholders as quickly as possible, (3) to avoid redundancy and inconsistency in the data, and (4) to facilitate an efficient administrative review of the business process.

At present, the scope of the project is only limited to the home maintenance services. It is informed to the team that some other processes are not fully automated. Therefore, the new software system for home maintenance services will work independently and its interactions with other processes remains unchanged at this stage as mentioned in the operational description. 2) Data analysis and other operational requirements: Data of all jobs and quotations should be captured by the system. Every quotation is uniquely identified such that its related job and contractor can be recognised. Same product may appear in different quotations with the same or a varying quantity as the submitted contractor thinks. Company wants to preserve the information of submitted quotations regardless of its approval status including date submitted, date approved/rejected, product details and quantity of each product and other information as mentioned in the above description. For contractors: their names, addresses, qualifications, mobile phone numbers and e-mail addresses are captured from the initial appointment forms. Property owners name, residential address, phone number, e-mail address are captured from the leasing agreement forms. For the leasing property: corresponding property owner, related property manager, address of the property, type of the property (house, unit, flat, commercial), and age of the property are recorded. Burwood real estate needs to keep a record of its property managers, which should preserve the name of staff, joining date, residential address, qualification and phone number. These data are captured from the employees contracts. Data sources Data for maintenance process Sources of Data Users Interface/ external processes at the boundaries Maintenance job Maintenance forms CEO, staff members, home owner Manual process (e.g. e-mail, phone order ) in Burwood real estate) Quotations and products Quotations documents CEO, staff members, home owner, contractors Manual process (e.g. e-mail, phone order) in Burwood real estate Employee Employee contracts forms CEO, staff members, Human resources, Manual process Home owner and property Leasing agreements forms CEO, staff members, Home owner Property management , Manual process Contractors Appointment letter/ forms CEO, staff members, Home owner Human resources , Manual process

Prepare an entity relationship diagram (ERD) for the conceptual design of the required database of Burwood real estate based on the description above. Your ERD should include all of the following: 1) All required entities and attributes. 2) All relationships among the entities and their strength including strong and weak relationships. 3) All entity and referential integrity rules for each entity. 4) All connectivities for each relationship. 5) All maximum and minimum cardinalities for each relationship. 6) Use professional database design and modeling software (e.g., MS Office Visio, LucidChart) to draw the ER diagram. Crows Foot notation is pref

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Assessment Task 112_20 (1)pdf - Adobe Reader File Edit View Document Tools Window Help 4 75%. Find A You and your team have completed an initial study through a comprehensivereating of the company documents/reports, physical observations of the business process and interviews with the staff members. Then you have prepared a report based on your initial study. Your initial study report includes company situation, organizational structure, the operating environment operational descriptions of the required business process "maintenance services"), description of the current problem of the business process and the objective of the new software system (application) for the maintenance services. You also prepared a deaription of data analysis and requirements Your report and descriptions are presented in the following 1) Initial Study company situation and background): a) Analysis of the company situation and brief organizational structure of Burwood real estate: "Burwood real estate" is a renowned real estate company in the eastern suburb of Medoume which has a highly competitive property market. Recently company achieves a huge growth with a large number of properties to manage the company has different types of real estate services including property sales property management, auctions and property development. Burwood real estate also provides home maintenance services for the properties it manages. A senior executive manager leads a service of the company. A number of property managers work under a senior executive manager. However, maintenance service (business process) of the company is not automated, instead, a manual business process is used witich is very time-consuming b) The operational descriptions of the business process "maintenance services A property owner hasat least one property for leasing with Burwood real estate. The company may have more than one property to manage from a single property owner. Each propatyis managed by a property manager. A property manager may manage more than one property. Some managers may have other offical duties such as conducting auctions and sales. Therefore, they are not assigned to manage a property Burwood real estate has a large number of contractors for maintenance services A properly stage has a primary'preferable contractor. A contrador can be preferable to more than one property manager because of his reputation Company wants to keep the record of preference relationships. However, a contractor cannot have more than five preference relationships with the managers. Type here to search OBE 12:41 PM 8/26/2020 Assessment Task 112_20 (1)pdf - Adobe Reader File Edit View Document Tools Window Help 5 / 7 57.1% . Find A Miranthaatin aduttintnprecess: puputy prutally require more... Once job pa yuch a curse cytes, job described by the related property and sharince which describes the tasks and requirements of theje Foc very job. We widtrom the contractors. Quotation toile de for Job is descondid. Evey job tomme. Ave.ge cubertow.stre.com ob preces for approvalyutada The quotations for a particular jour De Ved and grow by poupety Aquation has a bit of equired protected rather of hears to complete a job. The products in the batt are building and home materiales MAP WS the brand of each prodart, pe mi pece dach product, quucky lo schprobet (e. ledna) ed completion box for the jobes listed to the brother pros only on Quotes per job dists AS ccepted and good for the pob ce merected Marko DES comment of the reason for approvaltujection on the grootstim. c) Berceptions of the Problem Mangalla Contactos e progettandenet the quality of matteance meke we gelirg vay ricoh day by day for Burroweds. A company tulads to picture to wale pot fordeling the mixture jobs. I do not hoe ey quick med to reply queries from its property omased cook, Whether quotation has been provedor not, wach court has wm the quotation. The stomach da split tim and consistency be to femer in the existe mal gestem, which is cil ini consumi.gle itl nambiar. Tea eterate withdr takir lostage in to Thed how we jobsted to be completedet putkethe. Who CEO was to see that provel grocess I turshoes to the drev qustuti sututed by CONTACT The taste the wont sacon for the company was to the fut limfa peopsity was a grey must us. Thed , alul-coil budan Show. The company was to Boxed Coit, pouch meine sevice for its besondere IV d) Objective of the prepared ftuare system for menneservice Ta main objectiu pot to develop databes und mitic propen twin met shot motele brostess poucess. Several abode these decid by you your members to the destace design and implementation phase of the pooject which are listed in the follo (1) Do filiale sfute reportation a regular bwi for the mentirano baina proce , (2) to provide proprie pe to the gears trots stuches quickly w postk (3) to wash Techd-wry and Traesertyai the duta , (4) to facilitati www of the process Type here to search O 12:42 PM 8/26/2020 A CODE Assessment Task 112_20 (1)pdf - Adobe Reader File Edit View Document Tools Window Help 6 / 7 57.1% Find ALORS, Ox scape the project only med to him w SEVKUS. It comed to the team to sme other pocentes e not fully muted. Therefore, the Worce system for home matce Services will work dependently and the thes with other processes Tincheged the pen the operational description 1) Ducalysis and the pedonal equire gia: Dua ofa jebe und quotation could be cured by the systemy quotations miquely Sesli soch kedjob coca Cuba Ecohid. Sex pobus muy uraeq htsmarvayirginity ethaalatial courts.Curry wuts to preserve the reformation or the qurtutibus regards of trova subas alates det gutted, dute Crowdrejected, product details ad quuchy each product de andormation in the store description Foc cances the world.ph e ogtured from the toon fum. Premyer's residenciales.phoneber, milites ce cared to the Desy DCRC For the last papety.com god pupstyled property manager, adress of the propy.type poupety w,a,a,cummul, of the peoperty Decoded. Brood real estate to keep record of as pergety mes, which should be the ne of staff, Jong dute, resident dress, qui ad pbat mer. These Gitare castired from the employees' contracts Data se Du for Sources of DUNE TANA ce process the POLE bords Metect HA CEO,ster Murces Le Job muil.phonear her we realestate ) Care and stations Iden . CEOstadt Marcesc proro members mail,phane) het, herwoodreal estate centractors Employee |y CEO, Malcent HE Le Property and property ALE . members, Walecen Home Contor Appaat CEO,stier HO. Mocess HE 1 Type here to search O 12:42 PM B/26/2020 Assessment Task 1_12_20 (1) pdf - Adobe Reader File Edit View Document Tools Window Help 7 57.1%. The tasks to be completed for the second part of this assignment (Task 1): Complete the rest of the design for the required data of Mind HIV as specified in the following to be on the shower pot requires A Madily the business rules ont dow descriptions For Salon of the rules You need to focus on (de pecha desapons of the bess process nance Svit (actices la and 1) and data absic and other parties Deus (etin2) described in the daily spot. [3 max) B. Deputety Telup digrun (BD) for Un conceptul durian of x required dute of Broodreal estate based on the descopetowe [110 ks] C. Provide a desertion for the ends used tayo DD and why you have considered those is should relate to your businesse ubes[10 markt Your Doctor D) All required extities and attributes 2) All relating the set and the such schodity and weak Islap 3) Alletidlingbyrefouch att All conectatsfor each relationship All widm cresche 6) Use professional database design and modeling sodtware (MS Office Viso Lucit) to the Erdinge woonwin i pedala Type here to search o E 12:43 PM B/26/2020 Attribute city Registration state Address zip employee ID employee_name manage office number can Sales office employee assigns Contact_no Form_no CEO Maintainance Forms Maintainance Proprerty_type listed Duration Rented Propery have Human Resource Dept_id have property Has owners property id zip ID owner id owner_name adderss percent owned Contractors state city Assessment Task 112_20 (1)pdf - Adobe Reader File Edit View Document Tools Window Help 4 75%. Find A You and your team have completed an initial study through a comprehensivereating of the company documents/reports, physical observations of the business process and interviews with the staff members. Then you have prepared a report based on your initial study. Your initial study report includes company situation, organizational structure, the operating environment operational descriptions of the required business process "maintenance services"), description of the current problem of the business process and the objective of the new software system (application) for the maintenance services. You also prepared a deaription of data analysis and requirements Your report and descriptions are presented in the following 1) Initial Study company situation and background): a) Analysis of the company situation and brief organizational structure of Burwood real estate: "Burwood real estate" is a renowned real estate company in the eastern suburb of Medoume which has a highly competitive property market. Recently company achieves a huge growth with a large number of properties to manage the company has different types of real estate services including property sales property management, auctions and property development. Burwood real estate also provides home maintenance services for the properties it manages. A senior executive manager leads a service of the company. A number of property managers work under a senior executive manager. However, maintenance service (business process) of the company is not automated, instead, a manual business process is used witich is very time-consuming b) The operational descriptions of the business process "maintenance services A property owner hasat least one property for leasing with Burwood real estate. The company may have more than one property to manage from a single property owner. Each propatyis managed by a property manager. A property manager may manage more than one property. Some managers may have other offical duties such as conducting auctions and sales. Therefore, they are not assigned to manage a property Burwood real estate has a large number of contractors for maintenance services A properly stage has a primary'preferable contractor. A contrador can be preferable to more than one property manager because of his reputation Company wants to keep the record of preference relationships. However, a contractor cannot have more than five preference relationships with the managers. Type here to search OBE 12:41 PM 8/26/2020 Assessment Task 112_20 (1)pdf - Adobe Reader File Edit View Document Tools Window Help 5 / 7 57.1% . Find A Miranthaatin aduttintnprecess: puputy prutally require more... Once job pa yuch a curse cytes, job described by the related property and sharince which describes the tasks and requirements of theje Foc very job. We widtrom the contractors. Quotation toile de for Job is descondid. Evey job tomme. Ave.ge cubertow.stre.com ob preces for approvalyutada The quotations for a particular jour De Ved and grow by poupety Aquation has a bit of equired protected rather of hears to complete a job. The products in the batt are building and home materiales MAP WS the brand of each prodart, pe mi pece dach product, quucky lo schprobet (e. ledna) ed completion box for the jobes listed to the brother pros only on Quotes per job dists AS ccepted and good for the pob ce merected Marko DES comment of the reason for approvaltujection on the grootstim. c) Berceptions of the Problem Mangalla Contactos e progettandenet the quality of matteance meke we gelirg vay ricoh day by day for Burroweds. A company tulads to picture to wale pot fordeling the mixture jobs. I do not hoe ey quick med to reply queries from its property omased cook, Whether quotation has been provedor not, wach court has wm the quotation. The stomach da split tim and consistency be to femer in the existe mal gestem, which is cil ini consumi.gle itl nambiar. Tea eterate withdr takir lostage in to Thed how we jobsted to be completedet putkethe. Who CEO was to see that provel grocess I turshoes to the drev qustuti sututed by CONTACT The taste the wont sacon for the company was to the fut limfa peopsity was a grey must us. Thed , alul-coil budan Show. The company was to Boxed Coit, pouch meine sevice for its besondere IV d) Objective of the prepared ftuare system for menneservice Ta main objectiu pot to develop databes und mitic propen twin met shot motele brostess poucess. Several abode these decid by you your members to the destace design and implementation phase of the pooject which are listed in the follo (1) Do filiale sfute reportation a regular bwi for the mentirano baina proce , (2) to provide proprie pe to the gears trots stuches quickly w postk (3) to wash Techd-wry and Traesertyai the duta , (4) to facilitati www of the process Type here to search O 12:42 PM 8/26/2020 A CODE Assessment Task 112_20 (1)pdf - Adobe Reader File Edit View Document Tools Window Help 6 / 7 57.1% Find ALORS, Ox scape the project only med to him w SEVKUS. It comed to the team to sme other pocentes e not fully muted. Therefore, the Worce system for home matce Services will work dependently and the thes with other processes Tincheged the pen the operational description 1) Ducalysis and the pedonal equire gia: Dua ofa jebe und quotation could be cured by the systemy quotations miquely Sesli soch kedjob coca Cuba Ecohid. Sex pobus muy uraeq htsmarvayirginity ethaalatial courts.Curry wuts to preserve the reformation or the qurtutibus regards of trova subas alates det gutted, dute Crowdrejected, product details ad quuchy each product de andormation in the store description Foc cances the world.ph e ogtured from the toon fum. Premyer's residenciales.phoneber, milites ce cared to the Desy DCRC For the last papety.com god pupstyled property manager, adress of the propy.type poupety w,a,a,cummul, of the peoperty Decoded. Brood real estate to keep record of as pergety mes, which should be the ne of staff, Jong dute, resident dress, qui ad pbat mer. These Gitare castired from the employees' contracts Data se Du for Sources of DUNE TANA ce process the POLE bords Metect HA CEO,ster Murces Le Job muil.phonear her we realestate ) Care and stations Iden . CEOstadt Marcesc proro members mail,phane) het, herwoodreal estate centractors Employee |y CEO, Malcent HE Le Property and property ALE . members, Walecen Home Contor Appaat CEO,stier HO. Mocess HE 1 Type here to search O 12:42 PM B/26/2020 Assessment Task 1_12_20 (1) pdf - Adobe Reader File Edit View Document Tools Window Help 7 57.1%. The tasks to be completed for the second part of this assignment (Task 1): Complete the rest of the design for the required data of Mind HIV as specified in the following to be on the shower pot requires A Madily the business rules ont dow descriptions For Salon of the rules You need to focus on (de pecha desapons of the bess process nance Svit (actices la and 1) and data absic and other parties Deus (etin2) described in the daily spot. [3 max) B. Deputety Telup digrun (BD) for Un conceptul durian of x required dute of Broodreal estate based on the descopetowe [110 ks] C. Provide a desertion for the ends used tayo DD and why you have considered those is should relate to your businesse ubes[10 markt Your Doctor D) All required extities and attributes 2) All relating the set and the such schodity and weak Islap 3) Alletidlingbyrefouch att All conectatsfor each relationship All widm cresche 6) Use professional database design and modeling sodtware (MS Office Viso Lucit) to the Erdinge woonwin i pedala Type here to search o E 12:43 PM B/26/2020 Attribute city Registration state Address zip employee ID employee_name manage office number can Sales office employee assigns Contact_no Form_no CEO Maintainance Forms Maintainance Proprerty_type listed Duration Rented Propery have Human Resource Dept_id have property Has owners property id zip ID owner id owner_name adderss percent owned Contractors state city

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

Auditing Integrated Concepts And Procedures

Authors: Donald H. Taylor, G. William Glezen

5th Edition

0471524239, 978-0471524236

More Books

Students also viewed these Accounting questions