Reference no: EM131085197
Exercise 2.5 Notown Records has decided to store information about musicians who perform on its...
Exercise 2.5 Notown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer (at your usual consulting fee of $2500jday).
Each musician that records at Notown has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone.
Each instrument used in songs recorded at Notown has a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, B-flat, E-flat).
Each album recorded on the Notown label has a title, a copyright date, a format (e.g., CD or MC), and an album identifier.
Each song recorded at Notown has a title and an author.
Each musician may play several instruments, and a given instrument may be played by several musicians.
Each album has a number of songs on it, but no song may appear on more than one album.
Each song is performed by one or more musicians, and a musician may perform a number of songs.
Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course.
Design' a conceptual schema for Notown and draw an ER diagram for your schema. The preceding information describes the situation that the Notown database must model. Be sure to indicate all key and cardinality constraints and any assumptions you make. Identify any constraints you are unable to capture in the ER diagram and briefly explain why you could not express
Describe the factors that influence wage setting
: Describe the factors that influence wage setting. Write down the equation that represents wage setting, describe the effect of each factor in the equation/function, and draw the corresponding diagram. Clearly state the assumptions behind your analysi..
|
Resistance of the coil
: Determine: (a) the resistance of the coil,(b) the current flowing in the circuit one second after the shorting link has been placed in the circuit, and (c) the time taken for the current to fall to 10% of its initial value.
|
Content with the steady pace of economic recovery
: Consider that content with the steady pace of economic recovery, the Federal Reserve Bank decides to undertake a large-scale asset sale resulting in a decrease in money supply. What would be the effect of such a policy on equilibrium interest rate in..
|
Delta-connected load comprises a resistance
: Each phase of a delta-connected load comprises a resistance of 30 and an 80 μF capacitor in series. The load is connected to a 400 V, 50 Hz, 3-phase supply.
|
Identify any constraints you are unable to capture
: Identify any constraints you are unable to capture in the ER diagram and briefly explain why you could not express
|
Calculate the current supplied by the alternator
: A 400 V, 3-phase star connected alternator supplies a delta-connected load, each phase of which has a resistance of 30 and inductive reactance 40. Calculate the current supplied by the alternator
|
Supply current and its phase angle
: A pure inductance of 120 mH is connected in parallel with a 25 μF capacitor and the network is connected to a 100 V, 50 Hz supply. Determine (a) the branch currents, (b) the supply current and its phase angle, (c) the circuit impedance, and (d) th..
|
Determine the values of c and r
: A capacitor C is connected in parallel with a resistor R across a 120 V, 200 Hz supply. The supply current is 2 A at a power factor of 0.6 leading. Determine the values of C and R.
|
What is the hit ratio taking in to consideration the write
: What is the hit ratio taking in to consideration the write cycle?
|