Computers and Technology, 19.12.2019 01:31 McKenzie8409

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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 09:30

What are the steps involved in accepting all the changes in a document? arrange these in order click edit. click accept or reject. click changes. click accept all.

Answers: 1

Answer

Computers and Technology, 22.06.2019 22:40

Write a program that defines symbolic names for several string literals (chars between quotes). * use each symbolic name in a variable definition. * use of symbolic to compose the assembly code instruction set can perform vara = (vara - varb) + (varc - vard); ensure that variable is in unsigned integer data type. * you should also further enhance your symbolic logic block to to perform expression by introducing addition substitution rule. vara = (vara+varb) - (varc+vard). required: debug the disassembly code and note down the address and memory information.

Answers: 3

Answer

Computers and Technology, 23.06.2019 01:40

You have a linux system that has a 1000gb hard disk drive, which has a 90gb partition containing an ext4 filesystem mounted to the / directory and a 4gb swap partition. currently, this linux system is only used by a few users for storing small files; however, the department manager wants to upgrade this system and use it to run a database application that will be used by 100 users. the database application and the associated data will take up over 200gb of hard disk space. in addition, these 100 users will store their personal files on the hard disk of the system. each user must have a maximum of 5gb of storage space. the department manager has made it very clear that this system must not exhibit any downtime as a result of hard disk errors. how much hard disk space will you require, and what partitions would you need to ensure that the system will perform as needed? where would these partitions be mounted? what quotas would you implement? what commands would you need to run and what entries to /etc/fstab would you need to create? justify your answers.

Answers: 3

Answer

Computers and Technology, 24.06.2019 17:50

You will subnet the network address 172.31.103.0/24. the network has the following requirements: · room-114 lan will require 27 host ip addresses · room-279 lan will require 25 host ip addresses · room-312 lan will require 14 host ip addresses · room-407 lan will require 8 host ip addresses how many subnets are needed in the network topology?

Answers: 2

Answer

You know the right answer?

Consider a relation r(abcdefghij) with the following set of functional dependenciesg = { f → ab, cd...

Questions