Essay
Unit 21 Data analysis and design part 1 Whole unit Distinction
- Course
- Institution
- Book
Unit 21 Data analysis and design
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
More summaries for
-
Project Planning - Unit 17 Assignment 1
-
D2 - Evaluate the security policies used in an organisation for Unit 7 - Organisational Systems Security
-
D1 - Discuss the different ways that you can recover from a disaster for Unit 7 - Organisational Systems Security
1 review
By: assadullahzazai0 • 6 year ago
Seller
Follow
michaeldrewdewet
Reviews received
Content preview
TA1010 Michael de Wet Unit 21 Assignment 2Qualification 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller michaeldrewdewet. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $6.44. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
72042 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now