Question

Complete the following statements.
1. Once a relationship is built among the tables, the data___________________________________.​

Answer 1

Explanation:

Answer:

Let the first part be 'x' and the second part be '6500 - x'.

According to the question,

⇒ 15% of first part = 12% of second part

⇒ 15% of x = 12% of (6500 - x)

\begin{gathered}\dfrac{15}{100} \times x = \dfrac{12}{100} \times (6500 - x)\\\\\\\dfrac{15x}{100} = \dfrac{12(6500-x)}{100}\\\\\\15x = 78000 - 12x\\\\15x + 12x = 78000\\\\27x = 78000\\\\x = \dfrac{78000}{27}\\\\\\\boxed{ x = Rs.\:2888.89}\end{gathered}

100

15

×x=

100

12

×(6500−x)

100

15x

=

100

12(6500−x)

15x=78000−12x

15x+12x=78000

27x=78000

x=

27

78000

x=Rs.2888.89

Second part is given as:

⇒ 6500 - x

⇒ 6500 - 2888.89

⇒ 3611.11

Hence the first part is Rs. 2888.89 and the second part is Rs. 3611.11.

Answer 2

Key fields

Once a relationship is built among the tables, the data in key fields.

• Data matching in key fields—often a column with the same name in both tables—is how a table relationship operates. Typically, the primary key from one table, which gives each record a unique identity, and a foreign key in the other table are the matching fields.
• Relationships in a database are associations between tables that are made with the aid of join statements in order to access data. The database relationships are shown in the following table. Only one record from each table can be on either side of the relationship. Each primary key value corresponds to either no records or just one in the associated table.
• Table relationship specifications. Each row in a table must be uniquely identified by a single column in that table. The primary key commonly refers to this column. The lookup column's data values must be distinct.
• One-to-one, one-to-many, and many-to-many are the three different sorts of relationships that might occur between two tables.
• One-to-one, one-to-many, and many-to-many are the three sorts of relationships between the data you are likely to find at this stage of the design. You must look at the data and be aware of the business rules that apply to the data and tables in order to be able to spot these linkages.

#SPJ2