Dsy Network>  www | forum | my | didattica | howto | wiki | el goog | stats | blog | dona | rappresentanti
Homepage
 Register   Calendar   Members  Faq   Search  Logout 
.dsy:it. : Powered by vBulletin version 2.3.1 .dsy:it. > Didattica > Corsi A - F > Basi di dati ~ informatica triennale > risposte esame 22 settembre 2009
Pages (3): [1] 2 3 »   Last Thread   Next Thread
Author
Thread    Expand all | Contract all    Post New Thread    Post A Reply
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
 risposte esame 22 settembre 2009

Ciao a tutti
voi come avete risposto alle domande a crocette ?

io per quello che mi ricordo ho messo:
1) quella sulla gerarchia ho messo "nessuna delle precedenti"
2) quella sul trigger/ cursore ho messo "che ritorna vero se prelievo è non superiore al limite max_prelievo"
3) quella della dipendenza funzionale b->a ho messo "che se 2 att b sono uguali allora anche i 2 a lo sono
4)quella della vista ho messo quella con tutta la chiave risposta c
5) non mi ricordo che domanda era

.-.-... speriamo in bene....
23-09-2009 11:11
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
dArkLuis
.amico.

User info:
Registered: Apr 2008
Posts: 34 (0.01 al dì)
Location: Milano
Corso: informatica
Anno: 1
Time Online: 1 Day, 0:14:24 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

anch'io ho risposto come te. cmq la 5 era quella della indipendenza fisica.
23-09-2009 15:12
Click Here to See the Profile for dArkLuis Click here to Send dArkLuis a Private Message Find more posts by dArkLuis Add dArkLuis to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

ah vero in quella cosa hai messo ?
Grazie
23-09-2009 17:10
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
dArkLuis
.amico.

User info:
Registered: Apr 2008
Posts: 34 (0.01 al dì)
Location: Milano
Corso: informatica
Anno: 1
Time Online: 1 Day, 0:14:24 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

sinceramente quella lo sparata, cmq ho messo b, cioè modifiche fisiche comporatano modifiche logiche ma non so...:?
23-09-2009 19:01
Click Here to See the Profile for dArkLuis Click here to Send dArkLuis a Private Message Find more posts by dArkLuis Add dArkLuis to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

io ho messo come te dato che chiedeva cosa era in contraddizione con il concetto di indipendenza fisica.
speriam !
23-09-2009 19:06
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Paolo71
.primate.

User info:
Registered: Mar 2005
Posts: 73 (0.01 al dì)
Location: Milano
Corso: Informatica
Anno: 1
Time Online: 1 Day, 5:33:24 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
 :)

Ciao,
idem come voi :))

__________________
Paolo~
24-09-2009 10:50
Click Here to See the Profile for Paolo71 Click here to Send Paolo71 a Private Message Find more posts by Paolo71 Add Paolo71 to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

ottimo !
per quanto riguarda il secondo esercizio io ho messo cosi:

create Table automobile(
Targa varchar primary key not null,
Marca varchar,
Modello varchar,
AnnoImmatricolazione date not null,
CategoriaNoleggio varchar,
Filiale vafrchar References filiale(codiceFiscale),
check Marca <> Modello);

In questo modo mi sembra di avere messo sia vincoli di dominio (not null) e di tupla il check....


per la grant invece:

grant insert,update of categorianoleggio,filiale on automobili to gestorenoleggio;

Che ne dite ?

PS: le cardinalita dell'ultimo esercizio non me le ricordo xD
24-09-2009 16:48
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

ma quando escono sti voti ?!
26-09-2009 08:33
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

nel secondo esercizio, quello della creazione della tabella automobile non chiedeva di specificare i vincoli di integrita referenziale come on update on delete etc ?! vero ????

Last edited by Metteus on 26-09-2009 at 16:05
26-09-2009 16:01
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Paolo71
.primate.

User info:
Registered: Mar 2005
Posts: 73 (0.01 al dì)
Location: Milano
Corso: Informatica
Anno: 1
Time Online: 1 Day, 5:33:24 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
 ?

Onestamente non ricordo, ma a memoria direi di si...
Anch'io sono quì ad aspettare questi risultati!!! Speriamo che almeno oggi...

__________________
Paolo~
28-09-2009 08:25
Click Here to See the Profile for Paolo71 Click here to Send Paolo71 a Private Message Find more posts by Paolo71 Add Paolo71 to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
 Re: ?

Originally posted by Paolo71
Onestamente non ricordo, ma a memoria direi di si...
Anch'io sono quì ad aspettare questi risultati!!! Speriamo che almeno oggi...


cioè veniva chiesto cose del tipo: non si puo cancellare un auto se c'è una filiale etc?? ??
28-09-2009 10:23
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
dArkLuis
.amico.

User info:
Registered: Apr 2008
Posts: 34 (0.01 al dì)
Location: Milano
Corso: informatica
Anno: 1
Time Online: 1 Day, 0:14:24 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

ma no, io ricordo che non specificava in caso di aggiornamento e cancellazione quindi non si inseriva nient'altro...
28-09-2009 11:14
Click Here to See the Profile for dArkLuis Click here to Send dArkLuis a Private Message Find more posts by dArkLuis Add dArkLuis to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Paolo71
.primate.

User info:
Registered: Mar 2005
Posts: 73 (0.01 al dì)
Location: Milano
Corso: Informatica
Anno: 1
Time Online: 1 Day, 5:33:24 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

No, infatti, non vi erano richieste specifiche...

__________________
Paolo~
28-09-2009 11:16
Click Here to See the Profile for Paolo71 Click here to Send Paolo71 a Private Message Find more posts by Paolo71 Add Paolo71 to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Metteus
.precettore.

User info:
Registered: Oct 2007
Posts: 94 (0.01 al dì)
Location:
Corso:
Anno:
Time Online: 13:20:48 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

ah ok meno male :D
kmq nel comando grant non andava messo l'"of" , dite che conta tutto sbagliato ?
28-09-2009 11:31
Click Here to See the Profile for Metteus Click here to Send Metteus a Private Message Find more posts by Metteus Add Metteus to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
Paolo71
.primate.

User info:
Registered: Mar 2005
Posts: 73 (0.01 al dì)
Location: Milano
Corso: Informatica
Anno: 1
Time Online: 1 Day, 5:33:24 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
 ESITI

Ciao,
scusate, qualcuno ha idea di quando escano i risultati?!?

Grazie e ciao
Paolo

__________________
Paolo~
29-09-2009 11:56
Click Here to See the Profile for Paolo71 Click here to Send Paolo71 a Private Message Find more posts by Paolo71 Add Paolo71 to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
All times are GMT. The time now is 05:58.    Post New Thread    Post A Reply
Pages (3): [1] 2 3 »   Last Thread   Next Thread
Show Printable Version | Email this Page | Subscribe to this Thread | Add to Bookmarks

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is ON
 

Powered by: vBulletin v2.3.1 - Copyright ©2000 - 2002, Jelsoft Enterprises Limited
Mantained by dsy crew (email) | Collabora con noi | Segnalaci un bug | Archive | Regolamento | Licenze | Thanks | Syndacate
Pagina generata in 0.078 seconds (79.44% PHP - 20.56% MySQL) con 23 query.