Posted: March 5th, 2023

Critically discuss the benefits and limitations of

Assignment
front sheetQualificationUnit number and TitlePearson BTEC Level 5HNC/HND Computing and Systems DevelopmentHNCS 133 Data Analysis
and DesignStudent NameAssessorInternal VerifierDate IssuedSubmission Deadline for Task-1Submission Deadline for Task-2Submission Deadline for Task-3Submission Deadline for
Task-4Assignment titleAnalysis, Design and Implementation of
e-Business DatabaseLearning OutcomeLearning OutcomeAssessment CriteriaIn this assignment you will have
the opportunity to present evidence that shows you are able to:Task noEvidence
(Page no)LO1Understand data models and
database technologies1.1critically compare
different data models and schemas11.2critically discuss the benefits and limitations of
different database technologies11.3analyse different approaches to database design1Learner declarationI certify that the work submitted
for this assignment is my own and research sources are fully acknowledged.Student signature:
Date:In addition to the above Pass Criteria, this assignment
gives you opportunity to submit evidence in order to achieve the following
MERIT and DISTINCTION gradesGrade DescriptorIndicative characteristic/sContextualisationM1 Identify and apply strategies to find appropriate
solutionsEffective
judgements have been made.To achieve
M1,please
answer to question in Task-1M2 Select/design and apply appropriate methods/techniquesA
range of sources of information has been usedTo achieve M2,please answer the indicated part of Task-3M3 Present and communicate appropriate findingsA range of methods of presentation have been used and
technical language has been accurately usedTo achieve M3,please answer the indicated part of Task-1 and 4D1 Use critical reflection to evaluate own work and
justify valid conclusionConclusions
have been arrived at through synthesis of ides and have been justified.To
achieve D1,please answer the indicated
part of Task-3D2 Take responsibility for managing and organising
activitiesActivities have been managedTo
achieve D2,please answer the indicated
part of Task-4D3 Demonstrate convergent
/ lateral /creative
thinkingConvergent and lateral thinking have been appliedTo
achieve D3,please answer the indicated
part of Task-4Guidelines for assignment
submission· The unit has 4 tasks. Please
read ALL tasks carefully.
· Each Assignment has its
own submission date. Please submit all
Assignments ON TIME.
· Only ON TIME and EEC
submission will be considered for a MERIT
and DISTINCTION grade.
· All tasks MUST be submitted on time to be considered for a MERIT grade.
· The attendance percentage
and participation in class lessonsand tutorials will contribute towards the achievement
of Distinction grade.
· All assignments will be
subject to PLAGIARISM checks. PLAGIARISM
is a serious academic offence and will automatically lead to ACADEMIC MISCONDUCT PROCEDURES. In
the event of COLLUSION
(similar/identical submissions) please note that both students will
automatically be subject to ACADEMIC
MISCONDUCT PROCEDURES.
· When IPADS/TABLETS/MACS are used please make sure documents are saved
as .doc. Otherwise the submission will not be valid and may not be marked.e-Business Database
Design
Database technologies
are moving to the forefront of organisational marketing
functions. Traditional approaches such as segmentation and positioning
require information about customer characteristics and preferences. More
recent approaches such as database marketing, relationship marketing, data
mining and micro marketing depend on the collection of detailed information
about customers, their preferences and purchase behaviour. Personalisations
of content and product presentation are hallmarks of the most effective
Ecommerce applications and are achieved through database system
design.
To
understand and exploit the potential of these approaches, the modern
marketing manager must have a solid grasp of the basic functions of database applications. This
assignment contains a series of exercises designed; 1) to develop students'
competence in basic and intermediate skills with Microsoft Access, and 2) to
develop students' competence in basic database design in support of e-Business
activities. Specifically, you will design a system to record and
analyse the operations of your e-Business team.Task 1Task-1Preparation
of Database Design (LO-1: 1.1, 1.2, 1.3 and M1, M3) (You are
required to produce a document for the following activities during analysis,
design and implementation:
1. a. Critically discuss the
benefits and limitations of different database technologies.[M1]
b.
Discuss the advantages and limitations of the different notations and
languages available to represent the analysis and design. [ P1.2 ]
2. Compare the effects and
efficacy of the different approaches used to analyse and design
databases. [P1.3]
3.
Show the process of logical data modelling for your
database. [ P1.1 ]
There are four key
steps in data modeling [please refer to point 3 in reference list, chapter 16]:
a)
Develop a logical data model for each known user view
(form and report) for the application using normalisation principles.
b)
Combine all normalised user views into one consolidated
logical data model; this step is called view
integration.
c)
Translate the conceptual E-R data model for the
application, developed without explicit consideration of specific user views,
into normalised relations.
d)
Compare the consolidated logical data model with the
translated E-R model and produce, through view integration, one final logical
data model for the application.
4.
Model the database schema you need for this application
[please refer to points 4 & 6
in reference list]. [ M1 ]ReferencesReferences:
1.
Consult your
class materials including eBooks provided during the class and tutorial
sessions.
2.
My Lecture Notes on UML
3.
Joeffrey
A. Hoffer et al., Modern Systems Analysis and Design, 2nd Edition,
1999 by Addison and Wesley
4.
.databaseanswers.org/data_models/">http://www.databaseanswers.org/data_models/ß Library of data models
and schemas
5. .wikipedia.org/wiki/Entity-relationship_model">http://en.wikipedia.org/wiki/Entity-relationship_modelß
Entity-relationship diagram using Chen's notation
6. .asp.net/scottgu/archive/2006/07/12/Tip_2F00_Trick_3A00_-Online-Database-Schema-Samples-Library.aspx">http://weblogs.asp.net/scottgu/archive/2006/07/12/Tip_2F00_Trick_3A00_-Online-Database-Schema-Samples-Library.aspx ß Online Database Schema Samples Library
7. .tomjewett.com/dbdesign/dbdesign.php">http://www.tomjewett.com/dbdesign/dbdesign.php ß Database design with
UML and SQL, 3rd edition
8.
.microsoft.com/en-gb/access-help/create-and-use-a-switchboard-HA001213876.aspx">http://office.microsoft.com/en-gb/access-help/create-and-use-a-switchboard-HA001213876.aspx ß Create and use a switchboard
9.
.brighthub.com/computing/windows-platform/articles/33793.aspx">http://www.brighthub.com/computing/windows-platform/articles/33793.aspx ß Using the Switchboard to Navigate Your
Database
10.
.techonthenet.com/access/switchboard/create2007.php">http://www.techonthenet.com/access/switchboard/create2007.php ß Create a switchboard in Access 2007
11.
.youtube.com/watch?v=rb1k_6ykR9k">http://www.youtube.com/watch?v=rb1k_6ykR9kß Video tutorial on
creating a Custom Switchboard in Access 2007.grussell.org/index.html">http://db.grussell.org/index.html ß Database eLearning

Tags: Best Online Essay Writers - Thesis and Dissertation Help, Custom Dissertation Writing Services for PhD Students, Essay USA, UK - Cheap Essay Writing Service