Code and the recommended videos and explores the issues above more than words
Task 1: Database Design and Development (35 Marks)
Scenario
The system should be capable of storing all the information needed for Clinton Letting and Management to carry out their business. Several additional requirements are outlined as in Task 2 below, including data entry and queries.
Please state any assumptions you have made about the scenario.
Document 1. Property Portfolio Records
NOTE: Roger Picard is shown as having two separate portfolios.
Document 2. Tenancies
| Tenant Type | End Date | Monthly Rent | ||||
|---|---|---|---|---|---|---|
|
|
Business | 2018 |
1000.00 | ||
|
Private | 01-MAR- 2018 |
2500.00 | |||
| Private |
|
01-APR- |
2000.00 | |||
|
Government |
|
1500.00 | |||
|
|
Private | 2017 |
1000.00 | ||
|
Private | 01-FEB- 2018 |
5500.00 |
Parts Used
Staff
| Staff ID | Name |
|---|---|
| S78 | Dave Smith |
| S23 | Holly Leman |
2. Design the database for the information above. Implement the DB using any method of your choice (SQL, MongoDB, Cassandra DB or Graph DB). [7 Marks]
Note:
Write a query that selects the tenants and their tenancy dates. [2 marks]
Write a query that shows all parts involved in the repair of a particular property. [2 marks]
In the future Clinton Letting and Management could expand as an organisation.
Describe the factors that might make them consider implementing a distributed
Identify and implement an idea that you have about how you would use Big Data for something intriguing.
Evidence
You can use any programming language (python, java, R etc.) to implement this system. Include a report section that includes the algorithm used, code and the recommended videos and explores the issues above no more than 1200 words. You should carry out research into these areas and reference your work using the CU Harvard Style.