CS310 - DBMS Course Project: Vehicle Insurance Company Database

Aim

The aim of this project is to provide a comprehensive understanding and practical experience in data modeling, normalization techniques, transactional relational database design, and implementation of SQL queries.

Approach

• Part A: Conceptual Data Model (CDM) - Optional
• Part B: Logical Data Model (LDM) - Optional
• Part C: Physical Data Model (PDM) - Mandatory
• Part D: SQL Queries - Mandatory

Repository Contents

• CDM.png: Conceptual Data Model screenshot.
• PDM.png: Physical Data Model screenshot.
• problem statement and Project Guidelines.pdf: Detailed problem statement and project guidelines.
• dbms_project_create_tables.sql: SQL script for creating tables.
• dbms_project_InsertData.sql: SQL script for inserting data.
• dbms_project_Queries.sql: SQL script containing queries.
• final PDF.pdf: Final project report.
• query1.png, query2.png, query3.png, query4.png, query5.jpg, query6.png: Screenshots of SQL queries.

Usage

Refer to the provided documents and scripts to understand the project requirements, view the data models, and analyze the SQL queries. For better understanding, please refer to the report i.e., "final PDF.pdf" file in this repository.

Contact

If you have any questions or suggestions, please feel free to reach out to me at nvarjunmani07@gmail.com.