Sisteme de Gestiune a Bazelor de Date - Magazin de Pantofi

Cuprins proiect Cum descarc?

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 Cum descarc?

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))


Fisiere in arhiva (68):

  • Sisteme de Gestiune a Bazelor de Date - Magazin de Pantofi
    • SGBDAndreea
      • bin
        • Debug
          • SGBDAndreea.exe
          • SGBDAndreea.pdb
          • SGBDAndreea.vshost.exe
          • SGBDAndreea.vshost.exe.manifest
      • 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
      • obj
        • x86
          • Debug
            • 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
            • TempPE
              • Properties.Resources.Designer.cs.dll
      • Program.cs
      • 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
      • SGBDAndreea.csproj
    • SGBDAndreea.exe
    • SGBDAndreea.pdb
    • SGBDAndreea.sln
    • Sisteme de Gestiune a Bazelor de Date.doc

Imagini din acest proiect Cum descarc?

Banii inapoi garantat!

Plateste in siguranta cu cardul bancar si beneficiezi de garantia 200% din partea Proiecte.ro.


Descarca aceast proiect cu doar 5 €

Simplu si rapid in doar 2 pasi: completezi adresa de email si platesti.

1. Numele, Prenumele si adresa de email:

Pe adresa de email specificata vei primi link-ul de descarcare, nr. comenzii si factura (la plata cu cardul). Daca nu gasesti email-ul, verifica si directoarele spam, junk sau toate mesajele.

2. Alege modalitatea de plata preferata:



* Pretul este fara TVA.


Hopa sus!