Consider the following scenario and answer the questions below.Customers wishing to claim after an accident should visit the insurance company within 2days. The insurance company will take details of the location of accident, date and time,report_no. The details of the car and the driver should also be provided. The customers ownone or more cars each. Each car has associated with it zero to any number of recordedaccidents. The driver may have met with one or more accidents. The driver has driver ID,name, license and address. The car has serial_no, model and year manufactured.i. List the entities with their corresponding attributes.ii. Draw an E-R diagram for a car-insurance company.

1. The entity along with their attributes are Car(Serial_no, ManufactureYear) Driver(DriverID,…

onsider the following scenario and answer the questions below. ustomers wishing to claim after an accident should visit the insurance company within 2 ays. The insurance company will take details of the location of accident, date and time, port_no. The details of the car and the driver should also be provided. The customers he or more cars each. Each car has associated with it zero to any number of recorded cidents. The driver may have met with one or more accidents. The driver has driver ID ame, license and address. The car has serial_no, model and year manufactured. List the entities with their corresponding attributes. Draw an E-R diagram for a car-insurance company.

onsider the following scenario and answer the questions below. ustomers wishing to claim after an accident should visit the insurance company within 2 ays. The insurance company will take details of the location of accident, date and time, port_no. The details of the car and the driver should also be provided. The customers he or more cars each. Each car has associated with it zero to any number of recorded cidents. The driver may have met with one or more accidents. The driver has driver ID ame, license and address. The car has serial_no, model and year manufactured. List the entities with their corresponding attributes. Draw an E-R diagram for a car-insurance company.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Consider the following information and use it to answer the questions that follow;A customer owning account 801 is transferring Ksh. 139,500 from his account to an account998 belonging to one of his business partners. The business partner (owner of account 998) isalso trying to settle a debt of raw materials supplied by one of his suppliers by issuing acheque of 150,000. Assume that cheques are debited (credited) immediately after beingdeposited.Assume the bank has a rule that minimum balances cannot go below zero. What anomaly might have occurred above? Why so?
Consider the following scenario: you've been tasked with developing a logical model of a school or college's registration system. Is a top-down strategy preferable, or is a bottom-up approach preferable in this situation? What considerations could have an influence on your decision?
E8.4 Consider the following scenario involving Pineview Ford, an auto dealership. Auto dealership Pineview Ford is organized as follows: • Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership. • Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle. • Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle. • In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle. Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below. Source 1 Pineview Sales and Service Database Source 2 Pineview Rental Log The data warehouse has to enable an analysis of revenue by…
E8.4 Consider the following scenario involving Pineview Ford, an auto dealership. Auto dealership Pineview Ford is organized as follows: • Pineview Ford keeps track of Vehicle Identification number of every vehicle that is for sale, sold, serviced, or rented by the dealership. • Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle. • Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle. • In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle. Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below. Source 1 Pineview Sales and Service Database Source 2 Pineview Rental Log The data warehouse has to enable an analysis of revenue by…
The scenario is for a small life insurance agency and their need to keep track of clients, agents, insurers, and quotations. 1) A Client is a customer, potential customer, or contact of the agency. We need to assign each client a number and save their last name, first name, birth date, gender, telephone number, email address, and the agent who brought the client into the agency. If a client is a “walk in” they are assigned to the first available agent. All clients must have one primary agent. 2) An agent is a licensed individual with the state. Each agent has a nationally unique license number, last name, first name, telephone number, and email address. An agent must be the primary agent for at least one client but may not be primary for more than 500 clients. An agent must also be part of at least one quotation and may share in an unlimited number of quotes. 3) The agency represents (does business with) many insurance companies (insurers). We will need to track each insurer with an…
Q2: To answer this question, let's take an example of a university faculty with six professors (3 men and 3 women). Professors are ranked from lowest to highest, with 1 being the lowest and 3 being the highest. The male professors are identified as Rao (1), Lalit (3) and Ahmed (2). The Professor's names with their ranks are Monu (3), Rana (1), and Kitty (2). Below are some examples of situations. For each example, provide an ASN.1 description of the record values and their corresponding data types. Consider the ProfessorData data type, which contains details about each professor. An alphabetical list of professors. A list of professors in descending order. There are two sets of professors, each of which consists of a higher-ranking female professor and a male professor of a lower level.
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee Hasan employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.
Draw the associations that are described by the business rules below. Includethe multiplicities for each relationship A bookstore sells at least one book, and a book can be sold at up to 10 otherbookstores around town
Hello, Can you tell me if for this exercise, there are 6 or 7 entities? and if, tell me why? Because someone told me that GreenChampion is an entity but I'm not sure about that. I wanted to know also, why we don't connect carbon transaction with product with the verb "recorded" since the sentence said that : 'Optionally, the single product that the carbon transaction relates to can also be recorded'. Thank you.
Using signavio or any PBM tools and must Use pool and lane and object. Model the following fragment of a business process for insurance claims. After a claim is registered, it is examined by a claims officer who then writes a settlement recommendation. This recommendation is then checked by a senior claims officer who may mark the claim as “OK” or “Not OK”. If the claim is marked as “Not OK”, it is sent back to theclaims officer and the recommendation is repeated. If the is “OK”, the claim handling process proceeds.
Consider the following scenario A student has a name, which consists of a given name and a family name, and a student IID. Each student is uniquely identified by his/her student ID.A course has a subject and a course ID. For each course, we want to record the number of students taking that course and the type of equipment being used for the course. A course is uniquely identified by its course ID.A student can be enrolled in an arbitrary number of courses, and an arbitrary number of students can be enrolled in a course. For each course in which they are enrolled students receive a lab mark and an exam mark.A course cannot exist if there is no student enrolled in it.A school is distinguished by the honour's degree that it awards. We also want to record to which faculty a school belongs. A student is registered with at most one school, while a school can have an arbitrary number of students. Questions a) Draw an Entity Relationship Diagram b) translate the ERD into a relational data…
For each of the following collection of entities, give the assumptions concerning the relationship between entities and attributes. EMPLOYEE(EMP_NUM, EMP_LNAME, EMP_INITIAL, EMP-DOB) DEPENDENT(EMP_NUM, DEP_NUM, DEP_FNAME, DEP_DOB)