Car Insurance Database

This task is cogitate to creation and update of database which is way out to contain the data of an insurance company. The database is developed in MS-Access. In hallow to create the database in MS-Access, the first step is to create the database from file add-in of the MS-Access and provide any sui set back name (e. g. the name chosen for this propose is vechicle_insurance). The next step is to use the enquiry option and execute the queries champion by one (the queries are available in this put down).All the queries provided in the document are compatible with MS-Access. Six tables are created by the information commentary Language (DDL) query and the data is inserted into the table by the insert query or Data Modification Language (DML). In addition to DDL & DML, browse, depend 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) diagra m is provided on a separate 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 severalise 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. apiece table contains certain number of fields. Each field gives the information of related table.