E-COMMERCE & TECHNOLOGY

QUESTION

Description of the Task

Groups of students (minimum 2, maximum 4) will develop an e-commerce website prototype for a small business enterprise in the confectionary industry (IMPORTANT: no other industry may be chosen for this assignment).

Note: The level of complexity of the website and depth of detail in the documentation will contribute to the mark accordingly.

Evaluation:

Part 1: Website Development Planning Report (14 marks total)

The report will consist of at least the following:

1)       Analysis (5 marks)

a)   Clearly identify the goals of the business (0.5 marks), the target market and demand (0.5 marks), and outline specific objectives of the website (1 mark).

b)   Provide a reliable analysis of needs, which must include both business and stakeholder requirements for use of the website (2 marks).

c)    Identify appropriate metrics to measure objectives (1 mark).

2)       Development (7 marks)

d)   Detail the development lifecycle: requires a logical description (what needs to happen) (1 mark), followed by a physical description (how it will happen) (1 mark).

e)   Provide clear reasons for choices made, and report limitations inherent in these choices, including for (0.5 marks each = 5 marks):

i)     development tools and scripting language(s).

ii)   payment systems.

iii)  database.

iv)  security and privacy management.

v)   inclusions (e.g. media, links, community, documentation).

vi)  customer service and communications.

vii) website style and aesthetic design.

viii)       website structure.

ix)  compatibility.

x)   scalability.

 

3)       Presentation (2 marks)

f)    The report will address the following qualitative features/concerns (0.5 marks each):

i)     a title page and table of contents, and lists of tables/figures, as required.

ii)          appropriate use of headings, tables/graphs/images, appendices and references.

iii)  correct spelling and grammar throughout report.

iv)  logical structure to the report – complete, consistent and comprehensible.

Part 2: Presentation of a Complete Prototype Website (16 marks total)

1)       Prototype Functionality (13 marks)

The prototype e-commerce website will contain at least the following functionality:

a)   All information a reasonable person might require about the company before undertaking an e-commerce transaction (1 mark).

b)   Requirements for customers to provide personal or sensitive information are appropriate and there is appropriate reassurance about the security (1 mark) and privacy (1 mark) of that information.

c)    All product information (0.5 marks) and search capabilities (1 mark) that a reasonable person might require before undertaking a transaction.

d)   Shopping cart design is appropriate to meet business information and customer usage needs (1 mark).

e)   All the customisation of the product, service and/or price that a reasonable customer might expect (1 mark).

f)    All the payment and delivery options that would be generally appropriate, convenient and reassuring to the reasonable customer (1 mark).

g)   A clear indication of a commitment to after-sales customer support and service (1 mark).

h)   An appropriate and functional database to store product information (0.5 marks), customer information (1 mark) and transaction information (1 mark).

i)     Consistent, aesthetically pleasing design (0.5 marks) promoting the brand (0.5 marks).

j)    Error-free and quick loading pages (0.5 marks), with several easy-to-use navigation options (0.5 mark).

2)       In-Class Presentation (3 marks)

Group members comprehensively give an in-class demonstration of their website to, and answer questions raised by, the tutor:

a)   Website features: each student must successfully demonstrate their individual contribution (1 mark) and explain it in a clear manner (e.g. complete, concise, informative and interesting) (1 mark).

b)   Questions: each student must appropriately answer questions on how the website meets business or customer needs (1 mark).

Notes to assist students in completing this assignment:

  • Report: The report must be professionally presented and employ an appropriate report structure, including a titlepage, table of contents, introduction and relevant appendices (e.g. information supporting development choices, structural diagrams of the site, dataflow, use-cases and databases). A title page must include details of the course, assignment, tutor, all group members (names and student numbers), and note their levels of contribution (as percentages of total group work). The document must be well presented (i.e. look professional), with appropriate language for a tech-savvy business audience, and with correct spelling and grammar. The report must include correct and complete citations and referencing, if other material/information is used to develop the report.
  • Prototype. Any Web application development tools may be used to implement the e-Commerce website prototype – it must be fully functional but with limited datasets and on-site information, and also with limited security features.
  • Demonstration. All features and functionality of the prototype must be demonstrated on the classroom computers. The demonstration must show the website functionality meeting underlying business and other stakeholder needs. All group members must equitably contribute to the in-class presentation.
  • Plagiarism. Plagiarism will not be tolerated. All reports and prototype websites must be original. Each group must submit a signed statement of originality with the report.

SOLUTION

— phpMyAdmin SQL Dump
— version 3.4.5
— http://www.phpmyadmin.net

— Host: localhost
— Generation Time: Jun 08, 2012 at 01:35 PM
— Server version: 5.5.16
— PHP Version: 5.3.8

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
SET time_zone = “+00:00″;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


— Database: `my_db`

— ——————————————————–


— Table structure for table `contact_us`

CREATE TABLE IF NOT EXISTS `contact_us` (
`reciver_mail` varchar(30) NOT NULL,
`first_name` varchar(50) DEFAULT NULL,
`last_name` varchar(50) DEFAULT NULL,
`comp_name` varchar(50) DEFAULT NULL,
`add1` text,
`add2` text,
`city` varchar(30) DEFAULT NULL,
`state` varchar(30) DEFAULT NULL,
`zip_code` int(6) DEFAULT NULL,
`phone_no` int(13) DEFAULT NULL,
`sender_mail` varchar(50) DEFAULT NULL,
`know_resion` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


— Dumping data for table `contact_us`

INSERT INTO `contact_us` (`reciver_mail`, `first_name`, `last_name`, `comp_name`, `add1`, `add2`, `city`, `state`, `zip_code`, `phone_no`, `sender_mail`, `know_resion`) VALUES
(‘sample@gmail.com’, ‘Deepak’, ‘singh’, ‘HCL’, ‘mayur vihar’, ‘delhi’, ‘delhi’, ‘delhi’, 110066, 2147483647, ‘depk08@gmail.com’, ‘no reasion’),
(‘sample@gmail.com’, ‘sdf’, ‘fsfsdfdsf’, ‘sdfsfsf’, ‘sdfsdfsd’, ‘fsdfsdfffsfsfsdf’, ‘fsd’, ‘fdsfsddsf’, 110044, 2147483647, ‘depk08@gmail.com’, ‘By teachers’);

— ——————————————————–


— Table structure for table `login`

CREATE TABLE IF NOT EXISTS `login` (
`username` varchar(20) NOT NULL,
`password` text NOT NULL,
`address` varchar(75) NOT NULL,
`mobile_no` int(10) NOT NULL,
`pincode` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


— Dumping data for table `login`

INSERT INTO `login` (`username`, `password`, `address`, `mobile_no`, `pincode`) VALUES
(‘www’, ‘4eae35f1b35977a00ebd8086c259d4c9’, ‘www’, 1234567890, 123456),
(‘adesh’, ’65f0c516de420e16d2853adcf9f41042′, ‘new delhi’, 1234567890, 110096);

— ——————————————————–


— Table structure for table `persons`

CREATE TABLE IF NOT EXISTS `persons` (
`FirstName` varchar(15) DEFAULT ”,
`LastName` varchar(15) DEFAULT NULL,
`dob` date DEFAULT NULL,
`id` int(50) NOT NULL AUTO_INCREMENT,
`password` varchar(10) NOT NULL DEFAULT ”,
`sex` char(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;


— Dumping data for table `persons`

INSERT INTO `persons` (`FirstName`, `LastName`, `dob`, `id`, `password`, `sex`) VALUES
(‘Glenn1’, ‘Quagmire’, ‘0000-00-00’, 1, ”, ”),
(‘pavan’, ‘kumar’, ‘0000-00-00’, 2, ”, ”),
(‘KHALIL’, ‘JI’, ‘1990-06-03’, 9, ‘kdwwmwmdkl’, ‘male’),
(‘jamal’, ‘jain’, ‘0000-00-00’, 12, ”, ”),
(‘pavan.’, ‘kumar’, ‘0000-00-00’, 34, ”, ”),
(‘hemat .’, ‘kumar’, ‘0000-00-00’, 35, ”, ”),
(‘mayank.’, ‘shrmaw’, ‘0000-00-00’, 36, ‘sharma’, ‘male’),
(‘mayank.’, ‘shrma’, ‘0000-00-00’, 37, ‘shrma’, ‘male’),
(‘mayank.’, ‘sharma’, ‘0000-00-00’, 38, ‘sharma’, ‘male’),
(‘gd.’, ‘gfhxdgf’, ‘0000-00-00’, 39, ‘uuuuuu’, ‘dfdd’);

— ——————————————————–


— Table structure for table `send_mail`

CREATE TABLE IF NOT EXISTS `send_mail` (
`Subject` varchar(50) DEFAULT NULL,
`Detail` varchar(250) DEFAULT NULL,
`Name` varchar(50) DEFAULT NULL,
`Email` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


— Dumping data for table `send_mail`

INSERT INTO `send_mail` (`Subject`, `Detail`, `Name`, `Email`) VALUES
(‘info’, ‘jbkncwlelncwndxwxcknsnclxnsdc\r\nscscnsdcnsdncsdlncsdlcnsdlncksancxksacxsac\r\n\r\nsacs\r\nc’, ‘Ajeet’, ‘ajeet@gmail.com’),
(‘contact’, ‘ ndkcdwwqwd wwwdww\r\nwdwm;wmdwkd’, ‘Asgar’, ‘asgar@gmail.com’),
(‘detail’, ‘lefmwe;lmdpwem;l\r\nwed;lwn\r\nwed;welmfcwe;fcew’, ‘adesh’, ‘adesh@gmail.com’),
(‘about_us’, ‘dewdwemlkwemklwewe\r\nfcwefl\r\nweq\r\nqefkqwe\r\nfcw’, ‘Shiva’, ‘shiva@gmail.com’),
(‘contact’, ‘sdcsawwdaw;kdaljdef\r\nfesfsvgs\r\nvgs’, ‘asad’, ‘asad@gmail.com’);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
LF15

“The presented piece of writing is a good example how the academic paper should be written. However, the text can’t be used as a part of your own and submitted to your professor – it will be considered as plagiarism.

But you can order it from our service and receive complete high-quality custom paper.  Our service offers Technology  essay sample that was written by professional writer. If you like one, you have an opportunity to buy a similar paper. Any of the academic papers will be written from scratch, according to all customers’ specifications, expectations and highest standards.”

Please  Click on the  below links to Chat Now  or fill the Order Form !
order-now-new                               chat-new (1)