Sisteme de Gestiune a Bazelor de Date - Magazin de Pantofi

Imagine preview
(8/10 din 1 vot)

Acest proiect trateaza Sisteme de Gestiune a Bazelor de Date - Magazin de Pantofi.
Mai jos poate fi vizualizat cuprinsul si un extras din document (aprox. 2 pagini).

Arhiva contine 68 fisiere doc, jpg, exe, txt, manifest, csproj, sln, pdb, settings, dll, cache de 19 pagini (in total).

Iti recomandam sa te uiti bine pe extras, cuprins si pe imaginile oferite iar daca este ceea ce-ti trebuie pentru documentarea ta, il poti descarca. Ai nevoie de doar 6 puncte.

Domenii: Stiinta Administratiei, Calculatoare, Management

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 document

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

Alte informatii

UNIVERSITATEA DIN PITESTI FACULTATEA DE MATEMATICA – INFORMATICA SPECIALIZAREA: INFORMATICA