Get premium membership and access questions with answers, video lessons as well as revision papers.

Discuss the main activities associated with each step of the logical database design methodology

      

Discuss the main activities associated with each step of the logical database design methodology

  

Answers


KELVIN
•In Step 1 we create a data model and check that the data model has minimal redundancy and is capable of supporting user transactions. The output of this step is the creation of a logical data model, which is a complete and accurate representation of the company (or part of the company) that is to be supported by the database.
•In Step 2 we map the ER model to a set of tables. The structure of each table is checked using normalization. Normalization is an effective means of ensuring that the tables are structurally consistent, logical, with minimal redundancy. The tables are also checked to ensure that they are capable of supporting the required transactions. The required integrity constraints on the database are also defined.

kalvinspartan answered the question on July 9, 2018 at 19:12


Next: Discuss the important role played by users in the process of database design.
Previous: Discuss the purpose of Step 1 of logical database design.

View More Computer Science Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions