I am very new to the database design world and was wondering if some of you could look this over to see if everything is up to snuff.
I am designing a backend database to track our internal and external IT audits. Here are the tables that I have created thus far but I’m not quite sure how the relationships should work. I have included what I think would be PK and FK. I will also probably be adding to this as I think of more items to track.
I am thinking of using MYSQL for the database but I’m not 100%. Any help would be appreciated.
Also I will probably need to design a web frontend for usability any suggestions on a preferred language to write it in.
- use plural table names
- do not unnecessarily repeat part of the table name in the column name
- use ID as the column name for surrogate keys (auto_increments)
- do not use an integer surrogate to substitute for an integer value
- foreign keys reference primary keys (se in red below)