Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011

    Database Normalization

    how to normalize a database upto BCNF if you are given relational schemas. For example how can i normalize the following schemas upto BCNF.....

    suppliers( supplierID, CompanyName, contactName, contactTitle, address, city, postalCode, country, phone,

    fax, email, url, paymentMethod, typeGoods, logo )

    products( productID, supplierID, categoryId, productName, unitPrice, color, size, unitInStock, picture )

    category( categoryId, categoryName )

    order( orderID, customerID, paymentID, ShipperId, orderDate, shipDate, PaymentDate )

    orderDetails( orderDetailId, orderId, productId, unitPrice, quantity, total )

    payment( paymentId, paymentType, allowed )

    shippers( shipperId, CompanyName, phone )

    customers( customerId, firstName, lastName, address, city, postalCode, country, phone, email, creditCard, creditCardTypeId, cardExpMo, cardExpYr, BillingAddress, BillingCity, BillingPostalCode, BillingCountry, ShipAddress, ShipCity, shipPostalCode, ShipCountry, DateEntered )

    please explain in details....

    thanx in advance

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    wow, what a lot of information

    when is this homework assignment due? | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    out on a limb
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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