Cuprins
- Sql server 3
- 1. Diagrama entitate-asociere 3
- 2. Crearea bazei de date 4
- 3. Folosirea bazei de date 4
- 4. Crearea tabelelor 4
- 5. Inserarea datelor in tabele 5
- 5.1. Inserarea datelor in tabelul tPantofi 5
- 5.2. Inserarea datelor in tabelul tClienti 5
- 5.3. Inserarea datelor in tabelul tInchirieri 6
- 5.4. Inserarea datelor in tabelul tFactura 7
- 5.5. Inserarea datelor in tabelul tVanzari 8
- 6. Crearea procedure de reducere a pretului 9
- II. C Sharp 10
- 1. FormMain.cs 10
- 2. FormAdaugarePantofi.cs 11
- 3. FormEvidentaVanzari.cs 12
- 4. FormGridViewClienti.cs 14
- 5. FormGridViewPantofi.cs 16
- 6. FormReducereTotala.cs 17
- 7. FormVizualizarePantofi.cs 18
Extras din proiect
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))
Preview document
Conținut arhivă zip
- Sisteme de Gestiune a Bazelor de Date - Magazin de Pantofi
- SGBDAndreea
- bin
- Debug
- SGBDAndreea.exe
- SGBDAndreea.pdb
- SGBDAndreea.vshost.exe
- SGBDAndreea.vshost.exe.manifest
- obj
- x86
- Debug
- TempPE
- Properties.Resources.Designer.cs.dll
- DesignTimeResolveAssemblyReferences.cache
- DesignTimeResolveAssemblyReferencesInput.cache
- GenerateResource.read.1.tlog
- GenerateResource.write.1.tlog
- ResolveAssemblyReference.cache
- SGBDAndreea.csproj.FileListAbsolute.txt
- SGBDAndreea.exe
- SGBDAndreea.FormAdaugarePantofi.resources
- SGBDAndreea.FormEvidentaVanzari.resources
- SGBDAndreea.FormGridViewClienti.resources
- SGBDAndreea.FormGridViewPantofi.resources
- SGBDAndreea.FormMain.resources
- SGBDAndreea.FormReducereTotala.resources
- SGBDAndreea.FormVizualizarePantofi.resources
- SGBDAndreea.pdb
- SGBDAndreea.Properties.Resources.resources
- Properties
- AssemblyInfo.cs
- Resources.Designer.cs
- Resources.resx
- Settings.Designer.cs
- Settings.settings
- Resources
- 404pantof7.jpg
- 404pantof71.jpg
- descarcare (1).jpg
- descarcare.jpg
- descarcare1.jpg
- images (1).jpg
- images (1)1.jpg
- images (1)2.jpg
- images (3).jpg
- images.jpg
- images1.jpg
- pantofi.jpg
- pantofi1.jpg
- pink shoes.jpg
- pink shoes1.jpg
- FormAdaugarePantofi.cs
- FormAdaugarePantofi.Designer.cs
- FormAdaugarePantofi.resx
- FormEvidentaVanzari.cs
- FormEvidentaVanzari.Designer.cs
- FormEvidentaVanzari.resx
- FormGridViewClienti.cs
- FormGridViewClienti.Designer.cs
- FormGridViewClienti.resx
- FormGridViewPantofi.cs
- FormGridViewPantofi.Designer.cs
- FormGridViewPantofi.resx
- FormMain.cs
- FormMain.Designer.cs
- FormMain.resx
- FormReducereTotala.cs
- FormReducereTotala.Designer.cs
- FormReducereTotala.resx
- FormVizualizarePantofi.cs
- FormVizualizarePantofi.Designer.cs
- FormVizualizarePantofi.resx
- Program.cs
- SGBDAndreea.csproj
- SGBDAndreea.exe
- SGBDAndreea.pdb
- SGBDAndreea.sln
- Sisteme de Gestiune a Bazelor de Date.doc