TA1010 Michael de Wet Unit 21 Assignment 2
Qualification BTEC L3 Diploma & Extended Diploma in IT – Software
Development
Unit number and title Unit 21 Data Analysis and Design
Assignment title Assignment 2 (2 of 2) Bradford Properties – Property
Viewing
Assessor Liguang Chen
Issue date 24/02/2017
Hand in deadline 9:00 am 14/3/2017 (must be submitted via Moodle)
Vocational Scenario or Bradford Properties is a small firm of estate agents. The
Context agency operates a number of functions such as Property
Valuation, Property Viewing, Property Sales and Marketing.
At present, the company still use the legacy systems in
keeping all the business data at each section – some data are
still kept on paper-based files and some are on computers
using Spreadsheets. The ‘flat file’ systems had worked to a
lager extent for a long while in the past as they were only
handling a small amount of properties and customers.
However, a number of problems have arisen with a rapid
growing of the business: customers often complaint about
giving same information many times; mess up the
appointment times and locations; Agents also frustrated about
duplicating data and sometimes did not get most updated
information in time; managers find hard to produce any report
quickly and accurately as they have to compile information
from various sources. To overcome the problems, the
company has decided to upgrade their current systems with
computerised database systems. To make the transition
smoothly, the company would like to start with Property
Viewing System as a pilot.
Property Viewing. When a potential buyer makes a request for
viewing, the request will be recorded and a viewing schedule
has to be made with the seller by an agent. The subsequent
viewing result such as the client’s comments or intentions
must be recorded including cancellation or changing the
viewing schedule.
Based on the data model produced for Bradford Property
Task 1 Viewing in your assignment 1, implement the database in MS
Access. Here you need to provide the following:
a) Create MS Access tables using the entities and data
dictionary
b) Build the relationships between tables using Access
relationships tool
c) Enter no less than five records for each table
Checklist of evidence Screen shots of a), b) and c) above.
required
1
Qualification BTEC L3 Diploma & Extended Diploma in IT – Software
Development
Unit number and title Unit 21 Data Analysis and Design
Assignment title Assignment 2 (2 of 2) Bradford Properties – Property
Viewing
Assessor Liguang Chen
Issue date 24/02/2017
Hand in deadline 9:00 am 14/3/2017 (must be submitted via Moodle)
Vocational Scenario or Bradford Properties is a small firm of estate agents. The
Context agency operates a number of functions such as Property
Valuation, Property Viewing, Property Sales and Marketing.
At present, the company still use the legacy systems in
keeping all the business data at each section – some data are
still kept on paper-based files and some are on computers
using Spreadsheets. The ‘flat file’ systems had worked to a
lager extent for a long while in the past as they were only
handling a small amount of properties and customers.
However, a number of problems have arisen with a rapid
growing of the business: customers often complaint about
giving same information many times; mess up the
appointment times and locations; Agents also frustrated about
duplicating data and sometimes did not get most updated
information in time; managers find hard to produce any report
quickly and accurately as they have to compile information
from various sources. To overcome the problems, the
company has decided to upgrade their current systems with
computerised database systems. To make the transition
smoothly, the company would like to start with Property
Viewing System as a pilot.
Property Viewing. When a potential buyer makes a request for
viewing, the request will be recorded and a viewing schedule
has to be made with the seller by an agent. The subsequent
viewing result such as the client’s comments or intentions
must be recorded including cancellation or changing the
viewing schedule.
Based on the data model produced for Bradford Property
Task 1 Viewing in your assignment 1, implement the database in MS
Access. Here you need to provide the following:
a) Create MS Access tables using the entities and data
dictionary
b) Build the relationships between tables using Access
relationships tool
c) Enter no less than five records for each table
Checklist of evidence Screen shots of a), b) and c) above.
required
1
