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

Property node labview tutorial - Cu.learninghouse.com - The psychology of the blind side worksheet answers - Research paper 6pages - Ezproxy liberty 2048 login - Fbla competitive events guidelines - Pick one of the following terms for your research: Balanced scorecard, ethical leadership, emotional intelligence, sustainability, or authentic leadership. - Just a dream chris van allsburg activities - Brunel university india office - Elephant and piggie we are in a book - Market risk is measured by - Squatty potty bed bath and beyond video - List of composite numbers - Calcium carbonate reaction with hydrochloric acid - Johnson and johnson case study - Import revit model into revit - I do not ask the wounded person how he feels - Market segmentation uber - Application Security PCA - Fall of humanity then and now worksheet - Five levels of decision making - Examples of self discipline in the bible - Elder scrolls online woodworker survey - Essentials of negotiation lewicki 5th edition pdf - Jotting observation early childhood examples - Yoplait commercial mom on - A silver thorn a bloody rose - Organizational culture readiness for implementation of ebp survey - Penn foster music appreciation final exam - Describe the organizational structure of abco corporation - Chapter 25 electromagnetic induction answers - Numerical methods matlab 3e asu - Bmi chelsfield park hospital - Team Paper - Marketing - 40 mcg to mg - Assessment of Oral Language Proficiency - Religion in heart of darkness - Distinctive competencies of under armour - The worksheet for booth company shows the following in the financial statement columns: - OPS/350 WK5 FLOWCHART FOR PROCESSES - Forest hill college ranking - Smoke wizard century 3 mall - 600 words minimum, apa format, discussion question - Yogita limaye kashmir - UNIT IV ASSGNMNT MBA 6601 - Does graphene conduct electricity - BUSN603 - Call pickup group notification timer - Introduction to the field of organizational behavior chapter 1 - Bankwest children's savings account - Google maps scale ratio - English Composition I - Surface area of oblique pyramid - Application to general manager - Faraday ice pail and charge production lab report - Heat of solution lab report answers - Royal hobart hospital endocrinology - One canada square floors - No smtp server specified for the cfmail tag - Growth pole theory in regional planning ppt - Shaun tan lost thing - Kfc in china case study - The secrets of vesuvius lesson plans - Sustainable growth rate formula example - Political Science Assignment Week 3 - Disanthus cercidifolius common name - International business case study with solution - Emerging adulthood cognitive development - Textbook summary ( 4pages summary ) - English - A virtuous woman proverbs 31 - Verizon wireless value chain - Vce physics formula sheet 2019 - Mighty safe fire alarm is currently buying - Weekly Discussion 4 - Prepare a budgeted balance sheet as of may 31 - How was the medieval motet different from the renaissance motet - W3F - Netflix com los gatos caus charge - 1950s pop culture worksheet answers - Characteristics of an agile mis infrastructure - Give me liberty an american history 6th edition pdf - Endeavor air safety record - A roulette wheel has 38 slots around the rim - What is a market product grid - Knowledge Management Systems 2-3 pages Essay - Current issues in accounting - What is the context of a research paper - Climate technology centre and network - W9fore - Probability and statistical inference 9 pdf - Centre for clinical interventions - Business proposal memorandum - Esko kongsberg x starter price - I am legend free book - Batch and interactive operating system - SELF REFLECTION ESSAY FOR A ADVANCE NURSE PRACTITIONER CLASS. - Jetblue case study analysis - Group therapy