BackgroundThe British Insurance Company (BIC), is based in Coventry, and was originally setupin 2002 by David and Ellen Stewart, who had just completed their undergraduatedegrees.The company has expanded recently and is currently servicing 4 main areas of theUK; these are shown as regions below.A new information system is envisaged that would capture all of the currentinformation and also provide for any future additions that the system might require.BIC are offering a range of products Travel insurance, Life Insurance, MotorInsurance along with other types. These are sold to clients by an insurance advisor.Further InformationThe 4 Regions of the UK are indicated below with the number of advisors that arededicated to that area:
Region AdvisorsThe South-East 4The South-West 2The Midlands 3The North 3All of the Insurance Products offered by BIC are sourced (from major Insuranceproviders) by the Main Office, who then let the Insurance Advisors know whichproducts can be sold on to their Customers, and these advisors also provide a rangeof Brochures (which describe the products) and Forms (to be completed and signedby the Customers).There needs to be a HR component of the system would need to record all of thecurrent employees of the company, along with the directors of the company. Thiswould typically contain personal details of the employees (e.g. name, telephone,address, etc).It is the job of the Insurance Advisors to visit Customers in their homes in order toascertain their insurance requirements, and to help them fill in the Insurance Forms(some of which are quite complex) that must be completed in order to provide anaccurate Insurance Quotation.New Customers or Existing Customers: Typically will contact one of theInsurance Advisors for the Region, in which they live, this is to arrange such avisit when they need advice on other insurance products.Each contact with a new or existing customer needs to be recorded into the system,especially details such as whether a follow-up is needed, or whether to send moreinformation, along with information like time, date etc.First thing every morning, each Insurance Advisor sends any Insurance Forms thatthey helped their Customers to complete the previous day back to the Head Office inCoventry.BIC deal with a wide variety of Insurance providers, and will 'web search' on behalf of their Customers in order to find the best deal on offer. Once an InsuranceQuotation has been calculated it is sent by email directly to the Customer.Upon receipt of an Insurance Quotation, the Customer must then decide if they wishto go ahead with the insurance, in which case they must electronically sign anAcceptance Form and send this, together with their banking details for the full amount of the premium back to BIC's head office. If they do not want to go ahead,then they simply do nothing.Upon receipt of a signed Acceptance Form, and accompanying payment, theInsurance Clerks send out the relevant Insurance Certificate to the Customer.Problems?BIC are having particular problems with the following areas of their business activity:* Standardising their forms and reports that the advisors use and relaying thatinformation back to the Head Office* Reports at head office need to be generated on a monthly, 6 monthly andyearly basis to assess the success of the advisors, also how well each of theregions are performing.* Understand how well the products are performing in relevant regions. Sobetter decisions can be made in regard to adopting new products andpresenting these to customers.* Building up their customer base and accurately recording all the detailsconcerning the customer, the products they have and any other contactinformation.* Supporting new and existing customers with information to help them decideon the right type of insurance to match their requirements.The Company directors have requested that the new database be able to carry outthe following transactions:a. Enter the details of a new customer.b. Enter the details of a new product.c. Enter the details insurance quotations sent to customers.d. Enter quotations made by advisors.e. Record valuable 'web search' details of products that have come on the marketAlong with any other features which you deem necessaryTask 1Business CaseTask 1A. Discuss why a relational database would be suitable for this organisationand provide (3) three reasons for this recommendation (300 words).Task 1B. Discuss using (3) three advantages that a database management systemprovides to an organisation (300 words).Requirements DefinitionRead the case study carefully, and decide what are the important (key) features ofthe system. Construct a basic prototype that will display the following:Task 1C. Initial screen designs that can be shown to the client this allows for theinput of information to satisfy the user requirements. Submit a hardcopy that has aset of screen shots that illustrate the screen designs.Task 1D. List typical reports that would be likely features of the database thisrequires you to assume the role of the user/manager and list three (3) likely reportshe/she might need to do their job. Submit a hardcopy which shows the report, itsmain features, and then populate it with some likely test data. Submit a hardcopythat has a set of screen shots that illustrate the screen designs.Note:A suitable package to do the above task (A to D) would be Microsoft Word or anysimilar product.Task 2DevelopmentUse database development strategy to decide the main elements of the databasethis will include nominating the:Fields (also the primary keys and foreign keys)TablesTask 2A. Create a Data Dictionary which contains the following: table, field type,field size and field descriptionNote:A suitable package to do Task 2B would be Microsoft Word or any similar product.Database DesignDevelop an initial prototype of this case study system, therefore in your design phaseyou and your team should create the following appropriate diagrams. Use the mysqlWorkbench (or equivalent tool set) to create the following:Task 2B. An Entity - Relationship diagram.Task 2C. Normalised Schema normalise to 3rd normal form. Provide a discussionthat shows how you schema passes each of the normal forms.Note:A suitable package to do Task 2B would be EDraw, Microsoft Visio or any similarproduct.Task 3Implementation of a Relational DatabaseTask 3A. Use the final normalised ER Diagram to create the physical database.Use mysql server, Oracle Express or an equivalent relational database to create thesystem. Provide a screen shot of the final system that displays the entire set oftables.Populate the DatabaseTask 3B. Enter six (6) records into the system that you can use to display to theclient that the system can operate. Provide screenshots of the final system thatdisplays (3) three of the tables with the mock data inserted.User Help GuideTask 3C. In order to complete the assignment, you need to provide a user manualthat will describe how to use the system. Screenshots of the main menu andnavigation between the sub-menus along with accurate descriptions is an importantfeature of this section of the assignment.Note: You may use previous screenshots (forms, reports and data screens) to createthis manual.ImprovementTask 3D. Provide a lessons learned log that indicates what you found importantand any improvements you wish to make for the next version of the database.Note:A suitable package to do Task 3A, Task 3B would be mysql server or any similarproduct.A suitable package to do Task 3C, Task 3D would be Microsoft Word or any similarproduct.
I have set a new price to $200 being the maximum allowed price to set. Let me know if there's anything you need me to do. Thanks.
Yes I would very much like you to continue searching for a Professional to help with my assignment. Please can you tell me how long this will take because I have a close deadline for the submission of this assignment.
Thanks. I will await your response.
Thanks for your response. I would need the answers latest by Tuesday next week, I hope that gives you enough time.
Hi The Doctor,
Thank you very much for a job well done. I'm wondering if you can be my online tutor -
Courses : Databases, Programming
Please reply asap.
Can you recommend books or websites that can help me gain more knowledge in Relational Database?
Thank you very much. I really appreciate.