• 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 best applications will give the user a comprehensive, personalized summary of important information and will allow them to easily drill down for more detailed information. The Network Is Different Wireless data networks present a more constrained communication environment compared to wired networks.

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

    I concentrated on the Networking and the Programming subjects during my first two years plus a Final Year HND Project in Local Area Networking. Another aspect that influenced me was my summer job at VOLVO IT (The Swedish Car Company's IT Department), where I worked for five summers with different

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

    Although I felt I had a good understanding of the implications from class and year group data, I was unsure as to how one began to theorise and generalise about so many seemingly disparate statements generated by the respondents. I looked back at my notes from one of the Foundation

  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