This repository contains all of my work related to database design and development classes, including assignments, designs, and projects. It's organized into separate folders for each class, with subfolders for each assignment or project. Each assignment or project includes the code, documentation, and any other relevant materials.
The repository includes a variety of assignments and projects that cover topics such as relational database design, SQL query optimization, database normalization, and data modeling. There are also projects that explore NoSQL databases, distributed databases, and cloud-based databases.
erDiagram
BOOK ||--|{ BOOK_AUTHORS : writes
BOOK ||--o{ PUBLISHERS : published_by
BOOK ||--|{ BOOK_CATEGORIES : categorized_in
BOOK ||--|{ ORDERS : ordered_in
BOOK ||--|{ REVIEWS : reviewed_in
BOOK {
int ID PK
string title
float price
int publisher_id FK
int publication_year
}
BOOK_AUTHORS {
int book_id PK, FK
int author_id PK, FK
}
AUTHORS ||--o{ BOOK_AUTHORS : writes
AUTHORS {
int author_id PK
string name
string phone
}
PUBLISHERS {
int publisher_id PK
string company_name
string representative
string phone
}
BOOK_CATEGORIES ||--o{ CATEGORIES : categories
BOOK_CATEGORIES {
int book_id PK, FK
int category_id PK, FK
}
CATEGORIES {
int category_id PK
string category_name
string description
}
CUSTOMERS ||--o{ ORDERS : orders
CUSTOMERS ||--o{ REVIEWS : writes
CUSTOMERS {
int customer_id PK
string name
string phone
}
ORDERS {
int order_id PK
int customer_id FK
int book_id FK
string purchase_date
bool refunded
}
REVIEWS {
int review_id PK
int customer_id FK
int book_id FK
string content
int rating
int points
}
The repository includes a README file that provides an overview of the repository's contents, instructions for how to use the code and run the projects, and any other important information. Additionally, the repository includes sample data sets and test scripts that can be used to verify the functionality of the database designs and queries.
In addition to the class assignments, this repository includes personal projects or contributions to open-source database projects. These projects are organized into separate folders and include the code, documentation, and any relevant data or test scripts.
Overall, this repository serves as a comprehensive record of my database design and development work, covering a range of topics and database technologies. It demonstrates my ability to design and develop efficient and scalable databases, optimize database queries, and work with a variety of database management systems and tools.