Database Design Concepts British Insurance Company Assignment

selective informationbase Design Concepts British Insurance companion - Assignment ExampleThe second screenshot illustrates the working of the function Add new node. When the system admin lead click on the Add new customer, he bequeath be redirected to this page. The page will inquire about the following details. System Admin can also upload the picture of a customer. formerly all the details have been provided, the admin will click on the save button in put in to record the details in the database. The third screenshot illustrates the working of the harvest-festivals Section. When the system administrator will click on the Products button located at the in the main panel, he will be redirected to the Products Section. Here, the admin will be able to add new Products, view existing Products, make a web search to update the merchandises 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 p age. 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 director 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 ask 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 school text Up to 500 characters The details of the customers will be stored in the Customer table Product memorandum Up To 64,000 characters The details of the customers will be stored in the Customer table Quotation text edition Up to 1000 characters The citations made by the advisors will be saved in the quotations table Advisor Text Up to 255 characters Names of the advisors will be saved in the advisor table Task 2B The cocksucker 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.