Creare Tabele la Baze de Date

create table COD_POSTAL(

Codpostal numeric (6) constraint PK_Codpostal PRIMARY KEY ,

Judet varchar (30),

Localitate varchar (35)

);

create table PERSOANE2(

Idpers varchar(10) constraint PK_Idpers PRIMARY KEY,

CNP_PERS NUMERIC (13) unique not null,

Nume_pers varchar (200) not null,

Adresa varchar (200),

Ocupatie varchar (50),

Loc_munca varchar (50),

Tel_fix numeric (10),

Mobil numeric (10),

Fax numeric (10),

Email varchar (50),

Codpostal numeric (6) CONSTRAINT FK_PERSOANE2_COD_POSTAL REFERENCES COD_POSTAL (Codpostal));

create table GRUPA(

IdGrupa varchar (6) constraint PK_IdGrupa primary key,

Tip_grupa varchar (15) constraint ck_Tip_grupa check (Tip_grupa in ('mica', 'mijlocie', 'mare', 'pregatitoare'))

);

create table EDUCATOARE(

IdEducatoare varchar (10) constraint PK_IdEducatoare primary key, constraint fk_IdEducatoare foreign key(IdEducatoare) references PERSOANE2(Idpers) on delete restrict on update cascade,

Program varchar (10) constraint ck_Program check(Program in ('Normal', 'Prelungit')),

IdGrupa varchar (15) constraint FK_EDUCATOARE_GRUPA references GRUPA (IdGrupa)

);

create table FAMILIE(

IdFamilie varchar (10) constraint pk_IdFamilie primary key,

Nr_copii_familie numeric(20),

Venit_familie numeric (15)

);

create table MAME (

IdMama varchar (10) constraint pk_IdMama primary key,constraint fk_IdMama foreign key(IdMama) references PERSOANE2(Idpers) on delete restrict on update cascade,

IdFamilie varchar(10) constraint fk_MAME_FAMILIE references FAMILIE(IdFamilie)on delete restrict on update cascade,

Venit_mama numeric (15)

);

create table TATI(

IdTata varchar(10) constraint pk_IdTata primary key,constraint fk_IdTata foreign key(IdTata) references PERSOANE2(Idpers) on delete restrict on update cascade,

IdFamilie varchar(10) constraint fk_TATI_FAMILIE references FAMILIE(IdFamilie)on delete restrict on update cascade,

Venit_tata numeric(15)

);

Create table TUTORE(

IdTutore varchar(10) constraint pk_IdTutore primary key,constraint fk_IdTutore foreign key(IdTutore) references PERSOANE2(Idpers) on delete restrict on update cascade,

IdFamilie varchar(10) constraint fk_TUTORE_FAMILIE references FAMILIE(IdFamilie)on delete restrict on update cascade,

Venit_tutore numeric(15)

);

create table BOLI(

CodBoala varchar(5) constraint pk_CodBoala primary key,

DenBoala varchar(160)

);

create table FISA_MEDICALA(

NrFisaMed numeric(20) constraint pk_NrFisaMed primary key,

DataFisa date

);

create table LINII_FISA_MEDICALA(

NrFisaMed numeric(20) constraint fk_LINII_FISA_MEDICALA_FISA_MEDICALA references FISA_MEDICALA(NrFisaMed),

LinieFisa numeric (5),

CodBoala varchar(5),

DataDepistare date,

constraint pk_LINII_FISA_MEDICALA primary key(NrFisaMed, LinieFisa)

);

create table PREZENTA (

IdFisaPrez varchar (10) unique not null,

LiniePrezenta numeric (5),

DataPrezenta date,

constraint pk_PREZENTA primary key(IdFisaPrez)

);

create table COPII(

IdCopil varchar (10) constraint pk_IdCopil primary key ,

CNPCopil numeric(13) unique not null,

Nume varchar(200) not null,

Data_nasterii date,

Varsta numeric(1) constraint ck_COPII check (Varsta >2),

IdFamilie varchar (10) constraint fk_COPII_IdFamilie references FAMILIE(IdFamilie)on delete restrict on update cascade,

Data_inscrierii date ,

Program varchar (10) constraint ck_Program check(Program in ('Normal', 'Prelungit')),

IdGrupa varchar(6) constraint fk_COPII_GRUPA references GRUPA(IdGrupa)on delete restrict on update cascade,

NrFisaMed numeric(20) constraint fk_COPII_FISA_MEDICALA references FISA_MEDICALA(NrFisaMed)on delete restrict on update cascade,

IdFisaPrez varchar (10) constraint fk_COPII_PREZENTA references prezenta(idfisaprez)on delete restrict on update cascade