Reference no: EM13331075
Problem I:
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. For each character in the game, it contains the character's name. The video games may be available at the store in different formats. Different formats may have different prices. Each game and format has a status indicating whether it is discontinued or not.
1. Draw the ER diagram for the database described above.
2. Create a relational database schema for this model assuming
a) Each video game in the database is available at the store in exactly one format.
b) Some video games in the database may not be available at the store and others may be present in more than one format.
Provide the name of the table, primary key, and other attributes for each table in your solution. Think intelligently between various choices available to map the E/R diagram to relations, to get best design for the problem in hand. Minimize the use of NULLs. Your representation will be evaluated based on correctness and succinctness.
Problem II:
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.
|
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
|
|
Create a relational database schema for this model assuming
: Consider the EER diagram for a car dealer in the figure below. Map the EER schema into a set of relations.
|
|
Compute the average force exerted on the ball by golf club
: A golf ball of mass 0.045 kg is hit off the tee at a speed of 32m/s. Find the average force exerted on the ball by the golf club
|
|
Explain what is the energy spacing
: If the emitted green light corresponds to an electron dropping from that excited state back down to the ground state, what is the energy spacing (in aJ) between the highest occupied and lowest unoccupied orbitals. The element used is Thallium.
|
|
What is the period of a satellite in a geosynchronous orbit
: Communications satellites are placed in a circular orbit where they stay directly over a fixed point on the equator as the earth rotates. What is the period of a satellite in a geosynchronous orbit
|
|
Estimate for the current dollar value of gross domestic
: For the 2nd quarter of 2011, identify the estimate for the current dollar value of Gross Domestic Product for the USA and explain in words what this number measures.
|