You work as the Enterprise application developer at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers in the domain run Windows Server 2003. Your responsibilities at Domain.com include the design and development of applications. Domain.com operates as an Independent Electoral Commission. You are currently developing a voter registration application for Domain.com. Following is a list of the facts that must be taken into account:
1. A voter is associated with one political party.
2. A voter has one mailing address.
3. A mailing address can belong to multiple voters.
4. It is estimated that on average each mailing address can be used by two voters.
5. A voter has two telephone contact numbers.
6. A contact phone number can belong to multiple voters.
7. It is estimated that on average each contact phone number can be used by two voters.
The plan is to design the database schema based on these facts. Now you need to decide on the minimum number of tables that will be required. In your solution you must ensure that it offers the best performance.
What should you do? (Choose the correct amount of tables required.)
A.
1
B.
2
C.
3
D.
4
Explanation:
A single table will suffice in this scenario. You will be able to store all the voters’ mailing addresses, political party affiliation and telephone contact numbers. It will however result in a renormalization of the database, but it will offer the best performance since it offers better performance than a normalized database. In a normalized database only an average of two voters are associated with the same addresses and telephone contact numbers.
Incorrect answers:
B, C, D: Creating more than one table will result in normalization of the database, but it would not offer the best performance.