Reflecting on the Database Solution

To achieve D1, one must demonstrate a critical and reflective approach to evaluating own work and justifying improvements and characteristics of success towards the database solution developed for the given company. This requires realistic proposals for improvements and special reference to tasks 2 & 3. Additionally, learners must take responsibility for managing and organizing activities, planning, managing, and implementing a database system for the case study, as outlined in D2. Finally, to achieve D3, learners must demonstrate convergent, lateral, and creative thinking by presenting new ideas or suggestions as improvements for the new database systems.

6.0 Assignment Brief Section
ASSIGNMENT
Unit Number and title Unit 17 :Database Design Concepts
Qualification BTEC HND Computing and Systems Development (Level
4)
Term Start Date 06/06/2016
Assignment hand out date 06/06/2016
Deadline/ Hand-in 05/08/2016
Assignment title Database Design Concepts- Tom & Jerry LTD database
solution
Purpose of this assignment:
To give learners opportunities to develop an understanding of the concepts and issues relating
to databases and database design as well as the practical skills to translate that understanding
into the design and creation of complex databases.
TASK 1 to TASK 3: You are required to follow the instructions as specified towards each task
and support with research by using supportive materials like books, websites, etc., and give
feedback on the findings by relating your arguments to the relevant case study as specified
towards each task. Your report should fully follow the Harvard Referencing model.
LO1 : Task – 1:
The objective for this task is to address and exhibit understand databases and data
management systems.You are required to carry out a research by using supportive materials
like books, websites, etc., and give a feedback of the findings on P1.1 The answers need to be
reflected to the general Database Management Systems Concepts. Answers without
application to an organization or without examples will be marked as Resubmission.
(LO1 A.C 1.1 and A.C 1.2)
Required
1.1- Aanalyze the key issues and application of databases within organizational
1

environments
1.2- Critically evaluates the features and advantages of database management systems.
TASK 2:
LO2- Task 2 Understand database design techniques
The objective for this task is to address and exhibit understand database design
techniques.You are required to carry out a research by using supportive materials like
books, websites, etc., and give a feedback of the findings on P2.1 and P2.2. The answers
need to be reflected the Tom & Jerry LTD database solution given on the case study.
Answers without application to an organization or without examples will be marked as
Resubmission.
Case Study
Tom & Jerry LTD
Tom & Jerry LTD plan to computerise the sales ordering and stock control systems. A
feasibility study has indicated that a relational Database should be installed. The details of
TOM & JERRY LTD sales and stock control are as follows:
Customers sent orders request for goods. Each order may contain requests for variable
quantities of one or more products from TOM & JERRY LTD’s range. TOM & JERRY LTD
keeps a stock file showing for each product , the product number, the product details,
including product description, quantity in stock, reorder level and reorder quantity, and the
preferred supplier.
TOM & JERRY LTD delivers those goods that it has in stock in response to the Customer
order and an invoice is produced for the despatched items. Any items that were not in stock
are placed on a backorder list and these items are usually reordered from the preferred
supplier. Occasionally items are ordered from alternative sources.
In response to the invoices that are sent out to TOM & JERRY LTD’s customers, the
customers send in payments. Sometimes a payment will be for one invoice, sometimes for
2

part of an invoice and sometimes for several invoices and part-invoices.
You have been appointed as a database consultant for Tom & Jerry LTD to design and
implement a database system. You are responsible to identify any additional appropriate
requirements if necessary in addition to the ones given by the company below. The company
policy is not to provide their current data set for implementation and testing purpose of the
new systems. It is required to use own set of data by the learners related to the given case
study for normalisation and testing of the new systems.
 Have an interface to enter user ID and the password
 Enable the Company to store data securely, by identifying required entities to be
converted into tables. The company given the following entities which are compulsory
and any additional entities identify by the database consultant should include as
additional entities. (Customers, Payments, Products, and Invoices).
 Create forms user interface for adding records, deleting records and amend records
for the tables you have created a part of the solution.
 All the forms required to include appropriate validation rules which minimise data
entry errors.
 A report is required that identifies which products need to be reordered. A product
needs to be reordered if the current stock level is less than the minimum stock level.
 Company required print invoices for the orders that have been placed.
The invoice should meet the following requirements:
 there should be one invoice per order
 each invoice should be on one side of A4
 Tom & Jerry LTD’s name and address must be displayed
 the customer contact and address details must be displayed
 • The order number and the details for the order, including the product details and
quantity, must be displayed.
 The total cost of the order should be calculated and displayed.
3

• Produce a report to show all weekly invoice total amounts.
The report should include name and address of the company including contact details,
customer contact and address details, total weekly invoice total must be included.
• Create a query to search and find a customer by entering the customer name or ID
• Create a query and a report showing all orders where payment is more than 28 days
past the payment due date etc. The report should include name and address of the
company including contact details, customer contact and address details.
• A main menu is required for users to access the different parts of the system. The
menu should load automatically when the system is started.
(LO2 A.C 2.1 AND A.C 2.2)
Required
2.1- Analyze a database developmental methodology for the given case study Tom & Jerry
LTD
2.2 discuss entity-relationship modelling and normalisation for the given case study.
TASK 3:
LO3 Be able to design, create and document databases
LO3.( A.C3.1. 3.2,3.3 and 3.4)
Required
3.1 –for the case study given above consider the user requirements and apply the database
developmental cycle to develop database solution for the Tom & Jerry LTD
3.2 – design a fully functional database which includes tables, forms, queries, reports,
various validation and verification techniques and various interaction in forms such as drop
list , check box etc. by using a suitable database applications for the given case study. Your
database design must contain minimum of four tables linked to your case study.
3.3 - evaluate the effectiveness of the database solution and suggest methods of
improvement for the Tom & Jerry LTD.
3.4 provide supporting users by providing user manual and technical documentation for the
database you have implemented for Tom & Jerry LTD.
4

7 Evidence Checklist
Learning Outcomes Assessme
nt
Criteria
In this assessment
you will have the
opportunity to
present evidence that
shows you are able to:
Task
Numb
er
Evidenc
e Check
list
LO1
Understand databases and
data management systems
1.1 Aanalyze the key issues
and application of
databases within
organizational
environments
1
LO2
Understand database design
Techniques
1.2 critically evaluate the
features and advantages of
database management
systems
1
2.1 analyse a database
developmental
methodology
2
2.2 discuss entity-relationship
modelling and normalisation
2
LO3
Be able to design, create and
document databases
3.1
apply the database
developmental cycle to a
given data set 3
3.2 design a fully functional
database (containing at
least four inter-relational
tables) including user
interface
3
3.3 evaluate the effectiveness
of the database solution
and suggest methods of
improvement
3
3.4 Provide supporting user
and technical
documentation.
3
5

8 Contextualisation grid to achieve higher grade
Merit Description:
M1. Identify
and apply
strategies to
find
appropriate
solutions.
Relevant theories
and techniques have
been application.
.
To achieve M1, you will identify and apply
strategies to find appropriate solutions to the
given case study and use of relevant theories
particular emphasis on (1.2), and techniques
(2.1), (2.2).
M2. Select/
design and
apply
appropriate
methods/
techniques.
A range of methods
and techniques has
been applied.
To achieve M2, the learner have apply
appropriate methods and used suitable
techniques with a particular focus on (3.3) (2.1),
for the given case study.
M3. Present
and
communicate
appropriate
findings.
. Appropriate
structure and
approach has been
used.
To achieve M3 the leaner must present the
work with appropriate structure and present and
communicate the findings across the tasks 1 to
3 with special reference to selected
organisation. Technical languages accurately
used in all part of the assignment.
Distinction Description:
D1. Use
critical
reflection to
evaluate own
work and
justify valid
conclusion.
. Synthesis has been
used to generate and
justify valid
conclusions
To achieve D1 you will have addressed the
Criteria’s with valid conclusions, with special
reference to task 2 & 3 justifying improvements
and characteristics of success towards the
database solution developed for the given
company. Realistic improvements have been
proposed for the solution implemented for the
given case study.
6

D2. Take
responsibility
for managing
and
organizing
activities.
Substantial
activities/projects or
investigations have
been planned,
managed and
organized.
To achieve D2 you will have used substantial
activities have been planned, managed and
organized across your assignment with special
reference to design and implementation of a
database for the given case study.
D3.
Demonstrate
convergent,
lateral and
creative
thinking
Ideas generate and
decisions taken
To achieve D3 the learner expected to
demonstrates new ideas or suggestions as
improvements for the new database systems.
The new database system also demonstrates
creative thoughts.
7

9 Assignment Guidelines:
 Use a standard report structure, Word-process the report and use Normal script of a
proper font size 12.
 Produce an academic report, detailing the above issues with a word limit of 4000 to 4500
words.
 Complete the title page and sign the statement of authenticity.
 The Assignment sheet should be attached in the front.
 Submit the document in a folder in the form of a file as well as a soft copy on the
submission date.
 It should be uploaded on E-Learning platform before the deadline and submitted to --------
and sign the submission form of the college.
 Assignments submitted after the deadline will not be accepted unless mitigating and may
be entitled for a late fee.
 Collusion and Plagiarism must be avoided.
 Start each answer on a new page and pages should be numbered. Highlight each
question clearly.
 Include a Bibliography at the end of the assignment and use the Harvard referencing
system.
 All work should be comprehensively referenced and all sources must be fully
acknowledged, such as books and journals, websites (include the date of visit), etc.
 Try to give the page numbers, publishers' details and the year of publication
 In order to pass you need to address all the LO and Assessment Criteria’s.
 In order to get a merit you need to address all LO assessment criteria and the
characteristics of M1, M2,M3
 In order to get a Distinction you need to address all Merit characteristics and the
characteristics of D1, D2 and D3.
Use a common format for the questions, for example:
 Introduction (analyse the question.)
 Underpinning Knowledge (write about the relevant theory/points)
 Applied knowledge(Data Analysis)
 Conclusions and Recommendations (summarizing the whole scenario keeping in view
pass, merit, distinction criteria.)
8

10 Glossary of academic words used in this and other
assignments
Account for Give reasons for: explain why something happens.
Analyse Examine something in very close detail and from
a number of angles. Identify the important points
and chief features, and understand their
relationships.
Argue Present a case for and against a proposal or
statement and present your own opinion at the
end.
Compare Show how two or more things are similar.
Contrast Look at two or more things and draw out
differences. State whether the differences are
significant.
Critically
evaluate
Weigh arguments for and against something,
assess the strength of evidence on both Faisales.
Define Give the exact meaning of.
Describe Give a detailed account of the main features or
characteristics ...
Discuss Write about the most important characteristics of
something. Give arguments for and against, look
at it from a variety of perspectives.
Distinguish Identify the differences between two items.
Evaluate Assess the worth or usefulness of something. Use
evidence to support your opinion.
9

Examine Look at something in detail. You may be expected
to 'critically evaluate' it as well.
Explain Make it clear why something happens or why it is
the way it is.
Identify Recognise name and briefly describe something.
Illustrate Use examples to further explain or justify
something. Could be visual or verbal.
Interpret Explain the meaning or significance of information
or data that you are presenting.
Justify Provide evidence that supports an argument or
idea.
Outline Give only the main points, show only the main
structure.
Prove Present evidence in a logical structure to support
an argument for a point of view.
Relate (Two
meanings) 1. Show how ideas / theories/ events etc are
linked or connected.
2. Tell a story. Explain something in a narrative
fashion.
Review Survey and comment on the key aspects of
something or a range of things.
State Give the main features clearly and simply.
Summarise Draw out the main points, omitting detail and
examples.
10

To what
extent…
How far is something true, or contributes to a final
outcome. Also how far is it not true? In academic
writing the answer is usually somewhere in the
middle.
Trace Describe the development of something; follow
the order of different stages in an event or
process.
11