Your hypothetical employer, ABC University, continues to be very pleased with your feedback and documentation on initial modeling efforts to support the new and coming payroll database. So far in this effort, the University has come to the realization that although the word databases or data management sounds simple, the simplicity quickly becomes a critical and even strategic process which requires careful thought at both the critical and analytical levels.

Now that suggestions for both entities and attributes have been identified and considered to support conceptual and logical models, ABC University wants to go further into the development of these models more into areas of understanding database keys, table relationships, normalization and data dictionaries. ABC University has requested information and has asked you to address the following questions:

Based on the thoughts and suggested logical model for the payroll database, what ideas do you have currently about mapping cardinalities. Based on these relationships, what ideas did you use for primary and foreign keys to relate tables suggested and could there be instances where tables could have composite or multiple field keys? Defend your answer

Based on the thoughts of both the logical and even physical models in this case, what ideas do you have currently about normalization. Going even further with aspects and theory of database normalization, would there be any reasons in this case to go beyond the 3rd normal form toward the Boyce-Codd Normal Form? Defend your answer