Based on the mission and objectives from the project definition phase, create a table structure for your database that includes a complete list of the tables and their fields.
Use the list of characteristics and subjects, along with the mission objectives to create a complete table list for your database design. Be certain that the list is comprehensive enough so that your data model can meet all of your project objectives. Spend time refining the table names and descriptions so that they are clear, unambiguous, descriptive and meaningful to yourself and the client.
The table structure you create should include the fields associated with each table in the data model. For each filed indicate its full data type (e.g. MEDIUMINT rather than just “number”) and any field constraints. Identify all primary and foreign keys. For all foreign keys indicate the tables and fields to which they relate and their delete rules.