Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Unanswered: Normalizing my database

    I am confused, can anyone help me please?

    How should I normalize this

    Librarian
    (Librarian ID, First Name, Surname, Address Road, Address County, Address Town, Postcode, Tel No and DOB)
    Books
    (Books ID, librarian ID, Title, Author, ISBN and Quantity)
    Suppliers
    (Supplier ID, Librarian ID, Address Road, Address County, Address Town, Postcode, Date Of Order and Price)
    Borrower
    (Borrower ID, First Name, Surname, Address Road, Address County, Address town, Postcode, Date Of Birth and Tel No)
    Invoice
    (Invoice ID, Supplier ID, Price, Quantity and Order Details)
    Loans
    (Loan ID, Book ID, Borrower ID, Librarian ID and Date Lent Out)

  2. #2
    Join Date
    Jun 2009
    Posts
    2
    I know there is steps for normalizing. Like 1NF, 2NF, 3NF, 4NF and 5NF. But I am still clueless.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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