Sign In
Not register? Register Now!
Essay Available:
Pages:
2 pages/β‰ˆ550 words
Sources:
No Sources
Style:
Other
Subject:
IT & Computer Science
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 12.96
Topic:

Fashion Bags Website Database Design

Coursework Instructions:

Assignment topic is about fashion bags.

General Project Guidelines   

1. Determine the requirements to design the database.  2. Create an initial database design(ER Model) for your project. ERD must be drawn by a modeling tool such as Visio.  3. Indicate attributes, entities, primary keys, and relationship 4. Create all the tables using the following information (Display all the tables in table format with the Attribute, Description, Constraints, Data type with size and data description) 

Coursework Sample Content Preview:

Fashion Bags Website Database Design
Student’s Name:
Institutional Affiliation:
Course Name and Number:
Instructor’s Name:
Due:
Index Data Requirements. 3 ERD Diagram.. 4 Data Tables. 4 Customer Table. 4 Product Table. 5 Order Table. 6 CartItems Table. 7 Sales Table. 8 Shipping Table. 9 Returns Table. 10 Cart Table. 11 SQL Commands. 12 Customer Table. 12 Products Table. 12 Sales Table. 12 Cart Table. 13 CartItems Table. 13 Order Table. 14 Returns Table. 14 Shipping Table. 14  
Fashion Bags Website Database Design
Data Requirements
The design of the database for the ecommerce website should fulfill the following requirements:
* Customers: The database should include a table for customers that includes information such as their name, address, email address, phone number, and any other relevant contact information.
* Products: The database should include a table for products that includes information such as the product name, description, image, price, and any other relevant details.
* Orders: The database should include a table for orders that includes information such as the order number, customer name, order date, and any other relevant information related to the order.
* Sales: The database should include a table for sales that includes information such as the sale date, customer name, product name, and any other relevant information related to sales tracking.
* Shipping: The database should include a table for shipping that includes information such as the shipping address, shipping method, and any other relevant information related to shipping orders.
* Returns: The database should include a table for returns that includes information such as the return date, customer name, product name, and any other relevant information related to returns processing.
* Cart: The database should have a cart that contains information about the session that is related to ecommerce. The table will also include information to check out whether the cart was checked out or abandoned.
* CartItems: The table will contain the individual products in a cart, including their prices and quantity. The information will help to calculate the total price as well as match the correct customer with their items.
ERD Diagram
Data Tables
Customer Table
Attribute
Description
Constraints
Data Type & Size
Data Description
Customer_ID
Primary Key
Unique identifier for a customer
NOT NULL, UNIQUE
INT
Integer value that auto-increments with each new customer record
Customer_Name
Full name of the customer
NOT NULL
VARCHAR(50)
String of maximum 50 characters representing the customer's full name
Customer_Address
Full address of the customer
NOT NULL
VARCHAR(100)
String of maximum 100 characters representing the customer's full address
Customer_Email
Email address of the customer
NOT NULL, UNIQUE
VARCHAR(50)
String of maximum 50 characters representing the customer's email address
Customer_Phone
Phone number of the customer
NOT NULL
VARCHAR(20)
String of maximum 20 characters representing the customer's phone number
Product Table
Attribute
Description
Constraints
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These Other Coursework Samples: