How paras4902/onlinebookstore_db works
Project type and purpose
• This repository is a database‐centric project: it provides the schema definition, data‐loading scripts, and sample data for an Online Book Store.
• Its goal is to create an Oracle (or other relational) database: define tables, sequences, tablespaces/users, and then populate them with realistic data via SQL scripts (and helper Python scripts).
File structure
• Top level:
• Creation of tables, user n tablespace/… – SQL scripts to set up your tablespace, user, grants, sequences, and tables.
• Insert Scripts/1_*.txt through 9_*.txt – pure SQL INSERT statements for each table.
• Multiple Excel files – source data for authors, books, customers, etc.
• python script for generating dates.py, repeating existing numbers.py, repeating existing shipping types.py – data‐generation utilities.
• LICENSE, README.md, OnlineBookStore_ProblemStatement.pdf – documentation and licensing.
• Patterns: a layered approach where you first set up the environment (tablespace & user), then schema (sequences/tables), then data (INSERT scripts, aided by Python).
README for additional insights
• The README confirms this is “Database for Online book store with database design(ERD).”