An agency supplies part-time/temporary staff to hotels. The table shown in the figure below displays sample...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An agency supplies part-time/temporary staff to hotels. The table shown in the figure below displays sample data, which lists the time spent by agency staff working at various hotels. The national insurance number (NIN) is unique for every staff. The relation in the table below is already a INF. Please describe and draw the relations/tables for the 2NF and 3NF, respectively [5.5 points]. Identify primary keys for each relation/table in INF, 2NF and 3NF [2 points). Assumptions: ● ● . . . The national insurance number (NIN) is unique for every staff. Multiple staff can be hired under the same contract. Only one hotel can appear in one contract. It s possible for two persons to have the same name. It s possible for two hotels to have the same address. NIN ContractNo 1135 C1024 1057 C1024 1068 C1025 1135 C1025 Hours StaffName Smith J 16 24 Hocine Di 28 White T 15 Smith J HotelNo H25 H25 H4 H4 HotelLocation East Kilbride East Kilbride Glasgow Glasgow An agency supplies part-time/temporary staff to hotels. The table shown in the figure below displays sample data, which lists the time spent by agency staff working at various hotels. The national insurance number (NIN) is unique for every staff. The relation in the table below is already a INF. Please describe and draw the relations/tables for the 2NF and 3NF, respectively [5.5 points]. Identify primary keys for each relation/table in INF, 2NF and 3NF [2 points). Assumptions: ● ● . . . The national insurance number (NIN) is unique for every staff. Multiple staff can be hired under the same contract. Only one hotel can appear in one contract. It s possible for two persons to have the same name. It s possible for two hotels to have the same address. NIN ContractNo 1135 C1024 1057 C1024 1068 C1025 1135 C1025 Hours StaffName Smith J 16 24 Hocine Di 28 White T 15 Smith J HotelNo H25 H25 H4 H4 HotelLocation East Kilbride East Kilbride Glasgow Glasgow
Expert Answer:
Related Book For
Database Systems A Practical Approach to Design Implementation and Management
ISBN: 978-0132943260
6th Edition Global
Authors: Thomas Connolly, Carolyn Begg
Posted Date:
Students also viewed these databases questions
-
Identify and describe the components of the table shown in Figure Q3.17, using correct terminology. Use your knowledge of naming conventions to identify the tables probable foreignkey(s). EMP NUM |...
-
If you have the following information: Sales 400.000. sales returns 40.000, purchases 40.000. purchase expenses 20,000, beginning merchandise 10,000. ending merchandise 25.000, selling expenses...
-
The table shown in Figure 14.19 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...
-
Gray Corporation began operations on January 1, 2017. The following information is available for Gray Corporation on December 31, 2017. Prepare an income statement, a retained earnings statement, and...
-
Researchers were interested in the stability of a drug product stored for four lengths of time (1, 3, 6, and 9 months). The drug was manufactured with 30 mg/ mL of the active ingredient of a drug...
-
The Consumer Price Index (CPI) tracks the prices of consumer goods in the United States, as shown in the following table. The CPI is reported monthly, but we can look at selected values. The table...
-
Use the Neumann analysis to determine stability properties of the scheme applied to the linear convection equation \(u_{t}+c u_{x}=0\), where \(c\) is a positive constant. -u At u - u -1 +c = 0 .
-
Willow Turenne Company had the following adjusted trial balance.Instructions(a) Prepare closing entries at June 30, 2012.(b) Prepare a post-closing trialbalance. WILLOW TURENNE COMPANY Adjusted Trial...
-
The following transactions occurred for the month of May in the business of Henry Hofstra: May 1 Henry invested capital amounting to $990,000 in his business. The amount was duly lodged to the bank...
-
Find the equilibrium concentration of defects for T = 0, 200, 400, 600, 800, 1000, and 1200 K if the energy to form a defect is 1 eV/atom. Assume A is unity. Graph your results. For T = 1200 K, how...
-
8. Acid rain is caused by the reaction of nonmetal oxides with water in the atmosphere. One such reaction involves nitrogen dioxide (NO) and produces nitric acid (HNO3): 3NO2 + HO 2HNO3 + NO If 1.82...
-
Briefly describe three security functions performed by a port-protection device.
-
Briefly distinguish between a multicomputer architecture and a multiprocessor architecture. What is the primary purpose of using these types of architectures when machines are built?
-
Explain what is meant by a dual-purpose test. Give an example of one.
-
Briefly explain the process of rolling back the database using beforeimages of the records in the database. Why is it necessary to take beforeimages of records in a list file that are moved because...
-
Briefly explain the nature of the following types of operating system penetration techniques: a. Browsing b. Piggybacking c. Trojan horse
-
Staffing & Employment Functions - Discussion Questions ???? . wk11 Answer Chapter 9 Discussion questions 2 & 5 Should be one full page ?? your ideas - not cut and pste Q. 2 Discuss the advan...
-
Use of the contraceptive Depo Provera appears to triple women's risk of infection with chlamydia and gonorrhea , a study reports today. An estimated 20 million to 30 million women worldwide use Depo...
-
Of the facilities described in your answer to Question 2.5, which ones do you think would not be needed in a standalone PC DBMS? Provide justification for your answer.
-
Study the DreamHome case study presented in Section 11.4 and Appendix A. (a) In what ways would a DBMS help this organization? (b) What do you think are the main objects that need to be represented...
-
In Section 24.5.1 when discussing naming transparency, we proposed the use of aliases to uniquely identify each replica of each fragment. Provide an outline design for the implementation of this...
-
Show that for \(g\) and \(h\) analytic functions at \(z_{0}\), with \(g\left(z_{0} ight) eq 0, h\left(z_{0} ight)=0\), and \(h^{\prime}\left(z_{0} ight) eq 0\),...
-
Show that \[\int_{C} \frac{d z}{(z-1-i)^{n+1}}=\left\{\begin{array}{cc} 0, & n eq 0 \\ 2 \pi i, & n=0 \end{array} ight.\] for \(C\) the boundary of the square \(0 \leq x \leq 2,0 \leq y \leq 2\)...
-
For the following, determine if the given point is a removable singularity, an essential singularity, or a pole (indicate its order). a. \(\frac{1-\cos z}{z^{2}}, \quad z=0\). b. \(\frac{\sin...
Study smarter with the SolutionInn App