8000 GitHub - xyzoptooo/bookstore_rdbms: MySQL database for a bookstore management service featuring normalized schema design, role-based control, and optimized queries for inventory, sales, and customer analytics
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

MySQL database for a bookstore management service featuring normalized schema design, role-based control, and optimized queries for inventory, sales, and customer analytics

Notifications You must be signed in to change notification settings

xyzoptooo/bookstore_rdbms

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 

Repository files navigation

--Group members-

1.Daniel Mutua 2.Vincent Karanja 3.Okech Prevyne Odhiambo

Bookstore Database Schema

A well-structured MySQL database schema designed for managing a modern bookstore system. It handles books, authors, publishers, customers, addresses, orders, shipping, and more.

Database Overview

This project sets up a relational database with the following major components:

Book and Author Information Publishers and Languages Customers and Addresses Order Management Shipping Methods and Order Statuses

Requirements MySQL Server

Setup Instructions

1.Clone the repository: git clone https://github.com/xyzoptooo/bookstore_rdbms.git cd bookstore-database-schema

2.Import the SQL schema:

Open the SQL file in your preferred MySQL client.

Run the SQL script step-by-step to create the database and all related tables.

About

MySQL database for a bookstore management service featuring normalized schema design, role-based control, and optimized queries for inventory, sales, and customer analytics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •  
0