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 first figure out how we want to design the database.
According to Microsoft's TechNet, there are five basic steps one could follow to plan a database:
- Gather information
- Identify the objects
- Model the objects
- Identify the types of information for each object
- Identify the relationship 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 and how it will be used.
Think about it in everyday terms—if you write an address for a friend's house, you might want something more that just...