The following is an ordered list of special database steps you can follow to create a good database design for your web application. First keep in your mind why you need to create a database and what you are expecting it to do. Database designers sometimes fall into trouble when. They assume that the data special database exists for its own sake. They assume that the database exists for the sake of the Information Technology department.
Both the above are wrong, and the special database exists for its users. Before you design your database, find out why the users of your application need the database and what the users expect to accomplish from it. You can think of this purpose statement as a mission statement or a charter for special database the database. The more complicated and complex your application is, the more detailed your Charter will be. But always limit your charter to the key points that identify the unique capabilities that the user expects from the database.
The most vital part of this step is to special database examine how the data is currently being stored and to uncover the weaknesses. If the data is currently being stored in an Excel spreadsheet or is stored in paper form in special database file cabinets, carefully examine them to see what kinds of data are included in them. Once you finish Step 1, and you are done with your Charter, start listing the major tables of the database you are special database going to create. When you have come up with a rough list of tables and the data items, always keep in mind them as entities that are like real-world objects that the special database database needs to keep track of. For every database you create, there should be special database a column or combination of columns that uniquely identifies each row in a table.