•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
-
Discuss the important role played by users in the process of database design.
(Solved)
Discuss the important role played by users in the process of database design.
Date posted:
July 9, 2018
.
Answers (1)
-
Identify important factors in the success of database design.
(Solved)
Identify important factors in the success of database design.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe the main phases involved in database design.
(Solved)
Describe the main phases involved in database design.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe the purpose of a design methodology.
(Solved)
Describe the purpose of a design methodology.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe what is meant by transitive dependency and describe how this type of dependency relates to 3NF. Provide an example to illustrate your answer.
(Solved)
Describe what is meant by transitive dependency and describe how this type of dependency relates to 3NF. Provide an example to illustrate your answer.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe the characteristics of a table in third normal form (3NF).
(Solved)
Describe the characteristics of a table in third normal form (3NF).
Date posted:
July 9, 2018
.
Answers (1)
-
Describe what is meant by full functional dependency and describe how this type of dependency relates to 2NF. Provide an example to illustrate your answer.
(Solved)
Describe what is meant by full functional dependency and describe how this type of dependency relates to 2NF. Provide an example to illustrate your answer.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe the characteristics of a table in second normal form (2NF).
(Solved)
Describe the characteristics of a table in second normal form (2NF).
Date posted:
July 9, 2018
.
Answers (1)
-
Describe an approach to converting a first normal form (1NF) table to second normal form (2NF) table(s).
(Solved)
Describe an approach to converting a first normal form (1NF) table to second normal form (2NF) table(s).
Date posted:
July 9, 2018
.
Answers (1)
-
What is the minimal normal form that a relation must satisfy? Provide a definition for this normal form.
(Solved)
What is the minimal normal form that a relation must satisfy? Provide a definition for this normal form.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe the characteristics of a table that violates first normal form (1NF) and then describe how such a table is converted to 1NF.
(Solved)
Describe the characteristics of a table that violates first normal form (1NF) and then describe how such a table is converted to 1NF.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe the types of update anomalies that may occur on a table that has redundant data.
(Solved)
Describe the types of update anomalies that may occur on a table that has redundant data.
Date posted:
July 9, 2018
.
Answers (1)
-
Discuss how normalization may be used in database design.
(Solved)
Discuss how normalization may be used in database design.
Date posted:
July 9, 2018
.
Answers (1)
-
Describe how strong and weak entities differ and provide an example of each.
(Solved)
Describe how strong and weak entities differ and provide an example of each.
Date posted:
July 7, 2018
.
Answers (1)
-
Provide an example of a relationship with attributes
(Solved)
Provide an example of a relationship with attributes
Date posted:
July 7, 2018
.
Answers (1)
-
Describe what multiplicity represents for a relationship.
(Solved)
Describe what multiplicity represents for a relationship.
Date posted:
July 7, 2018
.
Answers (1)
-
What are business rules and how does multiplicity model these constraints?
(Solved)
What are business rules and how does multiplicity model these constraints?
Date posted:
July 7, 2018
.
Answers (1)
-
How does multiplicity represent both the cardinality and the participation constraints on a relationship?
(Solved)
How does multiplicity represent both the cardinality and the participation constraints on a relationship?
Date posted:
July 7, 2018
.
Answers (1)
-
Perform addition and subtraction operation on the following two floating point operands. ...
(Solved)
Perform addition and subtraction operation on the following two floating point operands.
A = 0 10001 011011
B = 1 01111 101010
A and B are represented in a 12-bit format. The scale factor has an implied base of 2 and a 5-bit excess-15 exponent. The 6-bit mantissa is normalized as in the IEEE format, with an implied 1 to the left of the binary point.
Date posted:
July 7, 2018
.
Answers (1)
-
Divide 14 by 3 using restoring and non restoring division. Show all the steps. No partial credit will be awarded unless all steps are shown.
(Solved)
Divide 14 by 3 using restoring and non restoring division. Show all the steps. No partial credit will be awarded unless all steps are shown.
Date posted:
July 7, 2018
.
Answers (1)