• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

In order to reach the stage of the final Entity Related diagram (I shall call this the ERM) I had to go through quite a large amount of data and processes. The first process being normalization, done through the nine forms given to us

Extracts from this document...

Introduction

                David Sands

Final Assignment Report / Evaluation

In order to reach the stage of the final Entity Related diagram (I shall call this the ERM) I had to go through quite a large amount of data and processes. The first process being normalization, done through the nine forms given to us (in Microsoft Excel format).

Normalization:

                This section of the assignment took a long time to complete and went through many different versions to get to the one included here. The purpose of normalizing the data is to get the information down to the simplest form and extract the entities ready to place in an ERM. Began the process by taking the entities from the Excel tables given to us and putting them into a table under the name Unified Normal Form (UNF). To start with at this first stage I just introduced a name and a primary key.

...read more.

Middle

The process of decomposing the entities from UNF to FNF is just the same going from FNF to SNF (Second Normal Form) and from SNF to TNF (Third Normal Form), however I was not always able to do this. The example shown in figure one only decomposed to FNF as seen in the diagram, when this happened I just filled in the rest of the table as shown in figure two below,

image02.png

image00.pngimage00.png

image00.png

As you can see I’ve had to just repeat FNF all the way along to TNF.

...read more.

Conclusion

Overall I encountered many problems from start to finish, all the biggest ones of which at the normalization stage. The actual ERM took a while to take shape, what with making sure the crows feet pointed in the correct direction and deciding which of the entities were needed and which weren’t.

It is only when the process is completed that you can truly see the point of all the proceeding hard work and how every stage really does help to contribute to the final product.  

Analysis of Information Systems                Home Bakery Assignment

...read more.

This student written piece of work is one of many that can be found in our University Degree Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related University Degree Computer Science essays

  1. So in order to understand what the main areas where organisation should be aware ...

    The objective is to gather information essential to an attack and enable an attacker to obtain a complete profile of an organization's security posture. During this phase, the hacker might gain information about the location of the company, phone numbers, employee names, security policies, and the overall layout of the target network.

  2. Avon, which began its operations in 1886, is a global manufacturer and marketer of ...

    AVP's reportable segments are based on geographic operations. The company has operations in 58 countries, including the U.S., and its products are distributed in 85 more countries, for coverage in 143 markets. Sales are made to the ultimate customer mainly through a combination of direct selling and marketing by approximately

  1. The purpose of this project is to discuss the issues associated with the deployment ...

    The next few sections outline the challenges that must be overcome to make wireless Internet access appealing to the average wireless subscriber. The Market Is Different Bringing computing power to a wireless handset opens an extensive new market for information access.

  2. This project intends to clarify the encapsulation process and the tunnelling protocol technologies used ...

    I would like to express my gratitude to my project supervisor, Colin Egan, for undertaking the responsibility of supervising the project and for his invaluable optimistic attitude throughout the year. James Malcolm, my Networking tutor for his advise about the topic, even though I always turned up at the most inopportune moments.

  1. Simplistic analysis of data collected from children's non-verbal responses as well as from their ...

    sessions and was reassured as I read 'you need to lose control for free flow of thoughts'. At least I had fulfilled one of the criteria for the M. Ed. Course! I was also acutely aware of the sensitivity of the issues relating to research with children and the subjectivity of their perceptions.

  2. The purpose of this assignment is to research about Electronic data interchange and needs ...

    Electronic data interchange describes a sequence of messages between two parties, either of whom may save as originator or recipient. The formatted data representing the documents may be transmitted from originator to recipient via telecommunications or physically transported on electronic storage media. (6) EDI's messages are usual received by computer.

  1. Effects of organisational culture on a large scale IT introduction effort: A case study ...

    Within the academic tradition of organisational theory as understood and explained by sociologists specialised in the area, several authors have attempted to give a definition of organisational development. French and Bell (1984) say that 'an organisational development process is a long range effort by the organisation to improve its ability to solve problems.

  2. The marketing research process.

    The use of interviews as a data collection method begins with the assumption that the participants' perspectives are meaningful, knowable, and able to be made explicit, and that their perspectives affect the success of the project. An interview, rather than a paper and pencil survey, is selected when interpersonal contact

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work