We can't know what we're doing until we know what we're doing. Before we jump in and create a solution with our database, models, and controllers, we need to figure out how we want to design the database.
According to Microsoft's TechNet, there are five basic steps we can follow to plan a database:
- Gather information
- Identify the objects
- Model the objects
- Identify the types of information for each object
- Identify the relationships between objects
Our requirement is pretty simple. We only need to save a web link to navigate to later, so we won't have multiple objects with relationships between them.
We do, however, need to clarify the types of information we'd like to save for our object (web link). Obviously, we need the URL, but what else do we need? Make sure you understand what information is required for your solution...