Database Design Concepts British Insurance Company Assignment

Database Design Concepts British Insurance Company - Assignment ExampleThe game screenshot illustrates the working of the function attention deficit hyperactivity disorder young customer. When the system admin volition click on the Add new customer, he lead 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 exact 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 Products 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 products details and set off a Product. An admin will also be able to complete 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 board Product Memo Up To 64,000 characters The details of the customers will be stored in the Customer table Quotation Text Up to 100 0 characters The quotations 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 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, narrow down 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.