(i) What will be the degree and cardinality of the cartesian product formed while combining both the above given tables 'SAP' and 'Store"?

Question

(i) What will be the degree and cardinality of the cartesian product formed while combining both the above given tables 'SAP' and 'Store"?

(ii) Sangeeta is not able to add a new record in the table'Store'through the following query: Insert into store values (1206,1006,'Karol Bagh', Insert into store values (1206,1006,'Karol Bagh', '20L6/07/25'); Identify the error if there is any.

Monjur Alahi

4 views

2025-01-04 04:42

1 Answers

Related Questions

Give differences between the following: First degree burn and second degree burn

1 Answers 4 Views

Name the way to capture the rain water when it rains, store that water above ground or charge the underground and use it latter.

1 Answers 5 Views

What is the degree and cardinality of 'Garment' table ?

1 Answers 12 Views

Table SCHOOL has 4 rows and 5 columns. What is the Cardinality and Degree of this table?

1 Answers 4 Views

A table "Transport" in a database has degree 3 and cardinality 8.

1 Answers 4 Views

What is the Cartesian product of two table? Is it same as an Equi-join?

1 Answers 4 Views

There are two table T1 and T2 in a database. Cardinality and degree of T1 are 3 and 8 respectively.

1 Answers 4 Views

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii):

1 Answers 4 Views

With reference to the above given tables (in Q. 6-(b)), write commands in SQL for (i) to (iii) :

1 Answers 4 Views

A projectile is given an initial velocity of i + 2j. The cartesian equation of its path is (Take g = 10 ms^-2)

1 Answers 4 Views

Salim Ahmed Kawsar · Accepted Answer · 2023-02-05T15:29:48+06:00

(i) Degree : 8

Cardinality : 25

Table : SAP

SAPID	ItemCode	ltem Name	Item Location
S1001	1001	Receiver	W12-B1-R24
S1002	1002	Tansponder	W13-B7-R87
S1003	1003	Battery Bank	W21-B1-R87
S1004	1004	Inverter	W21-B11-R2
S1005	1005	Genset	W22-B15-R16

Table : Store

Store-ID	ItemCode	StoreLocation	Received Date
1201	1001	Hauz Khas	2016/05/20
1202	1002	Rajouri Garden	2016/06/14
1203	1003	Rohini	2016/05/06
1204	1004	Hawz Khaas	2016/07/15
1205	1005	Rajendra Place	2016/05/27

(ii) As referential integrity is being maintained in between both the tables, ItemCode 1006 cannot be inserted in the table store as there is no corresponding matching entry in the table SAP.