Car Insurance Database

This task is related to creation and update of database which is going to operate the data of an insurance company. The database is developed in MS-Access. In order to create the database in MS-Access, the first timbre is to create the database from file menu of the MS-Access and provide any suitable name (e. g. the name chosen for this see to it is vechicle_insurance). The next step is to use the query option and execute the queries one by one (the queries be available in this document).All the queries provided in the document are compatible with MS-Access. Six tables are created by the data Definition Language (DDL) query and the data is inserted into the table by the insert query or info Modification Language (DML). In addition to DDL & DML, browse, search and update queries are also provided in this document. In the following section, Data dictionary is provided which is a mapping of the fields with the data type.The Entity-relationship (ER) diagram is provided on a separat e document which shows the relationship amongst all six table tables and how they are connected to each other. In the ER diagram, Id is primary key for each table. All the tables are normalized to 3rd form of the normalization. Data mental lexicon There are six tables in vehicle insurance database. Each table contains certain identification number of fields. Each field gives the information of related table.