Design an er diagram to capture the given requirements

Assignment Help Database Management System
Reference no: EM13321555

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.

Reference no: EM13321555

Questions Cloud

Explain the net ionic equation obtained in nacl(aq) : 3)Which statement describes the net ionic equation obtained between NaCl(aq) and KBr(aq). A) The net equation is Na+(aq)+ Br+(aq)= NaBr(s) B) All spectator ions cancel out, therefore there is no reaction.
How many turns are on the primary side : A transformer has input voltage and current of 12 V and 6 A, and an output current of 0.8 A. how many turns are on the primary side
Managing international operations : Apply IOM (International Operations  Management) concepts/tools to solve problems in managing international operations.
How far apart are the lenses : An elderly sailor is shipwrecked on a desert island but manages to save his eyeglasses. How far apart are the lenses when the telescope is adjusted for minimum eyestrain
Design an er diagram to capture the given requirements : Design an ER diagram to capture the requirements. State any assumptions you have that affects your design and three-level schema architecture for the Gyan Gurukul Company that provide better security also design a data abstraction for his client ka..
Explain what one statement best describes the molecule : A molecule, whose formula is AB, dissolves in water and also conducts electricity. What one statement best describes this molecule after it's placed in water. A)AB exists as a molecule only.
Compute the height of the image : A 0.54 cm high object is placed 8.7 cm in front of a diverging lens whose focal length is -7.5 cm. What is the height of the image
Find the magnitude of the total force on the port : An evacuated spherical diving bell containing a camera is in the ocean at a depth of 187 m. Find the magnitude of the total force on the port
What is the distance travelled during the trip : A spaceship travels at a speed of 0.90c to a star that is 9.0 ly away. what is the distance travelled during the trip

Reviews

Write a Review

 

Database Management System Questions & Answers

  Define er diagram and database implementation

Development of an ER Diagram and Database Implementation- Course Objectives: This assessment task focuses on the following course objective -ITECH1006

  Drawing active directory hierarchy in terms of forests

Draw Active Directory hierarchy in terms of forests, trees, domains, organizational units, and sites which are most suitable for this company and their security concerns.

  Design database design for boingx aircraft company

You have been asked to design database design for BoingX Aircraft Company (BAC), that has two products: TRX-5A and TRX-5B HUD (heads-up display) units.

  Convert data model to a set of virtual windows

You are to design a prototype for a hospital management system. Design a data model for this system, Convert the data model to a set of virtual windows.

  Prepare table which is in first normal form

Prepare the example of table which is in first normal form but not in second normal form and example of a table which is in second normal form but not in third normal form.

  Explain what information is available in relational database

Explain what information is available from relational database containing one relation with attributes Name, Employee identification number, and Address which is not available.

  Explain the concept of physical data independence

Explain the concept of physical data independence and its importance in database systems,  List four significant differences between a file-processing system and a DBMS.

  Mark the words as index entries behavior and favorable

Mark the following words in the document as index entries: behavior (four instances), favorable (five instances), and impression (eight instances).

  Indicate change to make original premiere products database

Indicate the changes (using the shorthand representation) that you would need to make to the original premiere products database desing to support the following requirements.

  Potential sales and department store transactions

Identify the potential sales and department store transactions that can be stored within the database and design a database solution and the potential business rules that could be used to house the sales transactions of the department store.

  Kinds of joins

It is not uncommon to have to access the data which reside in different tables, especially when formulating a report.

  Describe implement relationship between employees-projects

Describe how you would implement relationship between employees and projects in each of the given scenarios: Many employees can work on given project, but each employee can work on only single project.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd