What is the purpose of the database

Assignment Help Computer Engineering

Reference no: EM132110177

Project Task : Background

In project task one you should have identified requirements for your eCommerce database.

Below is a list of minimum requirements that I have identified for your eCommerce system. There is obviously more information and functionality that can be implemented than what we have here, but for this class we will simplify things.

• Minimum Requirements for eCommerce

o What type of data is used for eCommerce?

Customer data

Product data

Sales data

o Where will data come from?

Product data will come from the organization

Customer and sales data will come from eCommerce users

o Who will use the database?

Customers of the organization

Marketing department

• Identify products to be sold online

• Set prices

• Sales promotions.

o What is the purpose of the database?

To market, promote and sell products to our customers.

o What functionality is needed?

Product display

Shopping cart (sales data)

• Potential business rules

o Basic business rules need to be developed for cross-sales and up-sales. We will not worry about identifying the formulas for these recommendations. However, this is an example of business rules that we will discuss this semester. For now, just understand what cross-sales and up-sales are, we will discuss how to implement these business rule at a later date.

Cross sales - This is the sale of products that are not related to other products purchased by the customer but recommended by the system. Often based on purchase habits of other customers who bought non-related products together.

Up Sales - This is the sale of products that are related to previous (or current) purchases that provide benefits to the products the customer has already purchased. These recommendations are often made based on a customer's purchase history or items that appear in their shopping cart.

Project Task 2: Requirements

For this task, you are to look at the "Minimum requirements" identified above and determine the entities, attributes and primary keys required for your database. You DO NOT need to identify foreign keys or relationships at this point. Your main task is to determine what data should be collected and how it is grouped together.

You may create a Word or Visio document displaying the tables and attributes that you identify. The tables and attributes will be based on the requirements we identified in task 1.

Reference no: EM132110177

Questions Cloud

A description of the design of your solution : In this project, you are asked to solve the readers and writers problem by using the clientserver model and a kind of communication facility.

Create a spreadsheet page that automates the process : ITECH1100 Understanding the Digital Revolution Assignment - Parchment Basement, Federation University Australia. Create spreadsheet page that automates process

Relationship between technology and humans : Article on technology - about the evolving relationship between technology and humans - a relationship which defines our history, our present and our future

Create and maintain a resistor linked list : Ifchoice is l, the program will ask the user to enter a resistor ID and value of resistance to be inserted into the end of list.

What is the purpose of the database : Basic business rules need to be developed for cross-sales and up-sales. We will not worry about identifying the formulas for these recommendations.

Design an entire website : Design an entire website which must contain the following items but can contain anything else you want to add.

Advise directors of ruby pty ltd of the tax deductibility : Advise the directors of Ruby Pty Ltd of the tax deductibility of the above amounts. You must make reference to appropriate authorities and legislation

Write a program that can encrypt and decrypt a message : Write a program that can encrypt and decrypt a message using a double columnar transposition encryption algorithm.

Which of the following are essential elements of a project : To reduce the duration of a project using Critical Path Method (CPM), it is necessary to make a reduction on the activity with.

User Account

All Pages