Database Design

[Harold Lethcroft]

Hi

I apologise if this seem slightly irrelevant to this site but I don't think it is, basically I have been asked to design a database and am having trouble designing the tables. I have attached a spreadsheet showing the data I have available so I can ask for specific help about how to decide which tables to make, what fields and primary or foreign keys they will need.

I will be creating my database in Microsoft Access but am just planning and am more familiar with Microsoft Excel.

I created the field Customer ID but the rest are all of the fields (except that I split address into the 3 listed categories and split customer into 3 categories)

I have added comments on cells that are either primary or foreign key.

I'm not sure if I can add surname as a foreign key to both my hire and cars table but whats done is done.

 

[jdraw]

Your expertise in Excel may be a hindrance rather than a positive with respect to Access. The underlying object models of spreadsheet and database are quite different.
I recommend you work through this tutorial to get a better appreciation of database; the appropriate tables; primary and foreign keys; and normalization. I also recommend you write down a clear statement of your business processes to ensure you have a reference for your database. The database you design should support your business; and to do so requires that you understand the business.

Good luck with your project.