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

LabExperiment2Report

Extracts from this document...

Introduction

Lab Experiment 2: Database Table creation,

Maintenance & Views

2.3: Preparation

(1)

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.

Middle

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.

Conclusion

SUPPLIER (CODE, NAME, CONTACT, ADDRESS 1, ADDRESS 2, PHONE, FAX).

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.

SUPPLIER_ADDRESS(SUPPLIER, POST_CODE, TOWN)

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.

(5)

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 ...

    This results in a delay in the ordering of the new components and in effect delays the up grade of the computer. In addition the calculations made to work out the overall cost of the upgrade and to see whether or not it meets the price limit set by the customer.

  2. Human Computer Interaction Project.

    The user is required to comment on any problems they encounter as they go along and on any aspects of a system which have caused them confusion. They are also encouraged to suggest any possible improvements to the system which would increase its usability.

  1. Evaluating Websites Usability - comparing 5 websites.

    But the ?Basics?, ?Science? and ?Tips? links all bring you to the home page. 5. Only about 7% of the home page is visible. Navigation: 1. The links are clearly visible on the page and you can click on the author?s picture on top of page to see a mission statement about herself.

  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