Question

Imi trebuie urgent,In sql

Answer 1

Răspuns:

Use master

go

create DataBase CrediteBancare

go

use  CrediteBancare

create table Credite

( ID_Credit int PRIMARY KEY,

Suma nvarchar(30) NOT NULL,

Procente nvarchar(30) NOT NULL,

Termen_de_Platire nvarchar(10) DEFAULT('-') UNIQUE,

)

create table Clienti_Fizici

( ID_Client int PRIMARY KEY,

NR_Buletin nvarchar(30) NOT NULL,

Loc_Munca nvarchar(30) NOT NULL,

Nume nvarchar(30) NOT NULL,

Prenume nvarchar(10) DEFAULT('-') UNIQUE,

Adresa nvarchar (25) NOT NULL,

NR_Telefon nvarchar (20) NOT NULL,

Credit int FOREIGN KEY references Credite (ID_Credit),

)

create table Clienti_

( ID_Client int PRIMARY KEY,

Cod_fiscal nvarchar(30) NOT NULL,

Denumire nvarchar(30) NOT NULL,

Tipul_de_proprietate nvarchar(30) NOT NULL,

Nume_administrator nvarchar(10) NOT NULL,

Adresa nvarchar (25) NOT NULL,

NR_Telefon nvarchar (20) NOT NULL,

Persoană_de_contact nvarchar (20) NOT NULL,

Credit int FOREIGN KEY references Credite (ID_Credit),

)

Explicație: pentru creare lam facut a ramas sa scrii in fiecare tabel cite 20 de date