The design of database table for developing e-commerce website with asp.net

System Analysis

Functional Requirements Analysis

(1): Product display, according to the classification of all products, and corresponding relevant information.

(2): Increase product display relevance, such as the latest product coverage, website news, promotional information.

(3): Shopping cart, tracking the user's shopping situation

(4): Settlement Center: Processing user billing, shopping processing

(5): Feedback interactive area, you can leave a message

(6): Member information module, you can register

Data requirements Analysis

database table design is set to 8 table implementations:

ccdot_user{User Information Table}:

------SZD_USERID[PK]

------szd_username[User ID]

------szd_password[User Password]

------szd_name[users really information]

------szd_question[lost Password problem]

------szd_answer[users to answer the answer, to find the password]

------szd_sex[Sex]

------szd_phone[Phone]

------szd_email[e-mail]

------szd_address[Address]

------szd_post[Postal Code]

------Szd_province[Province]

------szd_city[City]

------szd_mark[Mark]

ccdot_aclass{products Big Class}

------SZD_ACLASSID[PK]

------szd_aclassname[Name]

ccdot_bclass{Products Small Class}

------SZD_BCLASSID[PK]

------Szd_aclassid[Association major class Szd_aclassid]

------szd_bclassname[Name]

ccdot_poduct{Product Information}

------SZD_PRODUCTID[PK]

The Szd_bclassid of the Szd_bclassid[Association small class of------]

------szd_pname[Name]

------szd_pdetail[Product Information]

------szd_pprice[General Price]

------szd_pmemderprice[member Price]

------szd_pfewprice[Spreads]

------szd_ppicture[Pictures]

------szd_ptime[Add Time]

------szd_stock[Product Inventory]

------szd_phit[Product Clicks]

------szd_pdetail1[Other Product descriptions]