Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Partial key dependencies

26/03/2021 Client: saad24vbs Deadline: 2 Day

Home>Mathematics homework help
CHAPTER 10: FUNCTIONAL DEPENDENCIES AND NORMALIZATION FOR RELATIONAL DATABASES

Answers to Selected Exercises

15.19 Suppose we have the following requirements for a university database that is

used to keep track of students transcripts:

(a) The university keeps track of each student's name (SNAME), student number

(SNUM), social security number (SSSN), current address (SCADDR) and phone

(SCPHONE), permanent address (SPADDR) and phone (SPPHONE), birthdate

(BDATE), sex (SEX), class (CLASS) (freshman, sophomore, ..., graduate),

major department (MAJORDEPTCODE), minor department (MINORDEPTCODE)

(if any), and degree program (PROG) (B.A., B.S., ..., Ph.D.). Both ssn and

student number have unique values for each student.

(b) Each department is described by a name (DEPTNAME), department code

(DEPTCODE), office number (DEPTOFFICE), office phone (DEPTPHONE), and

college (DEPTCOLLEGE). Both name and code have unique values for each

department.

(c) Each course has a course name (CNAME), description (CDESC), code number

(CNUM), number of semester hours (CREDIT), level (LEVEL), and offering

department (CDEPT). The value of code number is unique for each course.

(d) Each section has an instructor (INSTUCTORNAME), semester (SEMESTER), year

(YEAR), course (SECCOURSE), and section number (SECNUM). Section numbers

distinguish different sections of the same course that are taught during the same

semester/year; its values are 1, 2, 3, ...; up to the number of sections taught

during each semester.

(e) A transcript refers to a student (SSSN), refers to a particular section, and

grade (GRADE).

Design an relational database schema for this database application. First show all

the functional dependencies that should hold among the attributes. Then, design

relation schemas for the database that are each in 3NF or BCNF. Specify the key

attributes of each relation. Note any unspecified requirements, and make

appropriate assumptions to make the specification complete.

10.18 Prove or disprove the following inference rules for functional dependencies. A

proof can be made either by a proof argument or by using inference rules IR1 through IR3. A disproof should be done by demonstrating a relation instance that satisfies the conditions and functional dependencies in the left hand side of the inference rule but do not

satisfy the conditions or dependencies in the right hand side.

(a) {W ->Y, X ->Z} |= {WX ->Y }

(b) {X ->Y} and Z subset-of Y |= { X ->Z }

(c) { X ->Y, X ->W, WY ->Z} |= {X ->Z}

(d) {XY ->Z, Y ->W} |= {XW ->Z}

(e) {X ->Z, Y ->Z} |= {X ->Y}

(f) {X ->Y, XY ->Z} |= {X ->Z}

10.19 Consider the following two sets of functional dependencies F= {A ->C, AC ->D,

E ->AD, E ->H} and G = {A ->CD, E ->AH}. Check whether or not they are

equivalent.

10.22 What update anomalies occur in the EMP_PROJ and EMP_DEPT relations of

Figure 14.3 and 14.4?

10.23 In what normal form is the LOTS relation schema in Figure 10.11(a) with the

respect to the restrictive interpretations of normal form that take only the

primary key into account? Will it be in the same normal form if the general

definitions of normal form were used?

Answer:

If we only take the primary key into account, the LOTS relation schema in Figure 14.11

(a) will be in 2NF since there are no partial dependencies on the primary key .

However, it is not in 3NF, since there are the following two transitive dependencies on

the primary key:

PROPERTY_ID# ->COUNTY_NAME ->TAX_RATE, and

PROPERTY_ID# ->AREA ->PRICE.

Now, if we take all keys into account and use the general definition of 2NF and 3NF, t

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Finance Homework Help
Peter O.
Top Writing Guru
Accounting & Finance Mentor
Coursework Help Online
Homework Master
Writer Writer Name Offer Chat
Finance Homework Help

ONLINE

Finance Homework Help

I will cover all the points which you have mentioned in your project details.

$43 Chat With Writer
Peter O.

ONLINE

Peter O.

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$21 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

Give me a chance, i will do this with my best efforts

$53 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$57 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$38 Chat With Writer
Homework Master

ONLINE

Homework Master

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$68 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Aaa office world case study - What is the domain of an exponential function - Labeled parts of a microscope - List of ee cummings poems - Do my criminal justice homework - Run highlighted code matlab - Bhopal gas tragedy case study summary - Polytechnic west student login - L houts plastics is a large manufacturer - Offer in business law ppt - Monash safe exam browser - Is there a recycler at ranch - My personal leadership philosophy paper - Fire hydrant paint specification - The silver sword characters - History ask questions get answers - Are arbonne fizz sticks healthy - Powder by tobias wolff answers - Cloud computing - Provider connections early intervention - Darwin river dam level - "A" WORK DISCUSSION IN 18 HOURS - What is beauty care in tle - Braillenote touch plus user guide - Social penetration theory movie examples - Bromination of acetone rate law - CJ paper - Discussion: Eisikovitz & Buchbinder: Pathways to Disenchantment - Https childmind org article social media and self doubt - Away from home rate youth allowance - Alkaline water ionizer comparison - Regional airline business plan - Bus adelaide to mt gambier - Three beads are placed along a thin rod - East renfrewshire u3a groups - Section 17.4 sound and hearing - Marketing plan part 1 - Ikea vidga rail triple track - Alleluia vidimus stellam texture - Ivy lee contributions to public relations - The bear by anton chekhov questions - Use of potassium hydroxide in vanishing cream - Iq oq pq example report - Club med annual report 2013 - END SEMESTER - How to write a siop lesson plan - Need a one page discussion - Micro-Econ Essay - The great depression by mike kubic - Dq 1 - The hanging stranger essay - Meet the student teacher template - Selectively reflective and inconsistently fair describe which level of thinking - Gas dataset in forecast package - Australian unity no gap dental - Kepnock state high school - Unit 5 IP PC - The lady tasting tea pdf free - Extra baggage cost pia - Amc 8 time limit - What are the functions and importance of capital market - Business law chapter 8 test - John f kennedy inaugural address worksheet answers - Please someone answer those questions for me - University of wyoming weather soundings - Weighted average calculator for payroll - Simulation the tortoise and the hare java - Blondie heart of glass guitar lesson - Rock mechanics questions and answers - Accommodations for diverse learners - Tupperware replacement parts catalog 2019 - Discussion (min. of 100 words) - Discussion- Hero In Film - Writing assignment - Stem and leaf plot questions grade 9 - Emmett till essay example - Flight paramedic job description - This is how you do it kid the inventorpreneur's handbook - Monster Essay - Product life cycle assignment - Need 4 page report on marketing a restaurant. APA methodology. No Plagiarism - Wk 2 reply 2 international problems - Covalent bonding examples worksheet - Literature review - Four pages question answer. - 3 types of qualitative research - Judeo christian and greco roman perspectives answers - Little hans case study - Allergy to zinc sunscreen - Marketing communications discovery creation and conversations ebook - Pledge of allegiance essay - What is random assignment in psychology - Dr robert cheng macquarie - Essay--psychological intervention - 3 pages done - How to evacuate a patient who is bed bound - Health management - Data screening and transformation - Dsdm agile practitioner exam - Psychographic segmentation of domino's pizza