Computers and Technology

Consider a relation r(abcdefghij) with the following set of functional dependenciesg = { f → ab, cd → e, c → fg, h → ij, d → h }
is cde a superkey of r (w. r.t. g)?
is cde a key of r (w. r.t. g)?
apply the appropriate algorithm to determine a key for r (w. r.t. g).
apply the appropriate algorithm to determine all the keys for r (w. r.t. g).
determine the prime attributes of r.
is r in bcnf (w. r.t. g)?
is r in 3nf (w. r.t. g)?
determine whether the decomposition d = { cde, cfg, dh, hij, fab } has (i) the dependency preservation property and (ii) the lossless join property, with respect to g. also determine which normal form each relation in the decomposition is in.

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 14:00, ahmetagayew2004
In a file-oriented information system, a transaction file stores relatively permanent data about an entity is created and saved for backup and recovery purposes stores records that contain day-to-day business and operational data is a temporary file created by an information system for a single task
Answers: 3
image
Computers and Technology, 22.06.2019 07:50, OnlyaBurden
In this lab, you complete a prewritten c++ program for a carpenter who creates personalized house signs. the program is supposed to compute the price of any sign a customer orders, based on the following facts: the charge for all signs is a minimum of $35.00. the first five letters or numbers are included in the minimum charge; there is a $4 charge for each additional character. if the sign is made of oak, add $20.00. no charge is added for pine. black or white characters are included in the minimum charge; there is an additional $15 charge for gold-leaf lettering. instructions ensure the file named housesign. cppis open in the code editor. you need to declare variables for the following, and initialize them where specified: a variable for the cost of the sign initialized to 0.00 (charge). a variable for the number of characters initialized to 8 (numchars). a variable for the color of the characters initialized to "gold" (color). a variable for the wood type initialized to "oak" (woodtype). write the rest of the program using assignment statements and ifstatements as appropriate. the output statements are written for you. execute the program by clicking the run button. your output should be: the charge for this sign is $82. this is the code, // housesign. cpp - this program calculates prices for custom made signs. #include #include using namespace std; int main() { // this is the work done in the housekeeping() function // declare and initialize variables here // charge for this sign // color of characters in sign // number of characters in sign // type of wood // this is the work done in the detailloop() function // write assignment and if statements here // this is the work done in the endofjob() function // output charge for this sign cout < < "the charge for this sign is $" < < charge < < endl; return(0); }
Answers: 1
image
Computers and Technology, 22.06.2019 19:20, mayaparness
Write a program that prompts the user to input a string. the program then uses the function substr to remove all the vowels from the string. for example, if str = "there", then after removing all the vowels, str = "thr". after removing all the vowels, output the string. your program must contain a function to remove all the vowels and a function to determine whether a character is a vowel.
Answers: 2
image
Computers and Technology, 23.06.2019 22:50, atifgujar
An environmental protection agency study of 12 automobiles revealed a correlation of 0.47 between engine size and emissions. at 0.01 significance level, can we conclude that there is a positive association between the variables? what is the p value? interpret.
Answers: 2
Do you know the correct answer?
Consider a relation r(abcdefghij) with the following set of functional dependenciesg = { f → ab, cd...

Questions in other subjects:

Konu
History, 29.05.2020 02:57
Konu
Health, 29.05.2020 02:57
Konu
Mathematics, 29.05.2020 02:58