Identify the functional dependencies represented by the data

Assignment Help Basic Computer Science

Reference no: EM131214126

An agency called Instant Cover supplies part-time/temporary staff to hotels throughout Scotland. The table shown in Figure 8.12 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for every member of staff.

(a) The table shown in Figure 8.12 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.12. 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.12 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: EM131214126

Questions Cloud

Review the qualitative research article you found : Review the qualitative research article you found and identify each of the components of the research design and consider what is present and what is missing. Identify what the authors did to document positionality, reflexivity, and bias.

What is the variance of the distribution : a. On a typical Saturday, how many cars does David expect to sell? b. What is the variance of the distribution? c. What is the standard deviation of the distribution?

Is the business worth pursuing so far : Is the business worth pursuing so far? What market structure have you entered, and why? What can you do to guarantee success in this market? What pricing strategy might you use?

Standard deviation-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.

Identify the functional dependencies represented by the data : Describe and illustrate the process of normalizing the table shown in Figure 8.12 to 3NF. Identify the primary key and, where appropriate, alternate and foreign keys in each table.

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.

User Account

All Pages