www.ispwsznysa.fora.pl

Mardok

Jak ktoś ma jakieś zadania rozwiązane z tych list (od mistrza Mijagi) i zechciał by się podzielić był bym wdzięczy Wink

Mnie dotyczy konkretnie:

Lista 3 : Zad. 1 Zad. 4
Lista 4 : Zad. 3 Zad. 4
Lista 5 : Zad. 3 Zad. 9

Siwy

Od dziennych, nie gwarantuje że wszystko dobrze, ale jest Smile

1.a: select * from D left join C on D.D# = C.D#
1.b: select * from D right join C on D.D# = C.D#
1.c: select * from DC left join C on DC.D# = C.D# and DC.C# = C.C#
1.d: select * from DC right join C on DC.D# = C.D# and DC.C# = C.C#

2.a: select * from r where A = 'a1'
2.b: select * from r where A = 'a1' and C = 'c1'
2.c: select * from r where A = 'a1' or C = 'c1'
2.d: select * from r where A = 'a1' and C = 'c3'
2.e: select A from r
2.f: select A,C from r
2.g: select B from r where A = 'a1' and C = 'c1'
2.h: select B from r where A = 'a1' and not (C = 'c1')

3.a: select * from r inner join s on r.B = s.B and r.C = s.C
3.b: select r.A, r.C from r inner join s on r.B = s.B and r.C = s.C
3.c: select a,c,d from r inner join s on (r.b=s.b)and(r.c=s.c)
3.d: select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' or r.A = 'a2'
3.e: select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' and r.C = 'c1'
3.f: select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' and not (r.C = 'c1')

4.a: select * from r inner join s on r.B = s.B and r.C = s.C
4.b: select * from r left join s on r.B = s.B and r.C = s.C
4.c: select * from r right join s on r.B = s.B and r.C = s.C
4.d: select * from r,s

Siwy

podzielce się resztą list Smile

Vadi

to są moje rozwiązania, nie dam głowy, że wszystko jest dobrze.

lista 4

zad 2.
a: select * from r inner join s;
b: select a,c from r inner join s;
c: select a,c from r inner join (select c,d from s);
d: select b from r inner join s where a=a1 or a=a2;
e: select b from r inner join s where a=a2 and c=c1;
f: select b from r inner join s where a=a2 or not c=c1;

zad 3.
a: select * from r inner join s on (r.b=s.b) and (r.c=s.c);
b: select * from r left outer join s on (r.b=s.b) and (r.c=s.c);
c: select * from r right outer join s on (r.b=s.b) and (r.c=s.c);
d: select * from r,s

zad 6.
a: select * from r minus select * from r where A=a1;
b: select B,C from r union select B,C from s;
c: ???

lista 5

zad 4.
a: zależność A→B nie należy do F+
b: F+ jest pusty nie jest pusty zawiera F+={ A→A, B→B, C→C, AB→AB, AC→AC, BC→BC, ABC→ABC, AB→A, AB→B, AC→A, AC→C, BC→B, BC→C, ABC→A, ABC→B,ABC→C, ABC→AB, ABC→AC, ABC→BC}
c: AD→B należy do F+ ponieważ A→B daje AD→BD→B

zad 10.
???

PIETREK

Piotr Forysiak
informatyka stosowana
zaoczne
3 semestr
numer indeksu 12415
Nr indeksu lub 3 pierwsze litery nazwiska i imienia listy / zadania
Lista 3 Lista 4 Lista 5
12415 2,3 4,1 4,8
------------------------------------------------------------------------------------------------------------------------
Lista 3
Zadanie 2
2.a: select * from r where A = 'a1'
2.b: select * from r where A = 'a1' and C = 'c1'
2.c: select * from r where A = 'a1' or C = 'c1'
2.d: select * from r where A = 'a1' and C = 'c3'
2.e: select A from r
2.f: select A,C from r
2.g: select B from r where A = 'a1' and C = 'c1'
2.h: select B from r where A = 'a1' and not (C = 'c1')
Zadanie 3
3.a: select * from r inner join s on r.B = s.B and r.C = s.C
3.b: select r.A, r.C from r inner join s on r.B = s.B and r.C = s.C
3.c: select a,c,d from r inner join s on (r.b=s.b)and(r.c=s.c)
3.d: select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' or r.A = 'a2'
3.e: select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' and r.C = 'c1'
3.f: select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' and not (r.C = 'c1')
------------------------------------------------------------------------------------------------------------------------
Lista 4
Zadanie 1
a) select A from r
b) select A,C from r
c) select B from r where A ='a1' and C='c1'
d) select B from r where A ='a1' and not C='c1'
a)
a1
a1
a1
a2
a3
b)
a1 c1
a1 c2
a1 c2
a2 c1
a3 c1
c)
a1 c1
d)
a1 c2
a1 c2
Zadanie 4
a)select * from r inner join s where c>e
b)select * from r inner join s where c<e
c)select * from r inner join s where c=e
a)
a2 b3 2 b2 1
a1 b3 2 b2 1
a3 b2 3 b2 1
a3 b2 3 b2 2
b)
a1 b1 1 b2 2
a1 b1 1 b3 4
a1 b1 1 b4 3
a2 b3 2 b3 4
a2 b3 2 b4 3
a1 b3 2 b3 4
a2 b3 1 b2 2
a2 b3 1 b3 4
a2 b3 1 b4 3
a4 b2 3 b3 4
c)
a1 b1 1 b2 1
a2 b3 2 b2 2
a1 b3 2 b2 2
a2 b3 1 b2 1
------------------------------------------------------------------------------------------------------------------------
Lista 5
Zadanie 4
a)nie
b)nie
c)tak bo z a->b robimy ad->bd a bd-> więc ad->b
Zadanie 8
a) klucz A klucz B
b) klucz AB
c) klucz A
d) klucz AB

roy

lista 3
Zadanie 1
a)
select * from D left join C on D.D# = C.D#

b)
select * from D right join C on D.D# = C.D#

c)
select * from DC left join C on DC.D# = C.D# and DC.C# = C.C#

d)
select * from DC right join C on DC.D# = C.D# and DC.C# = C.C#

Zadanie 3
a)
select * from r inner join s on r.B = s.B and r.C = s.C

b)
select r.A, r.C from r inner join s on r.B = s.B and r.C = s.C

c)
select a,c,d from r inner join s on (r.b=s.b)and(r.c=s.c)

d)
select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' or r.A = 'a2'

e)
select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' and r.C = 'c1'

f)
select r.B from r inner join s on r.B = s.B and r.C = s.C where r.A = 'a1' and not (r.C = 'c1')

lista 4

Zadanie 2
a)
select * from r inner join s;

b)
select a,c from r inner join s;

c)
select a,c from r inner join (select c,d from s);

d)
select b from r inner join s where a=a1 or a=a2;

e)
select b from r inner join s where a=a2 and c=c1;

f)
select b from r inner join s where a=a2 or not c=c1;

Zadanie 5

lista 5
5
1

lista 6
3

Zadanie 5

a)
R=(ABCD A->C B->D AB->CD)
K=AB
NK=C,D

- C
AB - A - C
- B - D

3PN

b)
R=(ABCD A->BC)
K=AD
NK=B,C

AD -> A -> BC

3PN

c)
R=(ABCD AB->C AC->D)
K=AB
NK=CD

AB -> C
AB -> AC -> D

- B
AB - C
- A
- AC - D

3PN

d)
R=(ABCD AB -> C BC -> D)
K=AB
NK=CD

AB - C
- A
- B
- BC - D

wspolne B-nie ma zaleznosci

lista 7

Zadanie 1
a)
R=(ABCD A->C C->B C->AD ) PNBC
K=A,C wynika wszystko

b)
R=(ABCD AB->CD C->D)
K=AB
NK=CD
R1=(CD C->D)
R2=(ABC AB->C)

c)
R=(ABCD A->C C->B A->D)
K=A
NK=BCD
R1=(BC C->B)
R2=(ACD A->C A->D)

d)
R=(ABCD A->C AB->C C->D)
K=AB
R=(AC A->c)
R=(ABD AB->D)

5

Mardok

Lista 6

ZADANIE 3

3. Określić klucze i sprowadzić do 2PN następujące schematy:
a) R1 = (ABCD, A->C, B->D, AB->CD),

KLUCZ=AB
NIEKLUCZ=CD

2PN

b) R2 = (ABCD, A->BC),

KLUCZ=AD
NIEKLUCZ=BC

(ABC, A->BC KLUCZ=A)
(AD, 0)
2PN

c) R3 = (ABCD, AB->C, AC->D),
KLUCZ=AB
NIEKLUCZ=CD
2PN

d) R4 = (ABCD, AB->C, BC->D).

zadanie 5

5. Sprowadzić do 3PN następujące schematy:
a) R1 = ({A,B,C,D}, {A->C, B->D, AB->CD}),

klucz=AB
nie klucz= CD

AB---->CD
------->A--->C
------->B--->D

3PN

b) R2 = ({A,B,C,D}, {A->BC}),

KLUCZ=AD
NIEKLUCZ=B,C

AD-->A--->BC

3PN

c) R3 = ({A,B,C,D}, {AB->C, AC->D}),

KLUCZ=AB
NIEKLUCZ= C,D

AB----->B
----->C
----->A
----->AC--->D

3PN

d) R4 = ({A,B,C,D}, {AB->C, BC->D})

KLUCZ=AB
NIEKLUCZ=C,D

AB----->C
----->A
----->B
----->BC--->D

LISTA 7

ZADANIE 2

2. Sprowadzić do PNB-C następujące schematy:
a) R1 = (ABC, AB->C, C->B),

R11=(CB,C->B)
R12=(AC, 0)

b) R2 = (ABCD, AB->CD, C->AD),

R21=(ACD,C->AD)
R22=(BC,0)

c) R3 = (ABCD, AB->CD, C->A, D->B),

R31=(AC, C->A)
R32=(BCD,D->B)