.Design and implement a simple database using MS-Access for an Online Retail Store, using fundamental concepts of database management systems such as creating tables, establishing relationships, performing CRUD (Create, Read, Update, Delete) operations, and writing basic SQL queries.
Create a database schema for an online retail store and implement various operations on it. The database will manage information about customers, products, orders, and order details. Use SQL to create tables, establish relationships, and perform queries to manipulate and retrieve data.
I. Create Database Schema:
Customers Table:
customer_id (Primary Key, INT, Auto Increment)
first_name (VARCHAR)
last_name (VARCHAR)
email (VARCHAR, Unique)
phone (VARCHAR)
address (VARCHAR)
Products Table:
product_id (Primary Key, INT, Auto Increment)
product_name (VARCHAR)
description (TEXT)
price (DECIMAL)
stock_quantity (INT)
Orders Table:
order_id (Primary Key, INT, Auto Increment)
customer_id (Foreign Key, INT)
order_date (DATE)
status (VARCHAR)
OrderDetails Table:
order_detail_id (Primary Key, INT, Auto Increment)
order_id (Foreign Key, INT)
product_id (Foreign Key, INT)
quantity (INT)
total_price (DECIMAL)
__________ _________ _____ ________ ___ _________ ___.
____ ______ ____ ______ __________ ________.
_____ ______ _________ __________ ___.
__________ ________ _____ _______ ____.
_______ _______ _________ __________ _______ __________ __________ ______ __________ __________ _____ ____.
___ ________ ______ ______ _____ ________ ________ _______.
_________ _________ _______ _______ _______ ___ _____ ____ _______ _____ ______.
___ ____ ___ __________ __________ ________ ______.
________ ________ _________ ________ ______ ___ _______ __________ _____ __________ __________ ____.
__________ ________ ______ ______ ___ _____ _____ __________ ______.
______ ____ __________ ________ ______ ________ ________ _________ ______ ___ ______ __________.
______ ___ __________ ________ ____ ________ ________.
___ _____ ___ ________ __________ __________ ________ _____.
________ ________ ____ ______ ____ ___ ___ ___ ____ _____.
__________ ___ ____ ______ ___ __________ ________.
______ ________ _____ _________ ___ _______ ______ ______ ______.
____ _________ ____ ______ __________ _____ __________ ___ ____ _________ ______.
__________ ______ __________ _____ _____ ___ _________ __________ _______.
________ __________ ___ _____ ___ _______ ______ ___ _______.
___ _______ _____ ______ ________ __________ ____.
_________ __________ ________ ________ __________ ________ _________ ____ ________ ___ __________ __________.
___ ____ ___ ____ ____ ______ ___ ___ _____ __________.
____ ______ _____ _____ _____.
______ ____ __________ _______ __________ ___.
_______ _________ _________ ____ _____.
____ _______ _______ _____ _______ _________ __________ _______ __________ ________.
___ _______ _________ _____ _______ _______.
________ ____ ____ ___ _________ ____ ___ _____ _____ __________ ____ ____.
__________ ______ ________ ______ _____ _______ ___ _____.
_____ ______ ___ ________ ___ __________ _________ _________ _______.
____ _________ ____ ___ _____ __________ _________ ____ ___ ___ ___ _______.
_____ ______ ____ ___ _______ _____ ___ ____ _________ __________ ______ ___.
___ _____ _____ _______ ____ _______ ______ _____ __________ _______ _________.
____ ________ ________ ___ ______ ________ __________ ______ ____ _____ ______.
_____ ____ _____ ______ _________ ______ _________ _____ _____.
___ __________ _________ ___ ___ ______ ___ _____ ______.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required