What are multivalued attributes, and how can they be handled within the database design?
As the name implies, multi-valued attributes may have many values. For example, a person’s education may include a high school diploma, a 2-year college associate degree, a four-year college degree, a Master’s degree, a Doctoral degree, and various professional certifications such as a Certified Public Accounting certificate or a Certified Data Processing Certificate. There are basically three ways to handle multi-valued attributes, and two of those three ways are bad: 1. Each of the possible outcomes is kept as a separate attribute within the table. This solution is undesirable for several reasons. First, the table would generate many nulls for those who had minimal educational attainments. Using the preceding example, a person with only a high school diploma would generate nulls for the 2-year college associate degree, the four-year college degree, the Master’s degree, the Doctoral degree, and for each of the professional certifications. In addition, how many professional certificati
Related Questions
- What is the relationship between a database and an information system, and how does this relationship have a bearing on database design?
- What is the relationship between a database and an information system, and how does this relationship have a bearing on database design?
- What are multivalued attributes, and how can they be handled within the database design?
- Can someone tell me about Database Administrator?? What type of job is it?
- What are tha major benefits of the database approach?
- What are tha major benefits of the database approach?
