Er Diagram For Car Insurance Company In Dbms
It is under tremendous pressure maintaining their day to day activities which is currently.
Er diagram for car insurance company in dbms - Student student id name dept name tot cred. Customer id name address phone dob car license year color model accident id number date amount relationship. Insurance database management system prepared by.
This erd example shows the entities involved in a car insurance system. Use this erd template to get started building your own. Car insurance company construct an e r diagram for a car insurance company whose customers own one or more cars each.
Figure 7 1 e r diagram for a car insurance company. Er diagrams are a visual tool which is helpful to represent the er model. Each car has associated with it zero to any number of recorded accidents.
It consists of person car and accident. He aimed to use an er model as a conceptual modeling approach. The description of the environment is as follows.
Each car has associated with it zero to any number of recorded accidents. The company has 10 instructors and can handle up to 100 trainees for each training. It was proposed by peter chen in 1971 to create a uniform convention which can be used for relational database and network.
Kayalvizhi g sangeetha i saraswathi g 2. Construct an er diagram for car insurance company that has a set of customers each of whom owns one or more cars. Entity relationship diagrams erd are widely used in database design and systems analysis to represent systems or problem domains.
The insurance company needs to keep track of details of its target companies agents policyholders their premium payments and the various products. Create an er diagram for complex database. Clearly indicate the entities relationships and the key constraints.
We will create an entity relationship diagram for an auto insurance company to keep the policy information and you can see the data dictionary of this e r diagram in figure 2 which tells the purpose of each column. The entity relationship diagram of vehicle insurance management system shows all the visual instrument of database tables and the relations between insurance payments vehicle license etc. This er entity relationship diagram represents the model of vehicle insurance management system entity.
