Required tables?

[IanHunter]

I want an access database to manage my correspondence after my motorbike accident.

I am sort of unsure on tables and correct normalisation so here's my plan so far.

Table 1
Company address details


Table 2
Contact name details
(I have a lot of different people from different departments in each company) so a contactID to table 1

Table 3
Media Type - letter, email, phone call etc

Table 4
Category - Legal, Financial etc

Also I want to link pdf images to each entry.

Does this sound okay or can tables 1 and 2 be merged? dunno if it would be easier to add names to an existing company rather than possibly adding the whole thing again.

Thanks all for looking

 

[jdraw]

I want an access database to manage my correspondence after my motorbike accident.

I am sort of unsure on tables and correct normalisation so here's my plan so far.

Table 1
Company address details


Table 2
Contact name details
(I have a lot of different people from different departments in each company) so a contactID to table 1

Table 3
Media Type - letter, email, phone call etc

Table 4
Category - Legal, Financial etc

Also I want to link pdf images to each entry.

Does this sound okay or can tables 1 and 2 be merged? dunno if it would be easier to add names to an existing company rather than possibly adding the whole thing again.

Thanks all for looking

Normalization and relational design reference:
http://r937.com/relational.html