Normalization

[Lana21]

I currently have a database which I believe is in 3NF. It's completed as such, but I have recently come accross normalization methods. Because of this I would like to know how my 3NF tables could look in 0NF, 1NF and 2NF. For both the purpose of ensuring the database is correct now, and for future reference...to do a more professional job next time!!

Here's how the tables currently look:

CUSTOMERS(CustID, CustName, CustAddress)
ORDERS(OrderID, CustID, OrderDate)
ORDERDETAILS(OrderID, BookID, BookPrice, Quantity)
BOOKS(BookID, AuthorID, BookName, BookUnitPrice)
AUTHORS(AuthorID, AuthName, AuthAddress)

It's just basically a simple book royalty system. I have looked around various sources for examples, but my database has a few more tables in 3NF than most examples show.

Thanks guys.

 

[ScottGem]

This looks fine to me, though you could take it to extremes with a separate address table and lookups for City, Postal code etc.

You might also need to account for books that are collaborations and have multiple authors. That would require a junction table:

tjxBookAuthors
BookAuthorID
BookID
AuthorID

then remove AuthorID from Books.