juryp

Design Document: Personal Finance Management System

By: Yurii

Purpose:

Create a database to manage personal finances, including tracking income and expenses, managing budgets, monitoring account balances, and generating financial reports.

Scope

juryp

CREATE TABLE Users (
    UserID INT AUTO_INCREMENT PRIMARY KEY,
    FirstName VARCHAR(255) NOT NULL,
    LastName VARCHAR(255) NOT NULL,
    Username VARCHAR(255) UNIQUE NOT NULL,
    Password VARCHAR(255) NOT NULL
);

CREATE TABLE Schools (
    SchoolID INT AUTO_INCREMENT PRIMARY KEY,

juryp

-- Team Table
CREATE TABLE Team (
    TeamID INT PRIMARY KEY,
    TeamName VARCHAR(100) NOT NULL,
    Country VARCHAR(100),
    Base VARCHAR(100),
    Principal VARCHAR(100)
);

-- Car Table