Engineering College

AID ALname AFname 10 Gold Josh 24 Shippen Mary 32 Oswan Jan Ainst Sleepy 106 Hollow U 102 104 Green Lawns U 106 Middlestate 126 College 180 102 BNbr BName JavaScript and HTMLS Quick Mobile Apps Innovative Data Management JavaScript and HTML5 Networks and Data Centers Server Infrastructure Quick Mobile Apps BPublish PubCity Wall & Chicago, IL Vintage Gray Boston, MA Brothers Smith Dallas, TX and Sons Wall & Indianapolis, IN $62.75 Vintage Grey Boston, NH Brothers Boston, MA Gray Brothers Gray Brothers Boston, MA BPrice AuthBRoyalty $62.75 $6.28 $49.95 $2.50 $158.65 $15.87 $6.00 $250.00 $12.50 $122.85 $12.30 $45.00 $2.25 Identify partial functional dependencies in Publisher Database. Represent the functional dependency as follows: Determinants --> Attributes e.g., D1--> A1, A2 (A1 and A2 functionally depend on D1) e.g., D2, D3--> A3, A4, A5 (A3, A4 and A5 functionally depend on D2 and D3) Identify transitive functional dependencies in Publisher Database. Represent the functional dependency as follows: Determinants --> Attributes e.g., D1--> A1, A2 (A1 and A2 functionally depend on D1) e.g., D2, D3 --> A3, A4, A5 (A3, A4 and A5 functionally depend on D2 and D3) AID: author ID ALname: author last name AFname: author first name Alnst: author institution BNbr: book number BName: book name BPublish: book publisher PubCity: publisher city BPrice: book price AuthBRoyalty: royalty The primary key is AID + BNbr

Answers

Answer 1

The partial functional dependencies and transitive functional dependencies are AID, BNbr, ALname, AFname, Alnst, BName, BPublish, PubCity, and AuthBRoyalty.

Functional dependency in the database means that if the value of one attribute determines the value of another attribute, then it is said to be a functional dependency. Let's identify the functional dependencies in the Publisher database.Partial Functional Dependencies in the Publisher Database are given below:BNbr --> BName (BName functionally depends on BNbr)ALname, AFname --> Alnst (Alnst functionally depends on ALname and AFname)BPublish --> PubCity (PubCity functionally depends on BPublish)BNbr --> BPublish (BPublish functionally depends on BNbr)BPrice --> AuthBRoyalty (AuthBRoyalty functionally depends on BPrice)Transitive Functional Dependencies in the Publisher Database are given below:ALname --> AID (AID is transitively dependent on ALname)BNbr --> BPrice (BPrice is transitively dependent on BNbr)BPublish --> BName (BName is transitively dependent on BPublish)

Thus, we have identified the partial and transitive functional dependencies in the Publisher database.

To know more about  partial functional dependencies visit:

brainly.com/question/32799128

#SPJ11

Related Questions

Other Questions
A certain llquid X has a normal freezing point of 6.50 C and a freezing point depression constant K f=2.68 " Ckg 'mol 1. Calculate the freezing point of a solution made of 42.2 g of potassium bromide (KBr) dissolved in 500 . g of X. Round your answer to 3 significant digits. How does individual change, team change, and organizational change play into this case?What could Daisy have learned through leading change? How could she have achieved better buy-in and institutionalized a faster recruitment process?What role would a change agent play? The beliefs included in this diagram apply to:- Reincarnation Karma Caste systemA. both Hinduism and Buddhism.B. Hinduism, but not Buddhism.C. Buddhism, but not Hinduism.D. neither Hinduism nor Buddhism. I think it's either B or A Remaining 1 hour, 5 minut O Question Completion Statu 120 & Moving to another question will save the response Question 13 p You buy a stock for $45 per share and sell her $51 after holding it for sighty over a year and collecting a 56.6 por share dvblent dibend im is tased at a 20% rate and capital gas ar at 24%, what is your after tax holding period retum? (White your answer in percentage and round 8 to 2 Moving to another question will save this response NG FRE 1 nour, 42 minutes, 43 seconds. " 10 13 Moving to another question will save this response N Question 13 2 You buy a stock for $40 per share and sell it for $51 after holding it for slightly over a year and collecting a $5.6 per share dividend dividend income in tened at a 20% ce and cia ga at 24%, what is your after tax holding period reum? (Wite your answer in percentage and round 2 decimal places) Moving to another question will save this response. Question Completion Statu 11 Read about the Great Lakes Compact made between the states, indigenous nations and Canadian provinces bordering the Great Lakes. It prohibits water consumption (they call it water diversion).Why do you think they would allow water withdrawals but not allow water consumption? Given that approximately 30 ; of the Earth's surface is above sea level today, provide an estimate of the precentage of the Earth's surface would have been above sea level at the time of supericontinent Pangaea (which we will learn about in chapter 3 ) when sea level may tiave been 300 meters higher than it is today. along with alcoholics and depressant users, a person who uses this type of drug is likely to experience amotivational syndrome? Find the area bounded by \( y=\frac{x-16}{x^{2}-1 x-30}, x=3, x=4 \), and \( y=0 \). (Round the answer to four decimal places.) Classes to Implement For this assignment, you must implement two java classes: Tile and Scrabble. Follow the guidelines for each one below. In these classes, you can implement more private (helper) methods if you want to. You may not, however implement more public methods. You may not add instance variables other than the ones specified below nor change the variable types or accessibility (i.e. making a variable public when it should be private). Penalties will be applied if you implement additional instance variables or change the variable types of modifiers from what is described here. CS 1027 Computer Science Fundamentals II Tile.java This class represents a single Scrabble tile that will be used in the game. The class must have the following private variables: value (char) The class must have the following public methods: public Tile() (constructor] Initialize value to " public Tile(char) [constructor] Initialize value to the given argument public void pickup() o Generate a random character between A and Z (inclusive) and set the value to that letter. o Feel free to use 'java.util.random' for this method public char getValue() Returns the tile value Assignment 1 Scrabble.java This class represents the Scrabble game in which there are seven randomly selected tiles, and scoring is performed for each possible word (this will be the tougher class to implement). The class must have the following private variables: tiles (Tile[]) The class must have the following public methods: public Scrabble() [constructor] CS 1027 Computer Science Fundamentals II o Initialize the Tile array and 'pickup' for random values public Scrabble(Tile []) [constructor] o Initialize the tile array with the given argument public String getLetters() o Return a string that is all of the tile characters (for example, "ABFEODL") public ArrayList getWords() o Create an ArrayList of Strings with n elements. Each element should represent a word that can be created using the current tiles. o The algorithm for this method should reference the provided file CollinsScrabbleWords2019.txt o ** do NOT put this file somewhere on your local machine and hardcode the local directory. This will likely cause your tests to fail on GradeScope. Also, do not put it within a folder in the relative path. public int[] getScores() o Create an int array with n elements. Each element in this list should represent each individual score for each word that can be created using the current tiles. This should be returned in ascending order. public Boolean equals(Scrabble) o Compare the given Scrabble object from the argument with the "this' object to see if they are equal (do they have the same tiles?). public ArrayList getWords() o Create an ArrayList of Strings with n elements. Each element should represent a word that can be created using the current tiles. o The algorithm for this method should reference the provided file CollinsScrabbleWords2019.txt o **do NOT put this file somewhere on your local machine and hardcode the local directory. This will likely cause your tests to fail on GradeScope. Also, do not put it within a folder in the relative path. public int[] getScores() o Create an int array with n elements. Each element in this list should represent each individual score for each word that can be created using the current tiles. This should be returned in ascending order. AA AAH AAHED AAHING AAHS AAL AALII AALIIS AALS AARDVARK AARDVARKS AARDWOLF AARDWOLVES Show that C is isomorphic to the subgroup of GL 2 (R) consisting of matrices of the form ( ab ba ). 2. Prove that (Z 8 ) is isomorphic to the group of matrices ( 10 01 ),( 10 01 ),( 10 01 ),( 10 01 ) The heat of mixing data for the n-octanol + n-decane liquid mixture at atmospheric pressure are approximately fit by: h = xx (A + B(x - x))]/mol Where A =-12,974 +51.505 T and B = +8782.8-34.129T with T in K and x being the n-octanol mole fraction. i. Compute the difference between the partial molar and pure component enthalpies of n-octanol and n-decane at x = 0.5 and T =300K. ii. Plot h vs. x at 300K. Show the relationship between the plotted data and your answers in part a) by placing your value for n-octanol at x = 0.5 and determining H & H iii. Using the plot, estimate values for h infinity and hinfinity A silver conductor has a resistance of 25 at o'c. Determine the temperature coefficient of resistance at o'c and the resistance at -30 C. A 675-meter bike trail passes through forest and meadows. There are six legs of the trail that cut through meadows: two legs measure meters, three legs measure 52.25 meters, and one leg measures 32 meters. The rest of the trail passes through forest. How many meters of the trail pass through the forest? The student started with 0.765 mmoles of Reactant A and 1.00mmoles of Reactant B. The student obtained 0.600 mmoles of product.Calculate the % yield for this reaction. solve with quadratic equation (7-3x)=9/16 What volume of the diluted solution contains 13.8 g of NaCl ? (Hint. Figure out the concentration of the diluted solution first.) Express your answer using two significant figures. Which of those are solutions? Check all that apply. nitrogen gas hexane table salt air distilled water seawater You decide to add to your data table by conducting the same subsitution reactions with another alkyl halide: 3-chloro-1-butene.Your data shows that 3-chloro-1-butene reacted faster than 2-chlorobutane in an SN1 reaction. Suggest an explanation for this rate difference. A discharge of 60 m/s is flowing in a rectangular channel. At section (1), the bed width= 10.0 m and the water depth = 4.0 m. The channel bed width is gradually contracted to reach a bed width of 5.0 m at section (2). Within the contracted zone, the bed level is gradually raised. Find analytically the minimum rise in bed level at section (2) so that the flow is critical. need help all information is in the picture. thanks! A 69 kV 3-phase power distribution line is suspended from grounded steel towers via insulators with a BIL of 350 kV and protected by a circuit breaker. The neutral of the transmission line is solidly grounded at the transformer, just ahead of the circuit breaker, but the tower has a resistance of 30 2 to ground. (i) Calculate the peak voltage across each insulator under normal conditions. [10%] (ii) Suppose that, during an electrical storm, one of the towers is hit by a bolt of lightning of 20 kA, lasting a few microseconds. Describe the sequence of events during the strike, and its immediate aftermath. [20%] (iii) Strikes of this magnitude are fairly common. What could be used to replace the circuit breaker to ensure the power outage is minimised? [5%] (iv) Give two applications of high voltage d.c. power links in power distribution networks.