Closed

Modelling related to ERDs (max budget 25 aud) Deadline with in next 18 hours.

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.

NOTE

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.

Sample is attached.

Beceriler: Veri Tabanı Yönetimi, Veritabanı Geliştirme, MySQL

Daha fazlasını gör: max budget, models architectural modelling studio max, budget max, how to work on freelancer, freelancer website, freelance meaning, freelancer jobs, freelance jobs online, freelancing, freelancer login, freelance jobs, max modelling, modelling landscape 3ds max, modelling outdoors studio max, modelling building 3ds max gis, modelling truck 3ds max, modelling landscapes 3ds max, 3d terrain modelling template 3ds max, free modelling truck 3d max, modelling photography 3ds max

İşveren Hakkında:
( 6 değerlendirme ) Burwood, Australia

Proje NO: #17602838

Bu iş için 5 freelancer ortalamada $27 teklif veriyor

dekinghtg

what time is this project have to get done?

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(5 Değerlendirme)
3.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
jeyasriramesh

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
enghghali

G'day xbblc67, I`m a professional database designer, over ten years working in the database field as an administrator, programmer, and analyst. Do you want to add additional information or note in the system for ab Daha Fazla

in %bids___i_period_sub_35% gün içinde24%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Warunagamage

I have experience and skill for this project because I have done the similar project in university. Also, I can complete this one very quickly.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0