Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2015

    Question Unanswered: Database Normalisation?


    Firstly, i apologise if this is in the wrong section. I am currently trying to learn more about database normalisation, and i have a set of attributes that i am trying to put in 1NF, 2NF and 3NF. After reading through some websites and watching videos on youtube (they haven't been much help) i am still quite lost. I am aware that no repeating fields should be shown within 1NF, but i am still not quite sure how this data would be broken up.

    Any help or suggestions anyone can give would really help me to understand this.

    The data example i have is:

    Customers (CustomerID, FirstName, LastName, Email, PhoneNumber, Address, City, Country, PostCode, WebPage, Notes)

    Order (OrderID, CustomerID, DateOfOrder, OrderDetails, ProductsInOrder, ProductQuantity)

    Products (ProductID, CoffeeName, CoffeeVariety, UnitPrice, Description, ReorderLevel)

    Suppliers (SupplierID, Company, ContactName, PhoneNumber, Address, City, Country, PostCode, WebPage, Notes)

    Kind Regards.

  2. #2
    Join Date
    Nov 2015
    Your data already appears to be in 3NF.

    a) Every column value is atomic (does not comprise of multiple distinct values) - 1NF
    b) Each table has a primary key (customerId, orderId, productId, supplierID) - 2NF
    c) The non-key columns are wholly dependent on the primary key of each table - 3NF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts