Using a standard notation, you are required to produce a data model for Merrill Hand Tools Ltd -the case study document is available on the module`s Blackboard site

0% Plagiarism Guaranteed & Custom Written

Assessment Task 1: E-R Modelling

Requirements

Task one of the coursework aims to facilitate analytical and design practice using case studies. Using a standard notation, you are required to produce a data model for Merrill Hand Tools Ltd -the case study document is available on the module`s Blackboard site.

To produce a data model that satisfies the needs of Merrill Hand Tools Ltd. you are expected to:

• Analyse the case study in detail.
• Apply a Top Down modelling approach to produce an Entity-Relationship (E-R) Diagram.
• Apply a Bottom-Up modelling approach to identify functional dependencies and proceed to data Normalisation.
• Finalise the data model by recombining the E-R Diagram and the normalised data structures.

You are expected to produce a report outlining the process followed including the outputs obtained at each stage. Assumptions should be clearly stated.

Submission details

This is a group assignment (maximum 3 members). Your report should be submitted electronically through the module`s Blackboard site. You will find a link under Assessment for this submission.

Contribution breakdown

The default assumption for this assessment is that all the members of the group will have contributed equally and should therefore receive the same mark. Alternatively, you may choose to allocate the individual contribution pro-rata amongst yourselves. In either case, you will need to download the "Group Member Contribution" form available under the Assessment folder on Blackboard and submit it through the indicated link on the module`s Blackboard site. We require each member of the group to sign the form -electronic signatures are acceptable.

Notes:

• As per the module`s descriptor, the maximum length of the document is 2,000 words plus images and tables. Appendices do not count against this maximum length.
• Only one member of the group submits the report. Please make sure you do not submit more than once. Also, make sure that the names and student numbers of all members in the group are clearly indicated. (No name, no marks!)
• Only one member of the group submits the Group Member Contribution form. Please make sure you do not submit more than once. The names and signatures of all members in the group are required.

The normal regulations for the submission of work apply, for further details see: http://students.shu.ac.uk/rightsrules/regs.html