Question

Suppose we have a relation schema R(A, B, C) with FD A rightarrow B. Suppose also that we decide to decompose this schema into S(A, B) and T(B, C). Give an example of an instance of relation R whose projection onto S and T and subsequent rejoining as in Section 3.4.1 does not yield the same relation instance. That is, pi_A, B(R) pi_B, C (R) notequalto R.

Answer 1

Check the explanation

Step-by-step explanation:

A relation schema is the fundamental schema for a table. Which is In a relational kind of database (what individuals naturally refer to when they talk about database) each take can be referred to as a "relation" . therefore a relational schema is the design for the table.

kindly check the attached image below to see the step by step solution to the question.