Proyect niit

Nombre ,Tecnico en punto .net, nombre del proyecto
Shop Here
Project ON

Developed by

Ramiro Esquivel Duran

104920Name: Reg. No:

Proyect Title

Name of the Developer :
Ramiro Esquivel Duran
04/09/2010
27/11/2010
End Date :
Adarsh bhardwaj
Name of theCoordinator :
Date of Submission :
23/10/2010
104920
Start Date :
Batch Code :

Coordinator:
This is to certify thet this report titled ___Shop Here_____________________
embodies the originalwork done by _Ramiro Esquivel_Duran____ in partial fulfillment of their course requirement at NIIT.
Certificate

Adarsh bhardwaj

Acknowledgement
Acknowledgement

System Analysis

SystemAnalysis

DataBase Design

ShopHere
4
5
1. Employee
2. OrderDetails
3. ItemDetails
4. Supplierdetails
5. ProductCategory
Tables Names:
Number of Tables:
1.HumanResources
2. Transactions
3. Items
4. Supplier
Schemas Name:
Number of Schemas:
Database Name:

Database Name:
Schematic diagram of the database

Shop Here

Field Name | Data Type |Width | Description |
EmployeeID | int | | Employee number |
FirstName | Varchar | 20 | Employee First Name |
LastName | Varchar | 20 | Employee Last Name |
City | Varchar | 10 | Employee city|
Phone | Varchar | 16 | Phone Number |
| |
Employee
Database Name:
table design

Database Name:
ItemDetails

Field Name | Data Type | Width | Description |
ItemID | int | |ItemDetailsNumber |
ItemName | varchar | 15 | Name of Item |
ItemDescription | varchar | 30 | Description of Item |
UnitPrice | int | | Uniti Price |
QuantityInHand | int | | Quantity Dispo |ReorderLevel | int | | Level of Reorder |
CategoryID | int | | Category Number |
SupplierID | int | | Supplier Number |

Database Name:
ProductCategory
eewewewewewewewewew
Field Name | Data...