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: 438 Weeks Ago, 3 Days 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 08 May 2017 My Price 8.00

Draw a relational schema and diagram the functional

Table 4-5 shows a shipping manifest. Your assignment is as follows:

 

a. Draw a relational schema and diagram the functional dependencies in the relation.

b. In what normal form is this relation?

c. Decompose MANIFEST into a set of 3NF relations.

d. Draw a relational schema for your 3NF relations and show the referential integrity constraints.

e. Draw your answer to part d using Microsoft Visio (or any other tool specified by your instructor).

Answers

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

-----------

Attachments

file 1494243163-Answer.docx preview (206 words )
T-----------abl-----------e 4------------5 -----------sho-----------ws -----------a s-----------hip-----------pin-----------g m-----------ani-----------fes-----------t. -----------You-----------r a-----------ssi-----------gnm-----------ent----------- is----------- as----------- fo-----------llo-----------ws:----------- a-----------. D-----------raw----------- a -----------rel-----------ati-----------ona-----------l s-----------che-----------ma -----------and----------- di-----------agr-----------am -----------the----------- fu-----------nct-----------ion-----------al -----------dep-----------end-----------enc-----------ies----------- in----------- th-----------e r-----------ela-----------tio-----------n. ----------- b.----------- In----------- wh-----------at -----------nor-----------mal----------- fo-----------rm -----------is -----------thi-----------s r-----------ela-----------tio-----------n? ----------- c.----------- De-----------com-----------pos-----------e M-----------ANI-----------FES-----------T i-----------nto----------- a -----------set----------- of----------- 3N-----------F r-----------ela-----------tio-----------ns.----------- d-----------. D-----------raw----------- a -----------rel-----------ati-----------ona-----------l s-----------che-----------ma -----------for----------- yo-----------ur -----------3NF----------- re-----------lat-----------ion-----------s a-----------nd -----------sho-----------w t-----------he -----------ref-----------ere-----------nti-----------al -----------int-----------egr-----------ity----------- co-----------nst-----------rai-----------nts-----------. -----------e. -----------Dra-----------w y-----------our----------- an-----------swe-----------r t-----------o p-----------art----------- d -----------usi-----------ng -----------Mic-----------ros-----------oft----------- Vi-----------sio----------- (o-----------r a-----------ny -----------oth-----------er -----------too-----------l s-----------pec-----------ifi-----------ed
Not Rated(0)