check my design

[jamie]

I am writing up the design for a new database and I was wanting you to check it out to make sure I have it right before I actually created it



tblNames

NameID
firstName
LastName
CompanyName

tblPhone

phoneID
HomePhone
CellPHone
CompanyPhone
nameID

tblAmount

amountID
startBalance
amountPayed
balance
nameID

tblDate

dateID
datePayed
amountID




Primary keys at the top, foreign keys at the bottom. does this look right to you?

[A S MANN]

Look near perfect design. For perfect normalization define the relationship between tables and than show this design to forum for further assistance

[TheShabz]

Not that there's anything wrong with what you have, but here's another idea for tblPhone

phoneID
number
phoneTypeID
nameID

This would require another table, tblPhoneType

phoneTypeID
phoneType

EDIT:

In general, you want to avoid having blanks. So if one person only has a home phone, the other two would be left blank. Also, and perhaps more important, this will allow you to be able to expand the types of phone numbers you have. If you later want to add a "Cell2" or "fax" or whatever else, it can be done on the fly.

Also, its "paid" not "payed"
What is the practical relationship between your amount table and paid table? you may be able to combine those.