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


Extracts from this document...


Lab Experiment 2: Database Table creation,

Maintenance & Views

2.3: Preparation


The primary key of a table is a column (or combination of columns in a table) that are used to uniquely identify rows in a table. This means that two different rows in a table may never have the same value in their primary key, and for every row in the table the primary key must have a value.

Therefore, if the primary key column(s) are declared NULL, two or more rows in the primary key can have identical values and thus they will NOT be unique. Also the definition of the primary key states that a primary key must

...read more.


basically states that the entity is in the 1NF if it consists of a Primary Key.

By analysing the two tables, SUPPLIER and INVENTORY, it is evident that they both consist of a primary key attribute.

In the SUPPLIER table the primary key attribute is the CODE attribute, where as in the INVENTORY table it is the ITEM_CODE attribute.

 A table is in the 2nd Normalisation Form (2NF) if it is in the 1NF and no attribute is dependent on only a portion of the primary key.

The SUPPLIER table has a single attribute primary key. Thus by default, this table is in the 2NF.

On the other hand, the INVENTORY

...read more.



The SUPPLIER table is now in 3NF, as it does not consist of any transitive dependencies.

The new table is called SUPPLIER_ADDRESS and it contains attributes that were involved in the transitive dependency in SUPPLIER table.


The new table is normalised because it complies with the rules of the 1NF, 2NF and 3NF.

The INVENTORY table is free of any transitive dependencies, so it is in the 3NF.


The many-to-many (m:m) relationship between the STUDENT entity and the MODULE entity is broken down into two, one-to-many (1:m) relationships, with a creation of a new entity called STUDENT_MODULE.

...read more.

This student written piece of work is one of many that can be found in our University Degree Software Engineering 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 Software Engineering essays

  1. MS Office solutions. Fantasy mobiles require: ...

    It enables the 'models' list box to be populated from a range of cells (E5-E10) once the button is clicked. The Count property is used within the 'for loop' to determine the position of the items that are to be added to the list box.

  2. 3SFE504 - Object Oriented Programming - Linear and Independent Hash Table code

    "<<endl; cout<<"\t # * * #"<<endl; cout<<"\t # * 1. Display The Directory * #"<<endl; cout<<"\t # * 2. Search your word * #"<<endl; cout<<"\t # * 3. Sorted your dictionary * #"<<endl; cout<<"\t # * 4. Inserting new word * #"<<endl; cout<<"\t # * 5.

  1. Complete Section 2 of 3

    Since we are going to connect all locations together we have the ability to use other network options.

  2. software program specification and code for a DVD store

    Display 2 blank lines case 4 Display "1. Born romantic." Display "=================" Display a blank line Display "Starring: Williams, Olivia Ferguson, Craig Morrissey," Display "David Horrocks, Jane Mistry, Jimi McCormack, Catherine Lester, Adrian Thomson, John." Display "Directing: Kane, David." Display "Genre: Romance." Display 2 blank lines Display "2.

  1. Creating a database system for Mr Azizur Rahman, Mr Bilal Sheikh and Mr Iman ...

    Furthermore when making the customers current computer spec, the table in which they record it does not contain hardware software RAM etc. They do not have a form with all the questions already written. As a result they miss out some of the vital questions, which leads to calling back to customer to get their full details.

  2. Human Computer Interaction Project.

    The camera is shaped so that it is comfortable to hold, with a grip on the right hand side. Further details of the camera as well as copies of the two main diagrams which name all of the buttons and switches and levers on the camera can be found in Appendices E and G.

  1. Evaluating Websites Usability - comparing 5 websites.

    It is very obvious that this page is about healthy eating, there is a picture menu with good pictures of different foods with appropriate headings. Hovering the cursor on top of these pictures enlarges the photos and form links.

  2. Abstract This report is dedicated to demonstrating and critically reviewing new features and developments ...

    feel part of the operating system typically come late in the development process. [12]? 1. Desktop Enhancement Some minor but useful changes have been made based on the desktop of Vista. These changes make the desktop interface more user-friendly. For example, the new Taskbar is a bit taller by default

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