With a simple example of designing a data model with “employee related information”, most of the data structures can be easily understood. So we will try to design a data model using the sample data given below and will explain the data modeler’s involvement in the database environment.
Sample Source Data
|First Name||Middle Name||Last Name||SSN||Gender||Birth Date||Salary||Dept No||Dept Desc|
Note: If you go through our topics provided under the Data Modelling Section, you will have a brief idea about how to design a data model.
Please proceed to next page for sample data analysis.