Build database using SQL for Policy management system (CRM) for Auto Insurance Company
There are 2 SQL files created for this project
-
First file is "01 UDBP-DDL-V3-01 - Creating and Altering Tables.sql". This file is to CREATE TABLE and ALTER it for adding Foreign Key mapping.
-
Second file is "02 UDBP-DML-V6-01 - 15 queries including PLSQL commands.sql". This file contains 16 queries using Advanced SQL statements. Also have Advanced features Using PL SQL commands.
There is also a PDF file, which is Project Report. It introduces project, hs data dictionary, EER diagram, explanation of creating TABLES and the SQL queries.