By now, you should know that a database is a collection of information related to a specific purpose. But how do you organize this information for maximum efficiency? A good database design is the key.
The table is the heart of the database. It is where most of your database work focuses either directly or indirectly. But just because you have several tables that relate to each other in your database doesn’t necessarily mean that they are ready for database functionality.
Considerations related to database design include
the purpose of the database
necessary tables and fields
necessary relationships between tables
how to avoid data redundancy
how to ensure data consistency
When you examine these considerations, ...