Question

.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)

28 May 2025
Answer :
Word Count : 534
To design and implement a simple database using MS-Access for an Online Retail Store, the process involves creating four main tables: `Customers`, `Products`, `Orders`, and `OrderDetails`. Each table should be properly normalized and linked using primary and foreign keys. The project will include the implementation of CRUD operations and SQL queries for data manipulation and retrieval. --- ### I. Creating Tables and Establishing Relationships 1. Customers Table * Fields: * `customer_id`: AutoNumber (Primary Key) * `first_name`: Short Text * `last_name`: Short Text * `email`: Short Text (Indexed, No Duplicates) * `phone`: Short Text * `address`: Short Text 2. Products Table * Fields: * `product_id`: AutoNumber (Primary Key) * `product_name`: Short Text * `description`: Long Text * `price`: Currency * `stock_quantity`: Number (Integer) 3. Orders Table * Fields: * `order_id`: AutoNumber (Primary Key) * `customer_id`: Number (Lookup from Customers Table, Foreign Key) * `order_date`: Date/Time * `status`: Short Text 4. OrderDetails Table * Fields: * `order_detail_id`: AutoNumber (Primary Key) * `order_id`: Number (Lookup from Orders Table, Foreign Key) * `product_id`: Number (Lookup from Products Table, Foreign Key) * `quantity`: Number (Integer) * `total_price`: Currency --- ### II. Establishing Relationships In MS-Access: * Use the Relationships tool to link: * `Orders.customer_id` → `Customers.customer_id` * `OrderDetails.order_id` → `Orders.order_id` * `OrderDetails.product_id` →
______ ___ __________ ___ ________ ____ __________ ________.
__________ _________ _____ ________ ___ _________ ___.
____ ______ ____ ______ __________ ________.
_____ ______ _________ __________ ___.
__________ ________ _____ _______ ____.
_______ _______ _________ __________ _______ __________ __________ ______ __________ __________ _____ ____.
___ ________ ______ ______ _____ ________ ________ _______.
_________ _________ _______ _______ _______ ___ _____ ____ _______ _____ ______.
___ ____ ___ __________ __________ ________ ______.
________ ________ _________ ________ ______ ___ _______ __________ _____ __________ __________ ____.
__________ ________ ______ ______ ___ _____ _____ __________ ______.
______ ____ __________ ________ ______ ________ ________ _________ ______ ___ ______ __________.
______ ___ __________ ________ ____ ________ ________.
___ _____ ___ ________ __________ __________ ________ _____.
________ ________ ____ ______ ____ ___ ___ ___ ____ _____.
__________ ___ ____ ______ ___ __________ ________.
______ ________ _____ _________ ___ _______ ______ ______ ______.
____ _________ ____ ______ __________ _____ __________ ___ ____ _________ ______.
__________ ______ __________ _____ _____ ___ _________ __________ _______.
________ __________ ___ _____ ___ _______ ______ ___ _______.
___ _______ _____ ______ ________ __________ ____.
_________ __________ ________ ________ __________ ________ _________ ____ ________ ___ __________ __________.
___ ____ ___ ____ ____ ______ ___ ___ _____ __________.
____ ______ _____ _____ _____.
______ ____ __________ _______ __________ ___.
_______ _________ _________ ____ _____.
____ _______ _______ _____ _______ _________ __________ _______ __________ ________.
___ _______ _________ _____ _______ _______.
________ ____ ____ ___ _________ ____ ___ _____ _____ __________ ____ ____.
__________ ______ ________ ______ _____ _______ ___ _____.
_____ ______ ___ ________ ___ __________ _________ _________ _______.
____ _________ ____ ___ _____ __________ _________ ____ ___ ___ ___ _______.
_____ ______ ____ ___ _______ _____ ___ ____ _________ __________ ______ ___.
___ _____ _____ _______ ____ _______ ______ _____ __________ _______ _________.
____ ________ ________ ___ ______ ________ __________ ______ ____ _____ ______.
_____ ____ _____ ______ _________ ______ _________ _____ _____.
___ __________ _________ ___ ___ ______ ___ _____ ______.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU BCSL 34 2024 2025 - .Design and implement a simple database using MS-Access for an Online | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→