Sisteme de gestiune a bazelor de date - magazin de pantofi

I. Sql server

1. Diagrama entitate – asociere

2. Crearea bazei de date

create database MagazinPantofi

3. Folosirea bazei de date

use MagazinPantofi

4. Crearea tabelelor

if OBJECT_ID ('tPantofi')is not null drop table tPantofi

create table tPantofi ( Cod_pantof int not null primary key,

Culoare char(15),

Marime int,

Firma varchar(20),

Pret money null

)

if OBJECT_ID ('tClienti') is not null drop table tClienti

create table tClienti (id_client varchar(5) not null primary key,

nume char(10),

prenume varchar(20),

CNP char(13),

Adresa varchar(25),

Procent_reducere int)

if OBJECT_ID('tFactura') is not null drop table tFactura

create table tFactura (cod_factura char(5) not null primary key,

id_client varchar(5) foreign key references tClienti(id_client),

cantitate int ,

Pret_F money null,

Data datetime)

if OBJECT_ID ('tInchirieri') is not null drop table tInchirieri

create table tInchirieri (Id_inchirieri varchar(5) not null primary key,

Cod_pantof int foreign key references tPantofi(Cod_pantof),

cod_factura char(5) foreign key references tFactura(cod_factura),

perioada varchar(10))

if OBJECT_ID('tVanzari') is not null drop table tVanzari

create table tVanzari (id_vanzari varchar (5) not null primary key ,

cod_pantof int foreign key references tPantofi(cod_pantof),

cod_factura char(5) foreign key references tFactura(cod_factura),

garantie varchar(10))