Architecting The Database
In no particular order, we will look at architecting the database as we continue our tour of software architecture from scratch. There are several key considerations to keep in mind while doing this work. A wrong decision or improper architectural choice can have a far-reaching impact as we build from the backend. Here are some areas that we want to think through as we design our backend solution. Primary Keys One of the most commonly utilized values in a database is the primary key. This is the value that uniquely identifies a record within the database in a specific table. You can limit that uniqueness to the database and even table, or you can make it universally unique (GUID). While... Read more