Bank Database Management System 🏦
📄 Project Overview
This project aims to manage complex banking operations through a structured relational database. It handles various entities such as:
• Core Banking: Customers, Cards, and Branches.
• Financial Operations: Loans and Remittances.
• Management: Employees, Bosses, and POS Devices for companies.
💻 Tech Stack
• Database: SQL Server (Transact-SQL).
• Modeling Tools: ER Diagrams and Relational Schema.
📊 Key Features & Deliverables
• Conceptual Design: Detailed ER Diagram representing relationships like (Customer-Have-Cards) and (Employees-Work at-Branches).
• Schema Design: Mapping ERD to a Relational Schema with primary and foreign keys.
• Database Normalization: Ensuring data integrity by applying 1NF, 2NF, and 3NF on various entities (Loans, Employees, and Companies).
• Implementation: * DDL: Table creation for all entities.
• DML: Comprehensive data insertion scripts.
• Advanced Queries: Over 50 SQL queries including Joins, Aggregations, Subqueries, and Updates.
• Database Objects: Implementation of Views for streamlined data reporting.