database Assignment Guidelines
The assignment consists of two questions. You are required to:
Pick ONE (1) question only from the two provided.
Create your own GitHub repository and upload your solution there.
Submit the link to your GitHub repository for grading.
The final submission deadline is: Wednesday, 25th September 2025.
Late submissions will not be accepted unless you have prior approval. Question 1: Build a Complete Database Management System
Objective: Design and implement a full-featured relational database using MySQL.
Instructions:
Choose a real-world use case (e.g., Library Management, Student Records, Clinic Booking System, Inventory Tracking, E-commerce Store, etc.).
Create a relational database schema that includes:
Well-structured tables.
Proper constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE).
Relationships (One-to-One, One-to-Many, Many-to-Many, where applicable).
Use SQL to implement your design.
Deliverables:
A single .sql file containing:
CREATE DATABASE statement
CREATE TABLE statements
Relationship constraints
Question 2: CRUD Application with Node.js or FastAPI
Objective: Develop a simple CRUD (Create, Read, Update, Delete) application that interacts with a database.
Instructions:
Choose Node.js (Express) or FastAPI (Python).
Connect your application to the database you designed in Question 1 (or design a simpler schema if preferred).
Implement CRUD operations for at least two entities (e.g., Students & Courses, Patients & Appointments, Products & Orders).
Deliverables:
Source code in a GitHub repository.
Clear instructions in a README.md on how to run the project.
API endpoints documented (e.g., via README or Postman Collection).