Reference no: EM13313047
Objectives:
After completion of this assignment, you will be able to:
- Map real world scenarios into ER diagrams
- Design ER diagrams and EER
- Produce relational schemas with constraints requirements
- Use specialization and generalization techniques
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.
Attachment:- Assignment.doc
|
How much work is done by the force of gravity on the box
: A 20kg box slides 45m from the top down to the bottom of an incline that is 10 degrees to the horizontal. How much work is done by the force of gravity on the box
|
|
Explain how to verify that the third central moment is zero
: Write a computer program that generates a sequence of random variables from a normal distribution with mean 5 and standard deviation 2. a) Verify that sample mean and the sample variance converge to the respective population values.
|
|
Prepare a job cost sheet
: Prepare a job cost sheet and record the information given above and also a cost summary for job and prepare a purchases budget in units and dollars for the quarter ending 30th December 2014.
|
|
Find the magnification of the image
: An object is 12.0 cm from the surface of a spherical Christmas tree ornament that is 8.00 cm in diameter. What is the magnification of the image
|
|
Design a database for an insurance company
: 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.
|
|
Write macro that will take the distance between two cities
: Transportation need to evaluate the time spent in traveling from city A to city B. The distance between the two cities is a variable because the macro developed is to be used for other cities.
|
|
Marketing and finance majors are different
: At alpha = 0.05 significance level, is there evidence to suggest that the number of courses successfully completed by management, marketing and finance majors are different? True or false: Ha: Umanagement not = Umarketing not = Ufinance
|
|
What are the criteria for selecting target markets
: What are the criteria for selecting target markets. What are the criteria for selecting targets? Why would they be different from the criteria for segmentation?
|
|
Professional context must create negative messages
: Sometimes, people writing in a professional context must create negative messages, such as a letter of termination, a press release regarding a company error, a denial of a claim, or a poor performance review. When you write such a negative message, ..
|