Length: 700 words You are required to conduct research on how you will implement

Question

Length: 700 words

You are required to conduct research on how you will implement the web database, described in Assignment 1 (Modelling) business case, in a cloud instance.

Your research should be based on recent developments in the field of database technology.

Your response should address not only the implementation considerations but also the security issues

Overview of the business case in Assignment 1 (Modelling):

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 the 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: https://www.youtube.com/watch?v=YvJ4t9_2SWk

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.

Explanation / Answer

Case 1:Each player should have participated 20 training sessions

Case2: Each player should have training session ID to participating training sessions

Case3: Each player has to mention the name , Date of Birth and playing position will be recorder in the system

Case 4: 6 or more players must attend in each training session

Note represents the players who attend each training session

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.