I'm designing a relational database to get rid of our current system of manual excel sheet input as we're going paperless.
Tho I've never made a relational DB before as i've only ever needed one table or such for past experiences.
Attached I have what I've done so far in terms of planning. From what I've read I need a super key to relate my DB together.
Since my database keeps track of daily work orders and work done I'd assume any table that will be updated daily will need a Date column.
Than any other column that needs information from another table will be connected aswell(foreign key)
Please point out any flaw in my logic (like am i using the right keys?)as im not 100% sure this is how you make a relational database.