Q4. What are the things that you need to keep in mind while designing the fields for a table?
Ans. You need to decide the type and number of fields required for the tables in your database. Each table in a database contains data or information about a single entity. This information is inserted in the fields of the table.
For example, the entity of the Employee_Details table is the employee. This table has four fields, which contain information about the employees in an organization, such as employee code, name, address and salary. Keep the following points in the mind while determining the fields for the table:
- Each field is directly related to the entity of the table.
- Insert all the information you require in the respective fields of the table.
- Store the information in small logical parts, such as first name and last name rather than just name.