Reference no: EM132129009
You are the Senior Consultant at Abacus Consulting, tasked with the database project for Amadeus Real Estate client.
The company employs real estate agents who work with customers to buy and sell properties (both residential and commercial).
As part of your lead role, you are initially responsible for meeting with the client team and gathering requirements. You are then scheduled to design the data model and implement a working prototype to demonstrate the validity of the data model. Your specific tasks are broken down as below
Phase 1 - Requirements Gathering
As part of the requirements phase, develop a minimum of 10 business rules that apply to the client's business. Each business rule must be related to a data model feature and must be clearly demonstrated in the data model (developed in phase-2).
[Deliverable: Word doc containing business rules]
Phase 2 - Database Design
Develop a database model (ERD) based on the business rules developed in Phase-1. Use the Crow's Foot notation, indicate all attributes, primary/foreign key relationships, cardinalities and relationship strengths.
[Deliverable: ERD]
Phase 3 - Implementation
Implement the table structure based on the ERD developed in phase-2. Assume property details (type, area, list price, sale price ...etc). Assume 3% commission on all transactions.
Write the SQL code to create the needed tables. Ensure all primary keys, foreign keys and constraints are defined.
After implementing the table structures, insert dummy data for 25 transactions, placed between January-1-2016 and June-30-2016.
[Deliverable: Text file containing SQL statements]
Phase 4 - Validation (50 points)
To validate the data model you have developed in phase-3, you are asked to write some queries and verify the results with expected results.
Write the SQL statements that provide the following information:
Number of sales for the period March-1-2016 to March-31-2016
Agent who sold the most number of properties between Feb-1-2016 to June-30-2016.
Agent who sold the most $ value of properties between Jan-1-2016 to Mar-31-2016.
Most expensive property sold between Jan-1-2016 to June-30-2016.
[Deliverable: Text file containing SQL statements]
).
Submission Instructions
All deliverables must be combined and submitted as a single zip file on Blackboard. The SQL file must be in plain text format (filename with .sql extension
Identify the security problems
: What is a( IPSEC, SSL , VPN, DTLS , DMARC, PKI, PEM, SSH, Kerberos, DKIM) ?. Brifley and answer the following brief.
|
How would you handle this security incident
: He tells you that the laptop has at least 20 cases with Social Security numbers of individuals he has been assisting.How would you handle this security incident
|
Statement using three ethical communication issues
: Discuss this statement using three ethical communication issues as examples - The abstract, essay title, paragraph headings and/or sub-headings (if applicable)
|
Explored the Fundamentals of Health Promotion
: In the assessment you have explored the Fundamentals of Health Promotion, Ethics and evidence, Health Promotion Practice
|
Develop a database model based on the business rules
: You are the Senior Consultant at Abacus Consulting, tasked with the database project for Amadeus Real Estate client.
|
Discuss how data mining is being used to solve a problem
: Discuss how data mining is being used to solve a problem (or to explore an opportunity)?
|
How to calculate subnets
: How to calculate subnets, and be sure to include enough detail that the steps would make sense to someone who doesn't already know how to calculate subnets.
|
Which sentence would work better as a thesis statement
: Which sentence would work better as a thesis statement for a three-to-five-page college paper?
|
Do people always value freedom more than justice
: Would you prefer a class in which 10 percent get A's and everyone competes for grades or a class in which everyone gets a ‘Pass' and students help.
|