el_bi
08.05.12,11:34
ahojte. chcela by som sa spytat ci niekto, kto sa vyzna v exceli, by mi vedel pomoct najst odpoved na jeden priklad, tykajuci sa operacii s relacnymi algebrami, cize s tabulkami. konkretne ide o tento:
Consider the following schema of tables:
Employee(person_name, street, city)
Works(person_name, company_name, salary)
Company(company_name, city)
Manages(person_name, manager_name)
a dalej zadanie je taketo:
Please use the tables as the basis for these questions:
Give an expression or a formula in relational algebra to express each of the following queries:
1. Find the names of all employees who earn more than their managers
2. Find the names of all employees who live in the same city and on the same street as their managers
3. Find the names of all employees within the database that do not work for "BNY Mellon"
4. Find the names of all employees in the database who earn more than the top earner at "BNY Mellon" in the database.
Vsetky udaje v tabulkach, ako napr ako person_name, street atd si samozrejme mozem vymysliet, no uz vyse tyzdna si lamem hlavu s tym, ake funkcie mam poucit aby som dosla k jednotlivym rieseniam. Preto ak by ste mi aspon s tymto niekto vedeli pomoct, bola by som vam velmi vdacna. Ak by to niekto potreboval prelozit, staci napisat.
Consider the following schema of tables:
Employee(person_name, street, city)
Works(person_name, company_name, salary)
Company(company_name, city)
Manages(person_name, manager_name)
a dalej zadanie je taketo:
Please use the tables as the basis for these questions:
Give an expression or a formula in relational algebra to express each of the following queries:
1. Find the names of all employees who earn more than their managers
2. Find the names of all employees who live in the same city and on the same street as their managers
3. Find the names of all employees within the database that do not work for "BNY Mellon"
4. Find the names of all employees in the database who earn more than the top earner at "BNY Mellon" in the database.
Vsetky udaje v tabulkach, ako napr ako person_name, street atd si samozrejme mozem vymysliet, no uz vyse tyzdna si lamem hlavu s tym, ake funkcie mam poucit aby som dosla k jednotlivym rieseniam. Preto ak by ste mi aspon s tymto niekto vedeli pomoct, bola by som vam velmi vdacna. Ak by to niekto potreboval prelozit, staci napisat.
sthruska
08.05.12,10:22
ake funkcie mam poucit aby som dosla k jednotlivym rieseniam. Môžeš poučiť všetky. Len či si Tvoje poučenie vezmú k srdcu?
Teraz vážne. Nenapísala si aký má byť výstup. Mňa totiž napadlo ísť na to cez podmienené formátovanie, ale to asi nechceš.
PS: naozaj hľadaš riešenie pre excel? Mne to pripadá ako úloha pre databázu.
Teraz vážne. Nenapísala si aký má byť výstup. Mňa totiž napadlo ísť na to cez podmienené formátovanie, ale to asi nechceš.
PS: naozaj hľadaš riešenie pre excel? Mne to pripadá ako úloha pre databázu.
monchi
08.05.12,10:58
Pre kazdu ulohu si vytvor nove sheet a s pouzitim filtrov by sa to dalo poriesit, ale mne to tiez pripada ako ulohy pre databazu, tam by to bolo omnoho jednoduchsie:
1: Stlpec A meno zamestnanca; stlpec B zarabaviacej ako manzer?
vlookup na works tabulku odkial zoberies salary pre zamestnanca
vlookup na manager tabulku a v tom dalsi vlookup na works tabulku z ktorej zoberies salary
tieto 2 vlookupy spojis v jednom if a aplikujes automAticky filter
-> ostatne ulohy maju podobny princip, ak ti to nepojde pasti sem nejake tabulky s datami
/M
1: Stlpec A meno zamestnanca; stlpec B zarabaviacej ako manzer?
vlookup na works tabulku odkial zoberies salary pre zamestnanca
vlookup na manager tabulku a v tom dalsi vlookup na works tabulku z ktorej zoberies salary
tieto 2 vlookupy spojis v jednom if a aplikujes automAticky filter
-> ostatne ulohy maju podobny princip, ak ti to nepojde pasti sem nejake tabulky s datami
/M
Charon
08.05.12,13:09
Mne to pripadá ako vytvorenie nových funkcií s volaním premenných ...
el_bi
10.05.12,12:31
tak spravila som si tu tabulku tak ju sem teda hodim, dufam ze je dobra. najprv som to mala robit v mySQL a teraz v exceli. tu tretiu ulohu som uz spravila cez filter, to bolo jednoduche. len s tymi ostatnymi si neviem rady :(
tie tabulky som si spravila takto:
Employee
Works
Person_name
Street
City
Person_name
Company_name
Salary
Peter Modry
Vajnorska
Trnava
Peter Modry
BNY Mellon
2100
Michal Novak
Trnavska
Trencin
Michal Novak
Safetronics, a.s.
640
Andrej Bican
Vajnorska
Trnava
Andrej Bican
BNY Mellon
1500
Alena Zvarska
Legionarska
Bratislava
Alena Zvarska
Vedenin, a.s.
630
Dobrota Mila
Legionarska
Bratislava
Dobrota Mila
Vedenin, a.s.
2400
Jozef Rovny
Ulica 1.maja
Dolny Kubin
Jozef Rovny
Fox, s.r.o
960
Pavol Lieskovsky
Ulica P.O.Hviezdoslava
Nitra
Pavol Lieskovsky
Protont, a.s.
590
Romana Vrbova
Agatova
Dolny Kubin
Romana Vrbova
Fox, s.r.o
940
Lukas Fransky
Ulica P.O.Hviezdoslava
Nitra
Lukas Fransky
Protont, a.s.
1950
Filip Tranovy
Dadanova
Trencin
Filip Tranovy
Safetronics, a.s.
1600
Company
Manages
Company_name
City
Person_name
Managers_name
BNY Mellon
Trnava
Michal Novak
Filip Tranovy
Safetronics, a.s.
Trencin
Peter Modry
Andrej Bican
BNY Mellon
Trnava
Alena Zvarska
Dobrota Mila
Vedenin, a.s.
Bratislava
Jozef Rovny
Romana Vrbova
Vedenin, a.s.
Bratislava
Pavol Lieskovsky
Lukas Fransky
Fox, s.r.o
Dolny Kubin
Protont, a.s.
Nitra
Fox, s.r.o
Dolny Kubin
Protont, a.s.
Nitra
Safetronics, a.s.
Trencin
tie tabulky som si spravila takto:
Employee
Works
Person_name
Street
City
Person_name
Company_name
Salary
Peter Modry
Vajnorska
Trnava
Peter Modry
BNY Mellon
2100
Michal Novak
Trnavska
Trencin
Michal Novak
Safetronics, a.s.
640
Andrej Bican
Vajnorska
Trnava
Andrej Bican
BNY Mellon
1500
Alena Zvarska
Legionarska
Bratislava
Alena Zvarska
Vedenin, a.s.
630
Dobrota Mila
Legionarska
Bratislava
Dobrota Mila
Vedenin, a.s.
2400
Jozef Rovny
Ulica 1.maja
Dolny Kubin
Jozef Rovny
Fox, s.r.o
960
Pavol Lieskovsky
Ulica P.O.Hviezdoslava
Nitra
Pavol Lieskovsky
Protont, a.s.
590
Romana Vrbova
Agatova
Dolny Kubin
Romana Vrbova
Fox, s.r.o
940
Lukas Fransky
Ulica P.O.Hviezdoslava
Nitra
Lukas Fransky
Protont, a.s.
1950
Filip Tranovy
Dadanova
Trencin
Filip Tranovy
Safetronics, a.s.
1600
Company
Manages
Company_name
City
Person_name
Managers_name
BNY Mellon
Trnava
Michal Novak
Filip Tranovy
Safetronics, a.s.
Trencin
Peter Modry
Andrej Bican
BNY Mellon
Trnava
Alena Zvarska
Dobrota Mila
Vedenin, a.s.
Bratislava
Jozef Rovny
Romana Vrbova
Vedenin, a.s.
Bratislava
Pavol Lieskovsky
Lukas Fransky
Fox, s.r.o
Dolny Kubin
Protont, a.s.
Nitra
Fox, s.r.o
Dolny Kubin
Protont, a.s.
Nitra
Safetronics, a.s.
Trencin
ivka70
10.05.12,13:07
Pozri, tu mas napr. prvu ulohu ....
ale tvoje tabulky nie su dobre, ked napr. nie kazdy zamestnanec ma managera .....
asi by mal mat managera kazdy ... nie :)
ale tvoje tabulky nie su dobre, ked napr. nie kazdy zamestnanec ma managera .....
asi by mal mat managera kazdy ... nie :)
monchi
10.05.12,18:49
v prilohe mas vyriesene ulohy pre kazdu ulohu jeden sheet, je to urobne len pre tie tabulky co si dala, ak to chces mat dynamicke treba to trochy prerobit.
/M
/M
el_bi
16.05.12,13:33
Dakujem :) v tej tabulke je 10 zamestnancov, resp. z tych 10 je 5 pracovnikov a 5 manazerov. A ti manazeri uz nemaju nad sebou dalsich manazerov. Tak to bolo myslene. Tak este raz dakujem, velmi ste mi pomohli :)