So I've recently decided to try and make a database. At the moment I have 6 spreadsheets, but all of them are about employees. So when a new employee joins, I have to add them to 6 spreadsheets.
Problem is, each of these spreadsheets could be fit into 1 because an employees name can only appear once. But they're currently seperated because infomation on 1 table, will have nothing to do with informaton on another table (eg. Home Address on one, training records on another, driving licence details on another etc.)
I'm currently struggling in the designing phase. Currently what I'm trying to figure, is should I make one table with lots and lots of fields, or should I stick with many tables, and create one-to-one relationships. Then I suppose I can separate the information using queries.
Thanks for any help. If anyone needs more info then let me know
Bookmarks