Reference no: EM13949448
After completing a course in database management, you have been asked to develop a preliminary ERD for a symphony orchestra. You discover the following entity types that should be included:
- CONCERT SEASON The season during which a series of concerts will be performed. Identifier is Opening_Date, which includes Month, Day, and Year.
- CONCERT A given performance of one or more compositions. Identifier is of the following: Month, Day, Year, and Time. Each concert typically has more than one concert date.
- COMPOSITION Compositions to be preformed at each concert. Identifier is Composition_ID, which consists of the following: COMPOSER_Name and Composition_Name. Another attribute is Movement_ID, which consist of two parts: Movement_Number and Movement_Name. Many, but not all, compositions have multiple movements
- CONDUCTOR Person who will conduct the concert. Identifier is Conductor_ID. Another attribute in Conductor_Name.
- SOLOIST Solo artist who performs a given compostion on a particular concert. Identifier is Soloist_ID. Another attribute is Soloist_Name.
During further discussion you discover the following:
- A concert season schedules one or more concerts. The particular concert is scheduled for only one season.
- A concert includes the performance of one or more compositions. A composition may be performed at one or more concerts or may not be performed.
- For each concert there is one conductor. A conductor may conduct any number of concerts or may not conduct any concerts.
- Each composition may require one or more soloists or may not require a soloist. A soloist may perform one or more compositions at a given concert or may not perform any composition. The symphony orchestra wishes to record the date when a soloist last performed a given composition (Date_Last_Performed).
Draw a ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the E-R diagram. Also draw a data model for this situation using the Vision
|
Which method do you believe is more effective
: Which method do you believe is more effective (written or face-to-face) and why? Please give an example to support your choice?
|
|
Calculate coefficient of correlation between these variables
: Estimate the value of torque required when the diameter is 16 mm. Calculate the coefficient of correlation between these variables and comment on your prediction obtained in (c).
|
|
Input current and power factor of motor
: 1. A six-pole, three-phase, 440-V, 60-Hz induction motor has the following model impedances: RS = 0.8 Q XS = 0.7 Q RR = 0.3 Q XR = 0.7 Q Xm = 35 Q Calculate the input current and power factor of the motor for a speed of 1,200 r/min.
|
|
Use quantitative methods to support evidentiary findings
: Researchers prefer to use quantitative methods to support evidentiary findings. According to Creswell (2009), the purpose of a survey design is to provide numerical trends to sample a population's belief and or opinion regarding a specific study
|
|
Identify a business rule in this description
: Draw a ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the E-R diagram. Also draw a data model for this situation using the Vision
|
|
Discuss the value of classifying costs by activity category
: Discuss the value of classifying and reporting costs by activity category. Calculate the total manufacturing cost to produce 20,000 units of the deluxe model. Present the total cost for each activity category.
|
|
Who want more family discussions about school
: Estimate the proportion of all teenagers who want more family discussions about school. Use a 99% confidence level.
|
|
Determining the three-phase induction motor
: 1. A four-pole, three-phase induction motor rotates at 1,700 r/min when the load is 100 N-m. The motor is 88 percent efficient. a. Determine the slip at this operating condition.
|
|
Respond to the given discussion
: Creswell (2009) identified surveys and experiments as two methods by which to conduct quantitative research (p. 145). He defined a survey design as one providing a "numeric description of trends, attitudes, or opinions of a population by studying ..
|