In this tutorial we will show how to collect requirement and analysis database by the requirement. This part is very important for application or software development. When we create a project then first analysis the requirement by which type project we create. Now my case we will create a Point of sale (POS) application. Now given bellow the working process step by step.
First open the excel file, from the start penal. Then thing highly how many tables we need for the application and write the table name on the excel.
Then we need to know how many rows we need and also, we need to understand pk and fk relationship of the table. Then write column field name.
Now given bellow my project tables name and column name:
we can see our table name and table field name. Next tutorial we will show how to create database and database table in MS-SQL server management studio also show the relation of the tables.