Question

3. Describe three errors in the following database design. Personal Contact Database Id# Name 101. Jane S Smith 102 Bill Williams Address 123 Main St, Mytown, WA, 12345, USA 234 Fifth Ave, Beeville, NY, 23456, USA | Id# 101. 102 Name Jane S Smith Bill Williams Phone1 | Type1 | Phone2 | Type2 | Phone3 | Type3 5551232 | Mobile | 5552323 | Work 5558293 Home 5559923 Work 4. Which statements about workload and throughput are true? a. Throughput can be less than workload. b. Workload can be less than throughput. c. Normally, throughput will equal workload. d. Throughput is the inverse of workload.

Answer 1

The tables are not normalized

In table 1, the address can be split up into several other fields to make it to 1NF and if the address data is unique over zip or pin code then it can be further decomposed.
In table 2,the redundant information "name" is stored, which is unnecessary as it is already store in table 1. The data 1. phone1, type1; 2. phone2, type2 and 3. phone3 and type3 may have null data. It is not not needed to have data in this structure, instead the schema can be Given as ID, Phone, Type.

Throughput and workload

Throughput can be less than workload.

Generally throughput and workload varies proportionally till certain resource limit. Once the resource is exhausted then the throughput saturates but the workload can still grow.

Normally, throughput will equal workload

As discussed above the throughput will be equal to workload till certain limit is reached.

**please upvote if you like the answer. Thank you