You are an insurance salesperson. You sell life, home and auto insurance. You want to track the necessary information fo

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

You are an insurance salesperson. You sell life, home and auto insurance. You want to track the necessary information fo

Post by answerhappygod »

You are an insurance salesperson. You sell life, home and autoinsurance. You want to track the necessary information for eachtype of insurance as well as Client information. Think broadlyabout this modeling situation and how you would design it to trackthe various forms of insurance you sell and the range of customersyou service (note: some will purchase life, home and auto whileothers may only purchase one of the insurance products youoffer).
i) Supply a neatly drawn ERD diagram (scan it or take a picture)for this situation. ii) Provide a narrative paragraph that explainsyour ERD diagram. The paragraph should be written in a manner thatwould allow a database modeler to produce your ERD diagram usingonly the words of your paragraph.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply