Question

Now that suggestions on potential types of databases are considered, Park University wants to now understand more on suggestions you may have designed/planning a model for the payroll database. Park University has requested information and has asked you to address the following questions and would really like to see a sketched draft of the logical model: When thinking about various stages of modeling for this payroll database, why is it important to go through three phases of modeling including the conceptual, logical, and physical models. Defend your answer in scholarly detail comparing each of the models on purpose and their importance!! Will the various stages of modeling help the designer, applications programmer, and user communicate more effectively and efficiently? Defend your answer in scholarly detail!! Not at this point is concerned with the physical model, what are some potential entities at this point to support the conceptual model? Defend your answer in scholarly detail!! Going even further, what are some attributes of these entities expanding into thoughts of the logical model? Defend your answer in scholarly detail!! Include any other important conclusions or content you see fit to support this assignment.

Answer 1

In this case it's logical model, and it includes three phases, they are conceptual, logical and physical model.

Above shown fig represents the logic model and its phases.

These phases are interlinked with one another and are very critical hence able to communicate effectively to the programmers, engineers, designers and all other technological experts.

The conceptual is normally supported by the variables and actions in this case the model above is supported by the phases and each phase has its own components and processes.

The entities include; the variables, the activities taking place, the input, outputs and processes.