-
Describe two approaches to checking that a logical data model supports the transactions required by the user.
Date posted:
July 9, 2018
-
Discuss an approach to checking a data model for redundancy. Give an example to illustrate your answer.
Date posted:
July 9, 2018
-
Discuss an approach to identifying attributes from a users’ requirements specification and the association of attributes with entities or relationships.
Date posted:
July 9, 2018
-
Discuss an approach to identifying entities and relationships from a users’ requirements specification.
Date posted:
July 9, 2018
-
Identify the main tasks associated with Step 1 of logical database design.
Date posted:
July 9, 2018
-
Discuss the purpose of Step 1 of logical database design.
Date posted:
July 9, 2018
-
Discuss the main activities associated with each step of the logical database design methodology
Date posted:
July 9, 2018
-
Discuss the important role played by users in the process of database design.
Date posted:
July 9, 2018
-
Identify important factors in the success of database design.
Date posted:
July 9, 2018
-
Describe the main phases involved in database design.
Date posted:
July 9, 2018
-
Describe the purpose of a design methodology.
Date posted:
July 9, 2018
-
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
-
Describe the characteristics of a table in third normal form (3NF).
Date posted:
July 9, 2018
-
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
-
Describe the characteristics of a table in second normal form (2NF).
Date posted:
July 9, 2018
-
Describe an approach to converting a first normal form (1NF) table to second normal form (2NF) table(s).
Date posted:
July 9, 2018
-
What is the minimal normal form that a relation must satisfy? Provide a definition for this normal form.
Date posted:
July 9, 2018
-
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
-
Describe the types of update anomalies that may occur on a table that has redundant data.
Date posted:
July 9, 2018
-
Discuss how normalization may be used in database design.
Date posted:
July 9, 2018
-
Describe how strong and weak entities differ and provide an example of each.
Date posted:
July 7, 2018
-
Provide an example of a relationship with attributes
Date posted:
July 7, 2018
-
Describe what multiplicity represents for a relationship.
Date posted:
July 7, 2018
-
What are business rules and how does multiplicity model these constraints?
Date posted:
July 7, 2018
-
How does multiplicity represent both the cardinality and the participation constraints on a relationship?
Date posted:
July 7, 2018
-
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
-
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
-
Multiply the following pair of signed 2’s complement numbers using the Booth algorithm. Assume A is the multiplicand and B is the multiplier. Show all the steps. No partial credit will be awarded unless all steps are shown.
A = 010111, B = 110110
Date posted:
July 7, 2018
-
1. Convert the following numbers:
(a) –347 into 2’s complement binary
(b) 243.124 into floating point form.
Date posted:
July 7, 2018
-
Discuss the purpose of analyzing the transactions that have to be supported and describe the type of information you would collect and analyze.
Date posted:
July 4, 2018