HƯỚNG DẪN LÀM ỨNG DỤNG SHOPPING CART

1. video số 1 : Xem demo ứng dụng 

  Video 1 - part 2

  2. Video số 2 :  Cài đặt Eclipse và Mysql 

Part 2  : Cài đặt Eclipse

3. Video số 3 : Tạo database   

Script  : Script:dbcreate.txt  

-- Drop Database if already existing
-- drop database cart;

-- Create database as Cart
create database cart;

-- Use database Cart for Creation of Database.
use cart;

-- Drop all the tables if already exiting
drop table  menu;  --  This table will have data of all generalized menu option for each role
drop table  usernm; -- This table will have data of users with name,password, hint with answer and address
drop table  system;  -- This table will have name of company with address and bottom page message for which website is created
drop tables items;   -- This table will have list of Items to select with its details
drop tables catg_mas;   --  This table will have data for categories to choose and filter items
drop tables catg_details;  -- This table will have data for various offers
drop tables items_reviews;  -- This table will have data for feedback
drop tables items_payment_options;  -- This table will have data for payment options like cod,netbanking
drop tables items_delivery_available_pin ; -- This table will have data where all the items can be dispatched
drop table cart;
drop table payments;
drop table schedule;
drop table schedule_mas;
drop table seller;

-- Create Menu with options.
create table menu (id int(4) UNSIGNED AUTO_INCREMENT PRIMARY KEY,menucode varchar(5),menu_short_name varchar(10),menu_long_name varchar(20),menu_run_option varchar(50),menu_order int(4),role varchar(15));

-- Create User and Login details
create table usernm (id int(4) unsigned auto_increment primary key,user varchar(8),password varchar(8),role varchar(15),create_date date,hint varchar(50),hint_ans varchar(15),user_name varchar(25),user_email varchar(50),gender varchar(1),dob date,mobile int(10),address varchar(100));

-- Create Company and System Details
create table system (id int(4) unsigned auto_increment primary key,company_name varchar(20),add1 varchar(25),add3 varchar(25), bottom_message varchar(25));

-- Create Items to sell
create table items (id int(4) unsigned auto_increment primary key,
item_category_code varchar(10),
item_code varchar(10),
item_short_desc varchar(25),
item_long_desc varchar(50),
item_image varchar(20),
item_color varchar(10),
item_warranty int(4),
item_size varchar(10),
item_value double(8,2),
delivery_days int(4));

-- Create Items to sell by seller
create table seller (id int(4) unsigned auto_increment primary key,
seller_code varchar(10),
seller_name varchar(30),
seller_address varchar(100),
seller_mob int(10),
item_code varchar(10),
item_value double(8,2));

-- Create item delivery and pin availability
create table items_delivery_available_pin (id int(4) unsigned auto_increment primary key,
item_code varchar(10),
pin varchar(10));


-- Create table for payment options
create table items_payment_options (id int(4) unsigned auto_increment primary key,
item_code varchar(10),
payment_options varchar(10));

-- Create table for delivery options based on pin code
create table items_reviews (id int(4) unsigned auto_increment primary key,
item_code varchar(10),
reviews varchar(50),
customer_code varchar
(10),
dated date);

-- Create table for category to filter items
create table catg_mas (id int(4) unsigned auto_increment primary key,
catg_code varchar(10),
catg_discount_scheme varchar(10));

-- Create table for category details for offers to be provided
create table catg_details (id int(4) unsigned auto_increment primary key,
discounts_provider_name varchar(10),
discounts_details varchar(50),
discounts_value int(4),
discounts_pers int(4));

-- Create table to store data for Items saved in cart selected by user for each seller
create table cart (id int(4) unsigned auto_increment primary key,
usercode varchar(8),
shopper varchar(8),
item_code varchar(10),
item_value double(8,2),
cart_date date);

-- Create table payments made with status
create table payments (id int(4) unsigned auto_increment primary key,
usercode varchar(8),
shopper varchar(8),
item_code varchar(10),
payment_option varchar(10),
payment_date date,
payment_status varchar(8));

-- Create table to save data for schedule/movement of Item lying at different stages
create table schedule (id int(4) unsigned auto_increment primary key,
usercode varchar(8),
shopper varchar(8),
item_code varchar(10),
schedule_order int(4),
schedule_type varchar(30),
schedule_date date);

-- Create table as a master for stages of dispatch
create table schedule_mas (id int(4) unsigned auto_increment primary key,
schedule_order int(4),
schedule_type varchar(30));