Question Yearly permit renewal

[WilliamV]

We have a db to register permits that count for one calendaryear. This since 2012. For next year, permits must be renewed.
How can we keep track of all permits per year per user in the same table ? We would like to produce annual statistics as well ?

Easy solution would have been to copy the existing table for the year 2012 and paste as a new table for year 2013 but we don't know yet who will renew his permit ...

Thank you for any help. Grtz.

 

[Mr. B]

The first thing you need to do is to make sure your database is normalized. What you are wanting to do is by not means a one table database.

At a minimum, you will need two tables. One for data related specifically to each permit holder and another for data specific to the issue and renewal of the permit.

As you start to evaluate your needs for you database, you may find that you need even more tables.

 

[WilliamV]

I will give this thoughts and keep you informed. Thank you.

 

[Alansidman]

WilliamV
Mr. B is spot on. This link will help you to understand and develop your information into a normalized manner.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx