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

Jane mixer crime scene photos

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

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, the

LOTS relation schema will only be in 1NF because there is a partial dependency

COUNTY_NAME ->TAX_RATE on the secondary key {COUNTY_NAME, LOT#}, which

violates 2NF.

10.24 Prove that any relation schema with two attributes is in BCNF.

10.25 Why do spurious tuples occur in the result of joining the EMP_PROJ1 and

EMPLOCS relations of Figure 14.5 (result shown in Figure 14.6)?

10.26 Consider the universal relation R = {A, B, C, D, E, F, G, H, I} and the set of

functional dependencies F = { {A, B} -> {C}, {A} -> {D, E}, {B} -> {F}, {F} ->

{G, H}, {D} -> {I, J} }. What is the key for R? Decompose R into 2NF, then 3NF

relations.

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:

Custom Coursework Service
Top Academic Tutor
Top Writing Guru
Assignment Guru
Accounting Homework Help
Accounting & Finance Master
Writer Writer Name Offer Chat
Custom Coursework Service

ONLINE

Custom Coursework Service

I have read and understood all your initial requirements, and I am very professional in this task.

$27 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$64 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

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

$63 Chat With Writer
Assignment Guru

ONLINE

Assignment Guru

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

$102 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

I have read and understood all your initial requirements, and I am very professional in this task.

$62 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance 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

$85 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

Client consultation form hairdressing - Solvolysis of 2 bromo 2 methylbutane in acetic acid - Marketing strategy assignment pdf - La camarera te sirvió el plato de pasta con mariscos - Vroom yetton normative model of leadership - Light and plant growth virtual lab - Nutrition care process form - Multiracial feminism becky thompson summary - Psy - 5th grade student council speech - Ernst and young brochure - Hilti firestop installer certification - Rubber mats clark rubber - Communication role play scripts - Become your own financial advisor warren ingram pdf - How to make a dichotomous key for unknown bacteria - Handbook of informatics for nurses and healthcare professionals 6th ed - What is the main problem in the book the crossover - Gomier manufacturing co ltd - I am in blood stepp d in so far - Introduction to cisco networking pdf - How to improve employee productivity in capsim - Limewater test for co2 equation - BI - Why do ketones have a higher boiling point than aldehydes - Haribo nederland b v - DQ1 - Hp storevirtual 4530 end of life - Section 88b conveyancing act - Assignment - Gladiator activities for students - Abiotic and biotic factors in marine ecosystem - As foolish as simile - Current Issues in Accounting - Discussion - Which lightens stains better vinegar or lemon juice science project - Looking glass mirror theory - In gas pump south dakota - W5 Discussions - Matlin, m. w. & thomas a. farmer (2016). cognition (9th ed.). hoboken, nj: wiley. - Christian moral decision making - The dimensions of an open box are 50cm - How to construct a galvanic cell - St george debit card - Bunsen burner chemical reaction - Walking tracks mornington peninsula - What current household products that do not contain microprocessors - Faust prologue in heaven - Fat cow motel dvd - Macbeth act 3 discussion questions answers - Mis case study with question and answers - Eyewitness norwegian english subtitles - Abb synchronous reluctance motor - Measure ee lausd pros and cons - 6 powerpoint slides - Johns hopkins evidence level and quality guide - Damien hirst shark value - Models and theories of planned change - Plant cell analogy amusement park - Edu 555 - Health promotion model manual - Counseling Question - Performance patterns occupational therapy - Hard rock cafe vision statement - The beginning of the song that diverts the heart poem - Why are some foods digestible and others aren t - +91-8306951337 get your love back by vashikaran IN Udaipur - Fire extinguisher safety quiz - Sam weaver proton power - Paper typed - Metals and alloys quiz - Health education east midlands - ASSESSMENT 3 DUE IN 48 HOURS - Problem 6 1a perpetual alternative cost flows lo p1 - Meraki sd-wan design guide - How can marketers use consumer failures at achieving goals - A grocery shopper tosses a 9.0 kg bag - Unisa withdraw without fail - Art Discussion Question - Oxy acetylene safety rules - W10D1 - Monash credit transfer application form - French review and practice - Chapter 4 - 50 x 150 rhs - Films for the humanities & sciences - Sign convention for radius of curvature of lens - Examples of contextual factors in education - National rental affordability scheme wa - Order 2316851: 2 pg. essay on colon cancer, why pt was having the symptoms, gene involved with disease dev. and process of immunosuppression and the effect it has on body systems. - What year did romulus die - 2 pole active low pass filter - International Business- Essay - Reading Report - Snpha national conference 2017 schedule - Download owasp broken web apps - Hobart community legal centre - Enterprise Master Person Identification (EMPI) Policy - Rhyming words ks1 powerpoint - Depth of knowledge definition - Straight line bode plot