1 / 3

Passageiro

Escalado. ISA. ISA. hab. cic. N. End. N. End. cic. Sal. Tel. DN. Empregado. Passageiro. Res. Preço. Classe. Es. Piloto. Técnico. Id. DVoo. B. HV. está- habilitado. Data. é-pilotado- por. NL. M. Fb. Cd. C. está associado a. utiliza. Tipo-Avião.

Télécharger la présentation

Passageiro

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Escalado ISA ISA hab cic N End N End cic Sal Tel DN Empregado Passageiro Res Preço Classe Es Piloto Técnico Id DVoo B HV está- habilitado Data é-pilotado- por NL M Fb Cd C está associado a utiliza Tipo-Avião Aeronave pertence Ns Hv DF usa Nv Voo Qt hp hc orig Des Peça Pr Np

  2. CREATE TABLE PASSAGEIRO (CIC INTEGER, NOME CHAR(20), ENDE CHAR(40), TEL INTEGER, PRIMARY KEY (CIC)) CREATE TABLE EMPREGADO (CIC INTEGER, NOME CHAR(20), ENDE CHAR(40), SAL NUMERIC, DN DATE, PRIMARY KEY (CIC)) CREATE TABLE VOO (NV CHAR(6), HP TIME, HC TIME, ORIG CHAR(20), DEST CHAR(20), PRIMARY KEY (NV)) CREATE TABLE PILOTO (CIC INTEGER, B CHAR(5), HV INTEGER, PRIMARY KEY (CIC), UNIQUE (B), FOREIGN KEY (CIC) REFERENCES EMPREGADO) CREATE TABLE TECNICO (CIC INTEGER, ES CHAR(15), PRIMARY KEY (CIC), FOREIGN KEY (CIC) REFERENCES EMPREGADO) CREATE TABLE PECA (NP INTEGER, Pr NUMERIC, PRIMARY KEY (NP)) CREATE TABLE DVOO (ID INTEGER, Data DATE, NV CHAR(6), CIC INTEGER, NS INTEGER, PRIMARY KEY (NP), FOREIGN KEY (NV) REFERENCES VOO, FOREIGN KEY (CIC) REFERENCES PILOTO, FOREIGN KEY (NS) REFERENCES AERONAVE)

  3. CREATE TABLE AERONAVE (NS INTEGER, HV INTEGER, DF DATE, Cd CHAR(4), PRIMARY KEY (NS), FOREIGN KEY (Cd) REFERENCES Tipo-AVIAO) CREATE TABLE TIPO-AVIAO (Cd CHAR(4), MODELO CHAR(20), FABR CHAR(20), NLUGARES INTEGER, COMPR INTEGER, PRIMARY KEY (Cd)) CREATE TABLE RES (CIC INTEGER, ID INTEGER, CLASSE CHAR(15), PRECO NUMERIC, PRIMARY KEY (CIC,ID), FOREIGN KEY (CIC) REFERENCES PASSAGEIRO, FOREIGN KEY (ID) REFERENCES DVOO) CREATE TABLE ESCALADO (ID INTEGER, CIC INTEGER, PRIMARY KEY (ID,CIC), FOREIGN KEY (CIC) REFERENCES EMPREGADO, FOREIGN KEY (ID) REFERENCES DVOO) CREATE TABLE USA (Cd CHAR(4), NP INTEGER, Qt INTEGER, PRIMARY KEY (Cd,NP), FOREIGN KEY (Cd) REFERENCES Tipo-AVIAO, FOREIGN KEY (NP) REFERENCES PECA) CREATE TABLE HABILITADO (Cd CHAR(4), CIC INTEGER, PRIMARY KEY (ID,CIC), FOREIGN KEY (CIC) REFERENCES EMPREGADO, FOREIGN KEY (Cd) REFERENCES Tipo-AVIAO)

More Related