Setting Up Database - Course Windows Application: Store Inventories - Part 2 | DevMedia .net courses

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.

Methodology of the development of example: Good coding standard and simplified design to illustrate the key points.

Technology Used: Windows Applications and Visual Studio 2010

Keyword: Windows Applications, Visual Studio 2010, SQL Server, Table, Column, Script, Insert.