full details of all parts in  

1. Rational Algebra and 
2. Tuple calculus

 

2.  Get the total number of projects supplied by supplier S1 using SQL

 

3. Consider the two tables T1 and T2 shown below. Show the result of the following operations: 

1. T1 JOIN _T1.P=T2.A T2
2. T1 LETF OUTER JOIN _T1.P=T2.A T2
3. T1 RIGHT OUTER JOIN _T1.Q=T2.B T2
4. T1 FULL OUTER JOIN _T1.P=T2.A  T2
5. T1 È T2 
6. T1 × T2 

 

 

T2                                T1

A	B	C
10	b	6
25	c	3
10	b	5

 

P	Q	R
10	a	5
15	b	8
25	c	6

 

4.  In general, given a populated relation (extension), we cannot determine which FDs hold and which do not unless we know the meaning of the relationships among the attributes. All we can say is that certain FDs may exist if they hold in that extension. We cannot guarantee its existence until we understand the meaning of the corresponding attributes. However, given the current state of the table below, list:

1. The FDs that may exist among the attributes of the current state of table? If yes, then list the FDs
2. The FDs that do NOT exist among the attributes of the current state of the table. If yes, then list the FDs that violate this constraint.

 

explain each step!

 

 

Use the suppliers-parts-projects database for the following questions.

 

Supply

S#	SNAME	STATUS	CITY
S1	SMITH	20	LONDON
S2	JONES	10	PARIS
S3	BLAKE	30	PARIS
S4	CLARK	20	LONDON
S5	ADAMS	30	ATHENS

 

Part

P#	PNAME	COLOR	WEIGHT	CITY
P1	NUT	RED	12	LONDON
P2	BOLT	GREEN	17	PARIS
P3	SCREW	BLUE	17	ROME
P4	SCREW	RED	14	LONDON
P5	CAM	BLUE	12	PARIS
P6	COG	RED	19	LONDON

 

Project

J#	JNAME	CITY
J1	SORTER	PARIS
J2	PUNCH	ROME
J3	READER	ATHENS
J4	CONSOLE	ATHENS
J5	COLLATOR	LONDON
J6	TERMINAL	OSLO
J7	TAPE	LONDON

 

SPJ 

S#	P#	J#	QTY
S1	P1	J1	200
S1	P1	J4	700
S2	P3	J1	400
S2	P3	J2	200
S2	P3	J3	200
S2	P3	J4	500
S2	P3	J5	600
S2	P3	J6	400
S3	P3	J1	200
S4	P6	J3	500
S5	P2	J4	500
S5	P6	J4	800

 

Transcribed Image Text:

A al al a2 a3 B bl b2 b2 b3 C cl c2 c2 c4 D d1 d2 d3 d3 A al al a2 a3 B bl b2 b2 b3 C cl c2 c2 c4 D d1 d2 d3 d3

Answer rating: 100% (QA)

It seems like youve asked for a detailed explanation on multiple topics and provided various tables and scenarios that require analysis Lets go through each of your requests systematically 1 Rational ... View the full answer