I have to create a new database for a new set up and design the tables for future use.
The data is to be imported from excel sheet . The data contains the daily reports from the operations team . Which are the key points that needs to be looked into while designing the table and importing the data. I have listed down few points.
They are
- Check whether there are unique fields in the data
- Decide on primary and foreign keys
- Design the tables as per normalization
Can anyone add more points to it. I'm doing such a project for the first time. Thanks!!