Describe and illustrate the process of normalizing

Assignment Help Basic Computer Science

Reference no: EM131214121

The table shown in Figure 8.11 lists dentist/patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day.

(a) The table shown in Figure 8.11 is susceptible to update anomalies. Provide examples of insertion, deletion, and modification anomalies.

(b) Identify the functional dependencies represented by the data shown in the table of Figure 8.11. State any assumptions you make about the data shown in this table.

(c) Describe and illustrate the process of normalizing the table shown in Figure 8.11 to 3NF. Identify the primary key and, where appropriate, alternate and foreign keys in each table.

(d) Demonstrate that the functional dependencies identified in part (b) are present in the 3NF tables described in part (c).

Reference no: EM131214121

Questions Cloud

Define a new random variable : Suppose you have a distribution, X, with mean = 29 and standard deviation = 6. Define a new random variable Y = 4X - 5. Find the mean and standard deviation of Y.

Write report on the supply and demand of coal : B01BECO107 Business Economics Assignment - Report Writing. You are to write a 1500 words report on the supply and demand of coal. The price of coal is determined by supply and demand. The price of coal has dropped to half now compared to its peak pr..

What is the equilibrium level of automobile tire production : What is the equilibrium level of automobile tire production? What is the socially optimal quantity? What is the underlying economic intuition for the difference in your answers for part (a) and part (b) above?

Review the fundamentals of qualitative research methods : What also becomes evident is your position with respect to the topic, the question, and what you hope to find. Qualitative research recognizes that the research "space" is shaped by both the participants and the researcher.

Describe and illustrate the process of normalizing : Identify the functional dependencies represented by the data shown in the table of Figure 8.11. State any assumptions you make about the data shown in this table.

Best strategy for player : A and B play a game in which each has 3 coins a 5p, a 10p and a 20p respectively.- Each selects a coin without the knowledge of the others choice. If the sum of the coins is an odd amount A win's B's coins. If the sum is even B wins A's coin. Find..

Males and females have equal levels of education : Using statistics software determine whether or not males and females have equal levels of education. The required variable is EDUC with the frequencies procedure with the frequencies procedure to produce frequency tables and the mean median, and ..

What is the throughput through the atm annually : If annual demand is 12,000 units, the ordering cost is $6 per order, and the holding cost is $2.50 per unit per year, which of the following is the optimal order quantity using the fixed-order-quantity model (EOQ)?

Calculate the overhead allocation rate : ABC Ltd makes trailers. It receives a special order to produce 350 trailers for a local retail outlet. Calculate the overhead allocation rate: note that the process is labour-intensive

User Account

All Pages