Database Design Concepts British Insurance Company Assignment

Database Design Concepts British Insurance Company - Assignment Example The second screenshot illustrates the working of the function "Add new customer". When the system admin will click on the "Add new customer", he will be redirected to this page. The page will inquire about the following details. System Admin can also upload the picture of a customer. Once all the details have been provided, the admin will click on the "save" button in order to record the details in the database. The third screenshot illustrates the working of the Product's Section. When the system administrator will click on the "Products" button located at the in the main panel, he will be redirected to the Product's Section. Here, the admin will be able to add new Products, view existing Products, make a web search to update the product's details and delete a Product. An admin will also be able to perform a Product related search in the search box provided at the bottom of the page. When the admin will click on any of the buttons, he will be redirected to the related page.  Ã‚   Screenshot 2: This Screenshot shows the working of the Product module. A manager or admin of the system can add the new product, view existing products, delete a product or make a web search to gather details for the product through the buttons on the page. A manager or admin can also make a search for any query regarding the product to make a quick search. Screenshot 3 When the admin clicks on the button "Add new customer", he will be redirected to the "Add new customer" page. The admin has to enter the mentioned details and click on the "Save" button in order to create a new customer account. Task 2A: Data Dictionary: Table Field Type Field Size Field Description Customer Text Up to 500 characters The details of the customers will be stored in the Customer table Product Memo Up To 64,000 characters The details of the customers will be stored in the Customer table Quotation Text Up to 1000 characters The quotations made by the advisors will be saved in the quotations table Advisor T ext Up to 255 characters Names of the advisors will be saved in the advisor table Task 2B: The tool used to create the ER diagram is Microsoft Visio. ER Diagram: 5 entities have been considered in the ER diagram. The product entity contains the following attributes; Description, Product No., and Name. The Database Admin entity contains the following attribute; ID Number. The Customer entity contains the following attributes; Name, reg no, age, address, contract number, date and advisor. The quotation entity contains the following attributes; reg no, client name, advisor name, estimate, and date. Similarly, the web search entity will make searches for a product from the internet in order to update the details of a product.