E-COMMERCE
A relational database is a collection of data items organized in tables for efficient data access. Explore the connection between e-commerce and relational databases, including essential tools, required knowledge, and deliverables. Learn how to build and manage e-commerce websites, payment transactions, web applications, suppliers, and shopping cart databases. Access helpful resources and tutorials for MySQL relational databases in dynamic web programming.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
E-COMMERCE RELATIONAL DATABASE
RELATIONAL DATABASE A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The relational database was invented by Edgar. F. Codd at IBM in 1970. The standard user and application program interface to a relational database is the structured query language (SQL).
E-COMMERCE WEBSITE LAYOUT PAYMENT TRANSACTIONS WEB APPLICATION SUPPLIERS
SHOPPING CART DATABASE PRODUCTS INVENTORY CUSTOMERS Product ID Product Description User ID (Unique, Primary Key) First Name Last Name Password Security Level INVOICE SHOPPING_HISTORY CART Invoice ID User ID (Foreign Key) User ID (Foreign Key) VENDORS Vendor ID
KNOWLEDGE AND TOOLS REQUIRED MySQL properly installed and configured Access to phpMySQL page MySQL Workbench
DELIVERABLES Word document containing Screenshots of phpMyAdmin/Workbench page showing Shopping Cart database and tables Relationship between tables SQL Script for each table
RESOURCES Dynamic Web Programming and HTML5 Chapter 9. Database-Driven Websites MySQL Relational Database Tutorial (https://youtu.be/-4PuIaEVaiQ ) An Introduction to Relational Databases (https://youtu.be/z2kbsG8zsLM )
