Reference no: EM13331080
You are to design a database for an insurance company. The data will include information about customers (name, address, phone number), information about insured cars (make, model, year, vehicle-ID#, license#, insurance rate), information about insured homes (address, insured value, insurance rate), and information about claims made on insured cars and homes (date of claim, date of settlement, amount of settlement). You may assume that all insured cars and homes are owned by a single customer, but you should allow a customer to own several cars and homes. Please state any additional assumptions you make about the real world in your design.
a) Specify an entity-relationship (E/R) diagram for your database. Don't forget to underline key attributes for entity sets and include arrowheads indicating the multiplicity of relationships (with rounded arrowheads for referential integrity). If there are weak entity sets or "isa" relationships, make sure to notate them appropriately.
Problem III:
Consider the EER diagram for a car dealer in the figure below. Map the EER schema into a set of relations. For the VEHICLE to CAR/ TRUCK/ SUV generalization, consider the four options presented in Section 9.2.1 and show the relational schema design under each of those options.
|
Find out the mass of 100 ml of solution
: Determine the mass of 100 mL of solution for this reaction: the results were 2.05 g of NaOH, 102.05 grams (total solution-when added with the water).
|
|
Calculate the altitude of the rocket when the engine cut out
: You are visiting NASA and are watching a test rocket launch. You estimate that at launch the angle of elevation of the rocket is 60 degress, calculate The altitude of the rocket when the engine cut out
|
|
Explian what is the percent composition of this solution
: Dr. Carvell made up a 5X stock of ONPG stock solution that has a concentration of 50 mN. The molecular mass of ONPG is 354.7. What is the percent composition of this solution
|
|
Define what compound would be formed and isolated
: If your methanol was wet (contained water), what compound would be formed and isolated along with trityl methy ether. Explain and what effect would that have on the melting point of the product
|
|
Consider the eer diagram for a car dealer
: Consider the EER diagram for a car dealer in the figure below. Map the EER schema into a set of relations. For the VEHICLE to CAR/ TRUCK/ SUV generalization.
|
|
Explain how to calculate the predicted ph values
: Acetic acid is a weak acid whose Ka is 1.8 X 10^-5. Calculate the predicted pH values for 1.0 M, 0.10 M, and 0.010 M acetic acid.
|
|
Draw the er diagram for the database described above
: Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game
|
|
What is the acceleration of the boy
: A boy is standing on a frozen lake (i.e. no friction) holding a rope that is attached to his sled. He pulls on the rope and exerts a horizontal force of 5.2 N, What is the acceleration of the boy
|
|
Define solutions in descending order according to the volume
: Arrange the following solutions in descending order according to the volume of each that will react with 1L of 1M HCl a) 1 M NaOH b) 1.5 M Ca(OH)2 c) 2 M KOH d) 0.6 M Ba(OH)2 Give the volumes of each solution needed for the reaction
|