Other Database "template"

I need an empty database to add real estate properties to. With fields for addresses and info type stuff.

What I am wondering is there somewhere that has premade empty databases I can either download for free or purchase? BTW I did search before asking. :)

I always mess up "foreign keys" - if that is the proper terminology - and I have never found a good lesson/software for creation of these keys.

Any suggestions would be greatly appreciated.

the eCommerce database:
ecommerce-database/


is the only empty template that we offer.

you can use this as a starting point to add your own columns to if you like.



What do you mean by:
I always mess up "foreign keys"

in what way do you mess them up?

Theres not really a lot you can do to mess up a foreign key

Foreign keys are columns that create a relation to another table

for example users -> Users Groups
users:
userID - Primary Key
userUserGroupID - relates to usergroups.userGroupID used as foreign key
UserName
etc...

usergroups:
userGroupID - Primary Key
userGroupName

it's not necessary to set the users.userUserGroupID column as a foreign key in the database in order to use it as a foreign key, that is really used for data integrity. In other words, to make sure that you cant delete a usergroup from the database without delete the users first. But with something like a user group this is not really needed, because you may want to define the Supper Admin user level without actually having any supper admins set up yet

Thanks Buddy,

It has been a few years since creating my own databases and since I read "Database Design For Mere Mortals".

Creating relations in PHP MyAdmin seems where I got lost and need to read/study up again.
I understand the concept, it is just the implementation that I need to review.

Thanks so much for taking the time to give a great answer.

I thought maybe someone had heard of a place that offered pre-built empty sql databases to save me some time.
I will just add columns to the free Web assist DB.