Describe how a database designer typically identifies the set of functional dependencies associated with a relation.
What will be an ideal response?
Identifying all functional dependencies between a set of attributes should be relatively simple
if the meaning of each attribute and the relationships between the attributes are well
understood. This type of information may be provided by the enterprise in the form of
discussions with users and/or appropriate documentation such as the users’ requirements
specification. However, if the users are unavailable for consultation and/or the documentation
is incomplete then depending on the database application it may be necessary for the database
designer to use their common sense and/or experience to provide the missing information.
As a contrast to this, consider the situation where functional dependencies are to be identified
in the absence of appropriate information about the meaning of attributes and their
relationships. In this case, it may be possible to identify functional dependencies if sample
data is available that is a true representation of all possible data values that the database may
hold.
You might also like to view...
A(n) ________ is movement applied to an object or text and is viewable in Slide Show view
Fill in the blank(s) with correct word
When working with customers, you should always try to keep a positive attitude. Why is it important to maintain a positive attitude when working with customers?
A. Helps to establish a good customer relationship. B. Helps the customer feel confident you can fix the problem. C. Shows that you have the knowledge needed to fix the problem. D. Helps you to be more reliable.
A technician is replacing a processor that is attached parallel to the motherboard. Which of the following processor types is needed?
A. Pin grid array processor B. Slot 2 processor C. Socket to slot adapter D. Slot 1 processor
Configuration information in Windows systems is centralized in the _______, which forms a database of keys and values.
Fill in the blank(s) with the appropriate word(s).