create erd

Overview of business case:

Bruce is a volunteer football (soccer) coach at XYZ United. At this stage, to announce training sessions, Bruce sends an SMS to his players. While this system works for him, it does not help him with getting accurate numbers of those who are coming to training sessions, especially when there are last minute changes. To address this problem he decided to implement a web database system. Accordingly, he hired you to design a relational database to better track and record the operational data.

NOTE: The overview of business case is included here to provide context only. For the purpose of identifying entities, attributes and relationships between entities please read the business rules and instructions for creating your ERD below.

NOTE: For guidance on how to draw an ERD based on business rules, watch this YouTube video: [login to view URL]

The business rules and instructions for creating your ERD:

Each player is expected to attend all 20 training sessions. For each training session to go ahead, six or more players must register to attend it. Every training session is identified by a training session ID. The date, time and venue are also kept in the system for each training session. Each player is identified by a player ID. For each player, the player’s name, DOB and playing position are recorded in the system. An important training session’s detail is that the system also takes note of the players who attended each training session and the rating of the performance that each player gives at the end of each training session.

Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.


Use [login to view URL] to create your ERD

Use Crows Foot notations

Include the PKs where appropriate

Any M:N relationship is to be resolved to a 1:M relationship

Manually drawing the ERD is NOT acceptable.


back to top

This assessment task will assess the following learning outcome/s:

be able to model complex business rules using Entity Relationship Diagrams (ERDs).

Compétences : Administration de Bases de données, Développement de bases de données, Programmation de bases de données, MySQL, Oracle

en voir plus : er diagram tool open source, draw er diagram online, generate er diagram from sql online, automatic er diagram generator, entity relationship diagram visio, database diagram tool free, er diagram tool free download, erd plus, create end flash website, create front end user interface excel, create web database front end iphone, create front end excel, create multimedia front end, joomla create module position, create site end, create end myspace, create web app access end, create end character animal, create database end form, create module position joomla

Concernant l'employeur :
( 0 commentaires ) Australia

Nº du projet : #17606162

11 freelance font une offre moyenne de $61 pour ce travail


Hi, Being experienced in working on several ERD designing projects, I can help in getting your project done quickly and efficiently for the scenario mentioned in the description. I assured you of quick and efficient Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(59 Commentaires)

FREELANCER RECOMMENDED ------------------------------------------------------ Can help... I am an Expert in Databases... Lets Start! Please start a Discussion with me and we can get started from there... Please che Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(14 Commentaires)

Hi, I have read the project description and feel very comfortable with it. I have Passat experience about creating ER diagrams. Please see my profile section for Past Works. I have over 8 years of Experience in data Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(10 Commentaires)

I'm a Bsc degree holder in computer science. I have worked on many papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(11 Commentaires)

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(22 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(1 Évaluation)

Dear sir i understood your needs. The first step in designing the database is creating entity relationships diagrams. So i am offering you my skills to do this tasks for you. i am willing to do the following for you Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)

I will make and deliver your ERD in 1-2 hours. With quality and professional work. I am System Analyst working in this field for about 2 months. I will wait for your response on my bid. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(0 Commentaires)

Hi, Bandwidth available to start on it immediately and deliver within 2 hour as your requirement aligns with my work profile. - Jeyasri

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)