project analysis - how to start project develoment

PROJECTANALYSIS

B Y A D A R S H P A T E L

W O R K S H O P O N

http://arthtechnology.com

STPES

List Features

Find Feasibility

Study related apps/websites

Database Design

List Reports

http://arthtechnology.com

TOP 3­5 FEATURES/IMPORTANTENTITY OF ON LINE STORE

Think and write down.Remember top 5 features/points only

http://arthtechnology.com

EXAMPLE ­ FEATURES OF ON LINE STORE

Product & CategoryCustomerSalesBusinessmen - Product Maker

http://arthtechnology.com

Convention for Database naming

table name : xxx_cart_master

table name : xxx_cart_detail

column name in small letters

do not repeat column name

do not use any keywords

no use of underscore or space in column name

append column name with prefix 1/2 character

http://arthtechnology.com

Sample Database for Online Shopping

Think first 5 Tables for above project.

Write down. Make sure to think top 5 tables only.

http://arthtechnology.com

Sample Database for Online Shopping

one_category_master

one_product_master

one_user_master

one_cart_master

one_cart_detail

one_businessmen_master

http://arthtechnology.com

Sample Database for workshop management

Think first 5 Tables for above project.

Write down. Make sure to think top 5 tables only.

http://arthtechnology.com

Sample Database for workshopmanagement

wor_user_master

wor_workshop_master

wor_workshop_detail

http://arthtechnology.com

Sample Database for online quiz

Think first 5 Tables for above project.

Write down. Make sure to think top 5 tables only.

http://arthtechnology.com

Sample Database for online quiz

qui_user_master

qui_category_master

qui_question_master

qui_quiz_master

qui_quiz_detail

qui_attempt_master

qui_attempt_detail

http://arthtechnology.com

Reports

List product

List types of users

List transactions

http://arthtechnology.com

Thank you

http://arthtechnology.com