CREATE DATABASE dbSecretariat
ON
PRIMARY ( NAME= SecretariatO4,
	FILENAME ='C:\laboratorBD\testeSQL2004\Secretariat_1.mdf',
	SIZE = 10 ,
	MAXSIZE = 40,
	FIlEGROWTH= 2),
FILEGROUP data2_file_grup
( NAME = secretariatO4_2,
	FILENAME='C:\laboratorBD\testeSQL2004\Secretariat_2.ndf' ,
	SIZE = 10 ,
	MAXSIZE = 20 ,
	FILEGROWTH= 2),
( NAME = secretariat04_3,
	FILENAME ='C:\laboratorBD\testeSQL2004\Secretariat_3.ndf' ,
	SIZE = 10 ,
	MAXSIZE = 20,
	FILEGROWTH = 2)
LOG ON
	( NAME = SecretariatO4_log1,
	FILENAME ='C:\laboratorBD\testeSQL2004\Secretariat2004log_1.ldf' ,
	SIZE = 10 ,
	MAXSIZE = 20 ,
	FILEGROWTH= 2),
( NAME = Secretariat04_log2,
	FILENAME ='C:\laboratorBD\testeSQL2004\Secretariat2004log_2.ldf' ,
	SIZE = 10 ,
	MAXSIZE = 20,
	FILEGROWTH = 5%)

USE dbSecretariat

CREATE TABLE tblStudent
	(Nrleg char(8) PRIMARY KEY,
	Nume varchar (35)NOT NULL,
	Initiala varchar(8),
	Prenume varchar(35)NOT NULL,
	Sex char(1)NOT NULL DEFAULT ('F'),
	DataNastere datetime,
	StareCivila char(1)NOT NULL DEFAULT('N')
	)	ON [PRIMARY]


CREATE TABLE tblTelefonStud(
	NrLeg char(8) NOT NULL,
	NrTelefon varchar(10),
	Interior varchar(4),
	Observatii varchar(30)
)

ALTER TABLE tblTelefonStud
ADD CONSTRAINT codTel_FK
	FOREIGN KEY (NrLeg) REFERENCES tblStudent(NrLeg)
	ON DELETE CASCADE ON UPDATE CASCADE
GO

EXEC sp_help tblTelefonStud
EXEC sp_helpconstraint tblTelefonStud

DROP TABLE TblStudent
DROP TABLE TblTelefonStud