Project: Database Management System for a Fictional Online Bookstore You are tasked with creating a database management system for a fictional online bookstore called "Bookworm Haven." The database will store information about books, authors, customers, orders, and transactions. As part of this project, you will design the database schema, create tables, populate the database with sample records, and perform various data management tasks. Database Schema: (USE ANY DBMS) • Books Table: Contains information about the books available in the bookstore. • Columns: BookID (Primary Key), Title, AuthorID (Foreign Key), Genre, Price, PublicationYear. • Authors Table: Stores details about the authors of the books. • Columns: AuthorID (Primary Key), AuthorName, Nationality, BirthYear. • Customers Table: Holds customer information for online orders. • Columns: CustomerID (Primary Key), CustomerName, Email, Phone, Address. • Orders Table: Records each customer's order details. • Columns: OrderID (Primary Key), CustomerID (Foreign Key), OrderDate, TotalAmount. • OrderItems Table: Stores the items (books) in each order. • Columns: OrderItemID (Primary Key), OrderID (Foreign Key), BookID (Foreign Key), Quantity.
Project:
• Authors Table: Stores details about the authors of the books. • Columns: AuthorID (Primary Key), AuthorName, Nationality, BirthYear.
• Customers Table: Holds customer information for online orders. • Columns: CustomerID (Primary Key), CustomerName, Email, Phone, Address. • Orders Table: Records each customer's order details. • Columns: OrderID (Primary Key), CustomerID (Foreign Key), OrderDate, TotalAmount.
• OrderItems Table: Stores the items (books) in each order. • Columns: OrderItemID (Primary Key), OrderID (Foreign Key), BookID (Foreign Key), Quantity.
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 11 images
