Reference no: EM13310495
Question 1 (Design ER Diagram):
Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture
the following:
1. We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs.
2. each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses.
3. Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team.
4. For each match we need to keep track of the following:
oThe date on which the game is played
oThe final result of the match
o The players participated in the match. For each player, how many goals he scored,
whether or not he took yellow card, and whether or not he took red card.
O During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place.
- Each match has exactly three referees. For each referee we have an ID (unique identifier), name, DoB, years of experience
. One referee is the main referee and the other two are assistant referee.
Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design Make sure cardinalities and primary keys are clear
Question 2
(Relational Model):
Map the ERD in Question 1 to create the relational model corresponding to the described application. Basically, list the CREATE TABLE statements with the attribute names, and appropriate data types. Also make sure to have the primary keys and foreign keys clearly defined.
Question 3: Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan Gurukul Company that provide better security also design a data abstraction for his client kataria publication, that is publisher of computer book. Assume suitable data that suits your requirement and design and explain the 3- schema architecture for the requirement.
|
How to evaluate the equilibrium constant for the reaction
: A reaction has a standard free-energy change of -14.00 kJ mol-1 (-3.346 kcal mol-1). Calculate the equilibrium constant for the reaction at 25 °C.
|
|
Compute the rate of return per quarter for each bond
: A company issues corporate bonds that have a coupon rate of 4%, pays dividends quarterly, and has a term of 10 years. Compute the dividend paid per quarter for each bond.
|
|
Explain standard free energy of activation of one reaction
: The standard free energy of activation of one reaction A is 85.50 kJ mol-1 (20.43 kcal mol-1). The standard free energy of activation of another reaction B is 78.70 kJ mol-1 (18.81 kcal mol-1).
|
|
Calculate the surface area and hydraulic retention time
: Calculate the surface area (m2), diameter (m), volume (m3), and hydraulic retention time of a 3 m deep circular, primary clarifier that would remove 50 percent of suspended solids. Assume the surface overflow rate (SOR) used for design is 60 m3/m2-..
|
|
Create the relational model
: Create the relational model corresponding to the described application. Basically, list the CREATE TABLE statements with the attribute names, and appropriate data types.
|
|
Define a coin dealer offered a rare silver coin
: A coin dealer, offered a rare silver coin, suspected that it might be a counterfeit nickel copy. The dealer heated the coin, which weighed 18.0 g to 100°C in boiling water and then dropped the hot coin into 26.5 g of water at T = 16.5°C in an insu..
|
|
Determine the required source temperature of heat sink
: A Carnot heat engine is supplied with a high temperature heat source at a rate of 200 kW. If the power output of the heat engine is 120 kW, determine the required source temperature if the heat sink temperature is 20 °C.
|
|
Explain the homo and which is the lumo in the excited state
: Which MO is the HOMO and which is the LUMO in the excited state 5. How many nodes does the highest-energy molecular orbital of 1,3,5,7-octatetraene have between the nuclei
|
|
Use a single blank line to separate code blocks
: Do not identify yourself in your source code file. The system will maintain your identity and keep the process of reviewing anonymous. Upload the this file using the Submission Facility below, then proceed to completing reviews.
|