Tag Info

New answers tagged

1

To answer your questions: Year number is part of a (three column) composite primary key. There will be one record per employee + year + type of leave (vacation/sick/...) Year number probably means the calendar year stored as an integer. der_leave_cumulative_days_taken means the total of leave actually taken, which would be derived by summing the days ...


0

There is more than one school of thought regarding the relationship between conceptual data modeling and logical data modeling. These schools of thought often result in similar practices, but differences in terminology can be confusing, especially in a formal learning situation. Conceptual data modeling, as I learned it, follows ER modeling as first ...


0

I am with your teacher here. I cannot see any difference in degree of Normalization between the two solutions, but you are embedding aspects of a particular implementation presentation (Two views of what is often referred to as the External or Logical Schema.) into the core data structures. When performing the initial database design (of the Conceptual ...



Top 50 recent answers are included