Draw a logical ERD in crow's foot notation for the case described below. Make sure to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Draw a logical ERD in crow's foot notation for the case described below. Make sure to indicate all relevant entity sets, attributes, primary keys, foreign keys, relationships, and cardinalities. If you need to make any assumptions, state them clearly in your answer. PayTime Insurance PayTime Insurance is an insurance company which has been in operation for over 9 years. The company is well known for its innovative insurance products catered to individuals. The company has over 500 employees currently and boasts of a customer base of nearly 250000 customers. The following specification captures only part of the data requirement for PayTime Insurance. Employee All the employees should have their personal information stored in the database (e.g., name, age, gender, phone number, address and email). It is also important to keep track of the person's role at a specific time as employees can rotate roles throughout their employment. Some roles which employees currently fulfil include insurance advisor, telemarketer, actuary and admin staff such as receptionists, HR managers, etc. Customer Customers are individuals. When an insurance product is purchased by a customer then their details such as name, phone number, address, and gender are recorded. Customers' occupations, salaries and levels of risk involved in their jobs are stored in the database. This information is used to calculate the premium for the insurance products that individuals purchase. Appointment Employees make appointments with prospective individual customers, to discuss product options with the customers. The meetings may be conducted as face-to-face personal interviews or may even be conducted virtually via online teleconferencing tools. Date, time and terms discussed need to be recorded for each appointment. The employee is paid a commission for each successful appointment which results in a new customer purchasing a policy. Recording the status of 'successful' or 'unsuccessful' for each appointment is important for commission calculation purposes. The actuary who designs a product cannot be the one who evaluates it. Some changes may be made to products after an actuary reviews it. The history of changes is recorded, as the company wishes to know how their products have evolved over time. All products have associated liabilities covered, which describe the liabilities and costs that the individual or business can be insured for. All products have a maximum cover amount which cannot be exceeded. For all individual products there is a qualifying age which applies. Purchasing a Policy Customers can purchase insurance products tailored to their individual needs as a policy. The date and time a policy is purchased is recorded. Coverage of the product for each purchase needs to be recorded. The premium of each purchase varies depending on the purchaser's personal information and the product they are purchasing. Each purchase also has an excess amount decided by both the purchaser and the company. Each purchased policy has an end date on which the terms are reviewed/adjusted. When policies are renewed they are treated as a new purchase. Four weeks before a policy is set to expire the system generates and sends reminders to customers so that the customers will have enough time to consider the renewal of the policy. There are many ways in which the payment of premium for a policy can be made. Customers can choose to pay annually upfront by EFTPOS, cheque or cash, or pay fortnightly or monthly by direct debit. For customers who select to pay by direct debit, there bank account information will be stored. The company hopes to enable online payments for their customers at a later time. The company maintains a log of payments received for each policy. Claim A claim can be made by the customers when they seek the benefits provided by the insurance company due to a liability occurrence covered by the policy. A standard form must be filled when a customer wants to make a claim, key fields in the form include description of claimed situation, policy ID, claim lodged date and time. When a claim is received, an employee will review the customer's policy and conduct a thorough investigation into the claimed damages/loss to mitigate fraudulent claims. If the claim is determined to be genuine and approved by the employee conducting the investigation, then the claim is paid out and the date and time when the payment was processed is recorded. Not all insurance claims are paid out, but all the claims submitted by a customer should be recorded in his/her profile for future reference. Draw a logical ERD in crow's foot notation for the case described below. Make sure to indicate all relevant entity sets, attributes, primary keys, foreign keys, relationships, and cardinalities. If you need to make any assumptions, state them clearly in your answer. PayTime Insurance PayTime Insurance is an insurance company which has been in operation for over 9 years. The company is well known for its innovative insurance products catered to individuals. The company has over 500 employees currently and boasts of a customer base of nearly 250000 customers. The following specification captures only part of the data requirement for PayTime Insurance. Employee All the employees should have their personal information stored in the database (e.g., name, age, gender, phone number, address and email). It is also important to keep track of the person's role at a specific time as employees can rotate roles throughout their employment. Some roles which employees currently fulfil include insurance advisor, telemarketer, actuary and admin staff such as receptionists, HR managers, etc. Customer Customers are individuals. When an insurance product is purchased by a customer then their details such as name, phone number, address, and gender are recorded. Customers' occupations, salaries and levels of risk involved in their jobs are stored in the database. This information is used to calculate the premium for the insurance products that individuals purchase. Appointment Employees make appointments with prospective individual customers, to discuss product options with the customers. The meetings may be conducted as face-to-face personal interviews or may even be conducted virtually via online teleconferencing tools. Date, time and terms discussed need to be recorded for each appointment. The employee is paid a commission for each successful appointment which results in a new customer purchasing a policy. Recording the status of 'successful' or 'unsuccessful' for each appointment is important for commission calculation purposes. The actuary who designs a product cannot be the one who evaluates it. Some changes may be made to products after an actuary reviews it. The history of changes is recorded, as the company wishes to know how their products have evolved over time. All products have associated liabilities covered, which describe the liabilities and costs that the individual or business can be insured for. All products have a maximum cover amount which cannot be exceeded. For all individual products there is a qualifying age which applies. Purchasing a Policy Customers can purchase insurance products tailored to their individual needs as a policy. The date and time a policy is purchased is recorded. Coverage of the product for each purchase needs to be recorded. The premium of each purchase varies depending on the purchaser's personal information and the product they are purchasing. Each purchase also has an excess amount decided by both the purchaser and the company. Each purchased policy has an end date on which the terms are reviewed/adjusted. When policies are renewed they are treated as a new purchase. Four weeks before a policy is set to expire the system generates and sends reminders to customers so that the customers will have enough time to consider the renewal of the policy. There are many ways in which the payment of premium for a policy can be made. Customers can choose to pay annually upfront by EFTPOS, cheque or cash, or pay fortnightly or monthly by direct debit. For customers who select to pay by direct debit, there bank account information will be stored. The company hopes to enable online payments for their customers at a later time. The company maintains a log of payments received for each policy. Claim A claim can be made by the customers when they seek the benefits provided by the insurance company due to a liability occurrence covered by the policy. A standard form must be filled when a customer wants to make a claim, key fields in the form include description of claimed situation, policy ID, claim lodged date and time. When a claim is received, an employee will review the customer's policy and conduct a thorough investigation into the claimed damages/loss to mitigate fraudulent claims. If the claim is determined to be genuine and approved by the employee conducting the investigation, then the claim is paid out and the date and time when the payment was processed is recorded. Not all insurance claims are paid out, but all the claims submitted by a customer should be recorded in his/her profile for future reference.
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
In Exercises 1 through 14, compute the indicated values of the given function. f(x) = 3x 2 + 5x 2; f(0), f(2), f(1)
-
Propose a mechanism to account for the fact that D-gluconic acid and D-mannonic acid are inter converted when either is heated in pyridine solvent.
-
A random sample of Brand X medication has a mean of 230 mg of its active ingredient. The standard deviation of the sample is 12 mg. Using the sample standard deviation as the population standard...
-
The Sun has mass \(M_{\odot}=1.9910^{30} \mathrm{~kg}\), radius \(R_{\odot}=7.010^{8} \mathrm{~m}\) and rotates on itself (approximately) in 30 days. Using the data in Table 11.1, determine: 1. the...
-
1. If a sample of 50 prospective customers is selected and no free premium channels are included in the 3- For- All service offer, given past results, what is the probability that a. fewer than 3...
-
You are given an undirected graph consisting of n vertices and m edges. It is guaranteed that the given graph is connected (i. e. it is possible to reach any vertex from any other vertex) and there...
-
The partnership of Cain, Gallo, and Hamm engaged you to adjust its accounting records and convert them uniformly to the accrual basis in anticipation of admitting Kerns as a new partner. Some...
-
Assume that on January 1, year 1, ABC Inc. issued 9,400 stock options with an estimated value of $13 per option. Each option entitles the owner to purchase one share of ABC stock for $25 a share (the...
-
Evaluate each expression in Problems 3-32. \({ }_{7} P_{5}\)
-
A step function voltage is applied to an RLC series circuit having R \(=2 \Omega, \mathrm{L}=1 \mathrm{H}\) and \(\mathrm{C}=1 \mathrm{~F}\). The transient current response of the circuit would be:...
-
Pork Corporation acquired all the voting shares of Swine Enterprises on January 1, 20X4. Balance sheet amounts for the companies on the date of acquisition were as follows: Swine Enterprises...
-
Evaluate each expression in Problems 3-32. \(\left(\begin{array}{l}5 \\ 4\end{array}ight)\)
-
How many permutations are there of the words given in Problems 33-42? CONCENTRATION
-
1) The speed of light in a specific medium is 0.8 c where c is the speed of light in vacuum. The refractive index of this medium is: 2) A light ray is incident upon a plane interface between two...
-
A container holds 2.0 mol of gas. The total average kinetic energy of the gas molecules in the container is equal to the kinetic energy of an 8.0 10-3-kg bullet with a speed of 770 m/s. What is the...
-
Describe four traditional techniques for collecting information during analysis. When might one be better than another?
-
Briefly describe several different business tasks that are good candidates for form-based interaction within an information system.
-
List various project team communication methods and describe an example of the type of information that might be shared among team members using each method.
-
Sumitomo Cable manufactures various types of aluminum and copper cables which it sells directly to retail outlets through its distribution channels. The manufacturing process for producing cables...
-
The Cooper Furniture Company of Potomac, Maryland, assembles two types of chairs (Recliners and Rockers). Separate assembly lines are used for each type of chair. Classify each cost item (AI) as...
-
The following data are for Marvin Department Store. The account balances (in thousands) are for 2017. 1. Compute (a) the cost of goods purchased and (b) the cost of goods sold. 2. Prepare the income...
Study smarter with the SolutionInn App