All categories

3 years ago

Given the following schema

Computers and Technology

1 answer:

vampirchik [111]3 years ago

8 0

Answer:

A ⟶ BCD , B ⟶ E , E ⟶ F , G⟶ H , H ⟶ E

b) AG

c) attached below

d ) attached below

Explanation:

<u>a) Minimal cover of this schema </u>

This can be written following the steps below

step 1 : AB ⟶ C, AB ⟶ D , A ⟶ B , B ⟶ E, E ⟶ F , A⟶F, G ⟶ H, H ⟶ E, GC⟶H, G ⟶ E

removing redundant FD

AB ⟶ C , AB ⟶ D , A ⟶ B, B ⟶ E, E ⟶ F, G ⟶H , H⟶ E ,

eliminating p if Q⁺ contains p

Finally the Minimal cover of the schema

A ⟶ BCD , B ⟶ E , E ⟶ F , G⟶ H , H ⟶ E

<u>B) Key of this schema </u>

AG is the key of this schema given that ( AG )⁺ = ABCDEFGH

C) Determine the 3rd normal form decomposition

attached below

D) BCNF decomposition

attached below

You might be interested in

Typically, when an organization purchases Internet access from an Internet Service Provider (ISP), the ISP will grant it

Radda [10]

Answer:

(B) A single public IP address that it can use for NAT

Explanation:

Because the IPV4 IP protocol is still used today, the number of available IP addresses is limited (only 4,294,967,296 addresses in the world), for this reason, the most correct practice is the assignment of a single public IP to those companies that acquire services from an ISP, with some few exceptional cases of companies that own several.

So that the company's addressing can be executed successfully, the use of NATs is enabled, this allows the translation of network addresses, allowing the company to have as many private networks as necessary and that these can be communicated Correctly with the global network, the Internet, through the public IP of the company.

4 0

4 years ago

The acronym GUI is short for

Y_Kistochka [10]

Graphical user interface.

Hope I helped :)

4 0

3 years ago

MDM consolidates data from various data sources into a __________, which then feeds data back to the applications, thereby creat

Pepsi [2]

Answer:b) Master reference file(MRF)

Explanation: Master reference file is the collection of data that persist the schedules records for the maintenance and administration. It is the UDC version tool .

It helps in the managing the data content present in the database, archiving and tracing any changes on the database over certain time.Master data management is the managing of data's integrity .It send the collected critical data to the master reference files.

Other given options are incorrect because backup file is for creating data backup, central directory is record of the data of users and other information and data silo is kind of fixed data having the governance of any organization.Thus, these factors don't help in the critical information management.Thus, the correct option is option(b).

3 0

4 years ago

Which option is used to ensure the integrity and authenticity of a Word document but requires additional services to be availabl

mel-nik [20]

Answer:

Digital signature.

Explanation:

Digital signature is used to ensure the integrity and authenticity of a Word document but requires additional services to be available on the internal network.

This is important as it makes sure that the file is authentic and not malware.

3 0

3 years ago

Read 2 more answers

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Mama L [17]

The ESC Key.

hope that helps

8 0

4 years ago