Duration: 16 minutes
Summary: In the first step in our project, we will create the database. We
are using SQL Server 2008. The version in this case does not matter because we
are not adding features that are 2008 specific. So you could user 2005 instead.
We will create the database and three tables (Users, Item, and ItemType). The
Users table to keep track of the users logging in. The Item table is for every
item we add to the inventory and ItemType is (as the name implies) the type of
items we are adding (shoes, pants, shirt...). For every table, we will add the
necessary columns and their types.
of the development of example: Good coding standard
and simplified design to illustrate the key points.
Used: Windows Applications and Visual Studio 2010
Keyword: Windows Applications, Visual Studio 2010, SQL Server, Table,
Column, Script, Insert.