In order to properly set up an SQL database for use with our application, we need to plan out what data we will store and how the data will be related. Use the current database spreadsheet and the below screenshot for inspiration when building out the ERD in this diagrams.net document. This will be an interactive process, and starting earlier is bound to make things easier for us.
In order to properly set up an SQL database for use with our application, we need to plan out what data we will store and how the data will be related. Use the current database spreadsheet and the below screenshot for inspiration when building out the ERD in this diagrams.net document. This will be an interactive process, and starting earlier is bound to make things easier for us.