Student Name: Joe O'Regan
Student Number: K00203642
Course: BSc (Honours) in Computing (Games Design and Development)
Module: Database Implementation
Continuous Assessment 1 and 2
- MySQL Server 5.7 or higher
- MySQL Workbench 8.0 or higher
- Git
- Clone the repository
git clone https://github.com/joeaoregan/LIT-Yr2-DatabaseImplementation.git cd LIT-Yr2-DatabaseImplementation
The Toy Store database is designed to support an online e-commerce platform specializing in anime-related merchandise. The schema manages:
- Accounts: User registration and authentication for online shoppers
- Products & Inventory: Comprehensive product catalog with categories, genres, and inventory tracking
- Orders & Fulfillment: Order processing, line items, and order status tracking
- Suppliers: Vendor management and product sourcing
- Series & Genres: Anime series and genre classification for products
The database supports complex relationships between products and anime series, allowing products to be associated with multiple genres and series, while maintaining efficient inventory and order management for the online store.
The initial schema establishes the core structure for the toy store database with the following tables:
- account: User accounts for online shoppers
- category: Product categories and subcategories
- genre: Anime genres (Fantasy, Magic, Science Fiction, etc.)
- item: Product variants (different colors, sizes, etc.)
- inventory: Order line items and stock management
- orders: Completed customer orders
- orderstatus: Order processing status tracking
- product: General product information
- series: Anime television series
- supplier: Vendor and supplier information
- xrefseriesgenre: Cross-reference table linking series to genres
Further refinements and enhancements to the initial schema design, including optimizations for performance and data integrity.
Joe O'Regan, 2016
