Entities
- Customer
- Account
- Transaction
- Branch
- Employee
Relations
- Cutomer - Account : One to Many
- Account - Transaction : One to Many
- Account - Branch : Many to One
- Branch - Employee : One to Many
BANK MANAGEMENT SYSTEM
Schemas
PERSONAL EXPENSE TRACKER
Entities
- User
- Report
- Account
- Income
- Expense
- Categories
- Sub-Categories
Relations
- User - Report : One to Many
- User - Account : One to Many
- Account - Expense : One to Many
- Account - Income : One to Many
- Income - Categories : One to One
- Income - Sub-Categories : One to One
- Expense - Categories : One to One
- Expense - Sub-Categories : One to One
Query File Link
Link To SQL filesSchemas
BLOOD BANK MANAGEMENT SYSTEM
Entities
- Doner
- Receipent
- Blood
- Blood Type
- Employee
Relations
- Receipent - Blood : One to Many
- Donor - Blood : One to One
- Employee - Blood : One to Many
- Blood - Blood Type : Many to One
EMPLOYEE MANAGEMENT SYSTEM
Entities
- Department
- Payroll
- Qualification
- Leave
- Employee
Relations
- Department - Employee : One to Many
- Employee - Qualification : One to One
- Employee - Leave : One to One
- Employee - Payroll : One to One
INVENTORY MANAGEMENT SYSTEM
Entities
- Admin
- Inventory
- User
- Item
- Category
- Vendor
Relations
- Admin - Employee : One to Many
- Admin - Inventory : One to One
- Inventory - Item : Many to One
- User - Item : One to Many
- Item - Category : One to One
- Item - Vendor : One to One
LIBRARY MANAGEMENT SYSTEM
Entities
- Admin
- Book
- Author
- Member
- Employee
Relations
- Admin - Employee : One to Many
- Employee - Book : Many to Many
- Member - Employee : Many to Many
- Author - Book : One to Many
- Admin - Book : One to Many
PARKING LOT MANAGEMENT SYSTEM
Entities
- Parking Lot
- Floor
- Slot
- user
Relations
- Parking Lot - Floor : One to Many
- Floor - Slot : One to Many
- Slot - user : One to One
RESTAURANT MANAGEMENT SYSTEM
Entities
- Customer
- Admin
- Food
- Order
- Employee
- Bill
Relations
- Admin - Food : One to Many
- Admin - Employee : One to Many
- Employee - Bill : One to One
- Customer - Order : Many to Many
- Employee - Order : One to Many
ROOM MANAGEMENT SYSTEM
Entities
- Customer
- Room
- Item
- Admin
- Employee
Relations
- Admin - Room : One to Many
- Room - Item : Many to Many
- Room - Employee : One to One
- Room - Customer : One to One
SCHOOL MANAGEMENT SYSTEM
Entities
- Admin
- Student
- Teacher
- Admin
- Class
- Course
- Employee
Relations
- Admin - Student : One to Many
- Admin - Employee : One to Many
- Admin - Techer : Many to One
- Teacher - Class : One to Many
- Student - Class : One to One
- Class - Course : One to Many
TOURNAMENT MANAGEMENT SYSTEM
Entities
- Tournament
- Team
- Player
Relations
- Tournament - Team : One to Many
- Team - Player : One to Many