Construct an e-r diagram for database that models exams

Reference no: EM13268982

1. Construct an E-R diagram for the database that models exams as entities, and uses a ternary relationship.

2. Construct an alternative E-R diagram that uses only a binary relationship between students and course_offerings. Make sure that only one relationship exists between a particular student and course_offering pair, yet you can represent the marks that a student gets in different exams of a course offering.

3. Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. Summary statistics should be modeled as derived attributes.

4. Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents.

5. A weak entity set can always be made into a strong entity set by adding to its attributes the primary key attributes of its identifying entity set. Outline what sort of redundancy will result if we do so.

Reference no: EM13268982

Questions Cloud

What is the change of entropy of the steam : An exhaust tube from a steam generator is submerged in a large container of cool water. what is the change of entropy (in J/deg) of the steam

Determine the combined costs of two circuits : Design the minimum-cost circuit and compare its cost with combined costs of two circuits that implement f and g separately. Assume that the input variables are available in both uncomplemented and complemented forms.

What is the representative investor average degree : The expected rate of return on the market portfolio is 8.50% and the risk-free rate of return is 2.50%. The standard deviation of the market portfolio is 24%. What is the representative investor's average degree of risk aversion?

Calculate the work function of the material : When a certain photoelectric material is illuminated with red light (?=715) and then blue light (?=400), calculate the work function of the material

Construct an e-r diagram for database that models exams : Construct an E-R diagram for the database that models exams as entities, and uses a ternary relationship.

How does hofstede model help a marketer plan : Based on your experiences and readings, how does Hofstede's model help a marketer plan a global market entry?

What is the characteristic frequency of the combination : An inductance of 8 mH is combined in parallel with a capacitance of 1.5 µF. What is the characteristic frequency (Hz) (not radian frequency) of the combination

Find the maximum mass that the particle could possess : Suppose there was a process by which two photons, each with momentum 0.60MeV/c ,could collide and make a single particle. find the maximum mass that the particle could possess

Calculate the time required for the voltage to fall to 1 v : An RC circuit with a time constant T = 30 msec has reached a steady state of 2 V at time t = 0. The circuit is then suddenly switched to ground (0 V). Calculate the time required for the voltage to fall to 1 V.

User Account

All Pages