Importation of three tables, namely, User
, Invitation
, and Departments
has been done. The Departments
table is not related to any tables since they were imported as a flat file, but there is a need to create a relationship and to make a good logical design in order to make reports and analysis.
The most vital thing is that the User
and Invitation
tables were imported from a relational database and precisely it contains transaction data. This means the tables are created based on the index and optimization and stored as physical models as the Gender
attribute has values 1
and 2
, where 1
denotes male and 2
denotes female. But the users must make everything into a logical model, since the end user will be able to understand easily, otherwise if we provide inputs such as 1 and 2, they won't understand; also, it's not the way reporting should be done. When we provide the report to the end user, they must easily understand all the data in it just by glancing...