Bissoy.com
Doctors Medicines MCQs Q&A

Let R and S be two database relations. If cardinalities of R and S are 4 and 10, respectively, then what will be the number of tuples in R × S, where '×' represents cross product operation?

Let R and S be two database relations. If cardinalities of R and S are 4 and 10, respectively, then what will be the number of tuples in R × S, where '×' represents cross product operation? Correct Answer 40

The correct answer is option 1.

Concept:

Cross product:

Cross product is a way of combining two relation instances. The resulting relation has a schema that contains each of the attributes in both relations being combined.

A cross product is represented by the following notation:

Employee x Parking

Example:

Employee x Parking:

Cross product grows quickly, there are N * M rows in the resulting relation (N = number in Employees, M = number in Parking), and the resulting relation has X + Y columns (attributes) in it (X = number of attributes in Employees, Y = number of attributes in Parking).

The given data,

R =4 rows

S=10 rows, 

R x Y = 40 rows

Hence the correct answer is 40 rows

Related Questions

Consider two database relations R and S having 3 tuples in R and 2 tuples in S. what is the maximum number of tuples that could appear in the natural join of R and S?
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
Facts related to public relations are given below
1. Internal relations
2. Customer relations
3. Concept of public relations
4. Internal coordination
Which of the above given is/are types of public relations?
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
Two stores A and B bought the same product from the company at the same price. Store A marked the price of the product 50% above its cost price and offered two successive discounts of 15% and 10% on the marked price of the product, while store B marked the price of the product 60% above its cost price and offered two successive discounts of 15% and 12% on the marked price of the product. If a customer buys the product from store B, he has to pay Rs. 986 more than that at store A. At what price the two stores bought the product from the company?
Consider two relations R1(A, B) with the tuples (1, 5), (3, 7) and R2(A, C) = (1, 7), (4, 9). Assume that R(A, B, C) is the full natural outer join of R1 and R2. Consider the following tuples of the form (A, B, C): a = (1, 5, null), b = (1, null, 7), c = (3, null, 9), d = (4, 7, null), e = (1, 5, 7), f = (3, 7, null), g = (4, null, 9). Which one of the following statements is correct?
There are two rows, each containing 3 numbers. Below are some rules to be used to get the resultant number for each row separately. Use the rule from left to right for each row and find the answer to the question. Rule: 1. If an even number is followed by an even number, then the first number will be subtracted from the second. 2. If an odd number is followed by an odd number, then both will be added. 3. If an odd number is followed by an even number, then the even number will be subtracted from the square of the odd number. 4. If an even number is followed by an odd number, then the odd number will be subtracted from the even number. Row I: 9,11, 34 Row II: 16, 9, 8 What is the difference between the resultant numbers in the first row and the second row
In the following figure, square represents the people who use the product of Colorbar, the triangle represents the people who use products of NYX, the circle represents people who use products of M.A.C., the rectangle represents people who use products of Maybelline and semi-circle represents the people who use the products of Lakme. Which set of letter(s) represents people who use more than one product?
Four friends A, B, C and D need to cross a bridge. A maximum two persons can cross it at a time. It is night and they just have one lamp. Persons that cross the bridge must carry the lamp to find the way. A pair must walk together at the speed of slower person. After crossing the bridge, the person having faster speed in the pair will return with the lamp each time to accompany another person in the group. Finally, the lamp has to be returned at the original place and the person who returns the lamp has to cross the bridge again without lamp. To cross the bridge, the time taken by them is as follows: A :1 minute, B : 2 minutes, C : 7 minutes and D : 10 minutes. What is the total minimum time required by all the friends to cross the bridge?
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested select * from R where a in (select S.a from S)