Home / Expert Answers / Computer Science / can-you-please-build-the-database-and-provide-the-ddl-statement-i-will-include-my-erd-but-feel-fre-pa220

(Solved): Can you please build the database and provide the DDL statement. I will include my ERD but feel fre ...



Can you please build the database and provide the DDL statement. I will include my ERD but feel free to improve it if you feel like it needs to be improved. Thank you. I will upvote aswell. Scenario After building a successful Real Estate Investment business your parents decide it's time to retire and have asked you to take over the family business. You weren’t sure if you were ready to leave your lucrative career as a Database Administrator but after careful deliberation, you’ve agreed to take over. You realize that the business was not functioning at its most optimal level, as several staff members are still using the primitive file and cabinet method to maintain records. After a thorough evaluation, you've decided to apply the knowledge you've acquired as a DBA to improve the day-to-day operations of your family-owned business. In doing so, you recruit a couple of your IT friends to assist with designing a new application. Business Requirements Your new application will support all business operations; this includes maintaining records of buyers, properties acquired, contractors, sales agents, agreements, and employees. Over the years there have been thousands of properties acquired and sold. Staff members have worked with a number of contractors consisting of Interior Designers and General Contractors. Your business also employs five employees (an accountant, a lawyer, a secretary, and two maintenance workers). In addition, over the years your parents have worked with several independent Real Estate Sales Agents. Your database should contain details from previous and potential buyers including account number, name, address, contact info, occupation, salary, and credit score. You also need to maintain Employee details employer code, employer name, employer address, employer phone number, etc... It should also contain data for contractors such as id, name, address, and phone number. In addition, you also need to include the sales agent's id, name, address, and phone number. You also should maintain data for contract agreements between various contractors and your company. These agreements should include an agreement number, contractor id, contractor name, contractor address, contractor phone number, and a description of the agreement. A contractor can enter into several agreements, but each agreement can only be associated with one contractor. Lastly, the database schema should contain all the properties acquired and sold, each property should have a parcel number, address, and specification such as the number of rooms, square feet, purchase date, purchase amount, market value, and architecture style description. The architectural styles include Cope Code, Colonial Contemporary, Ranch and etc... For the architecture style description, you need to store information such as the style and description of each style to provide additional characteristics for each property. The property should also be associated with details for both the buyer and sales agent (id, name, address, phone). You've also noted that a buyer can purchase one or more properties from you and the property can have one or more buyers. The sale of a property can be conducted by one agent, but an agent can sell many properties.



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe