Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 439 Weeks Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Computer Science Posted 13 May 2017 My Price 7.00

An agency called Instant Cover supplies part-time

On completion of Exercise 13.16 examine the 3NF relations created to represent the attributes shown in the relation displaying employee contract data for an agency called Instant Cover in Figure 13.20. Determine whether these relations are also in BCNF. If not, transform the relations that do not conform into BCNF.

Exercise 13.16:

An agency called Instant Cover supplies part-time/temporary staff to hotels within Scotland. The table shown in Figure 13.20 displays sample data, which lists the time spent by agency staff working at various hotels. The National Insurance Number (NIN) is unique for every member of staff.

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

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

(c) Describe and illustrate the process of normalizing the table shown in Figure 13.20 to 3NF. Identify primary, alternate and foreign keys in your relations.

 

Answers

Alpha Geek
(8)
Status NEW Posted 13 May 2017 08:05 AM My Price 7.00

-----------

Attachments

file 1494664820-Answer.docx preview (251 words )
O-----------n c-----------omp-----------let-----------ion----------- of----------- Ex-----------erc-----------ise----------- 13-----------.16----------- ex-----------ami-----------ne -----------the----------- 3N-----------F r-----------ela-----------tio-----------ns -----------cre-----------ate-----------d t-----------o r-----------epr-----------ese-----------nt -----------the----------- at-----------tri-----------but-----------es -----------sho-----------wn -----------in -----------the----------- re-----------lat-----------ion----------- di-----------spl-----------ayi-----------ng -----------emp-----------loy-----------ee -----------con-----------tra-----------ct -----------dat-----------a f-----------or -----------an -----------age-----------ncy----------- ca-----------lle-----------d I-----------nst-----------ant----------- Co-----------ver----------- in----------- Fi-----------gur-----------e 1-----------3.2-----------0. -----------Det-----------erm-----------ine----------- wh-----------eth-----------er -----------the-----------se -----------rel-----------ati-----------ons----------- ar-----------e a-----------lso----------- in----------- BC-----------NF.----------- If----------- no-----------t, -----------tra-----------nsf-----------orm----------- th-----------e r-----------ela-----------tio-----------ns -----------tha-----------t d-----------o n-----------ot -----------con-----------for-----------m i-----------nto----------- BC-----------NF.----------- E-----------xer-----------cis-----------e 1-----------3.1-----------6: ----------- An----------- ag-----------enc-----------y c-----------all-----------ed -----------Ins-----------tan-----------t C-----------ove-----------r s-----------upp-----------lie-----------s p-----------art------------ti-----------me/-----------tem-----------por-----------ary----------- st-----------aff----------- to----------- ho-----------tel-----------s w-----------ith-----------in -----------Sco-----------tla-----------nd.-----------
Not Rated(0)
Relevent Questions