Nomalization Help needed urgently

Discussion in 'Database' started by mak1, Feb 19, 2009.

  1. mak1

    mak1 New Member

    Feb 19, 2009
    Likes Received:
    Trophy Points:
    Could someone please help me or guide me on how to put this in 1nf, 2nf and 3nf.

    * Primary Key *Foreign Key

    Customer: (Customer No, Firstname, Surname, DoB, Address Line, Town, Postcode, TelephoneNo, MobileNo, Email Address, Password, Registration Date)

    Dvd’s: (Dvd ID, Product ID, Title, Category, Certificate Rating, Quantity, Price)

    [Rentals: (Rental No, CustomerNo, Dvd ID,Copy No, Date Rented, Date Due Back, Price, Date Returned, Fine, Fine Paid, Total)

    Cd’s: (Cd ID, ProductID, Title, Artist, Genre, Quantity, Price)

    Cd Sales: (Sales No, Cd ID, CustomerNo, Price, Quantity, Total Purchase, Payment Method, Date)

    Product: (Product ID, Product Description, Supplier ID)

    Supplier: (Supplier ID, Supplier Name, Address Line, Town, Postcode, Telephone No, Product Description)

    Staff: (StaffID,EmpFirstname, EmpLastname, DOB, Address Line, Town, Telephone No, Mobile No, Email Address, EmpPassword, EmpAccess, Role)

    Receipt of Payment: (Receipt No, Sales No, Customer No, Staff ID, Payment Method, Date, Amount)

    Refund: (Refund No, Reciept No, CdID, RefundPrice, RefundDate, Refunded)

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice