LENGTH OF WORDS-700 Conduct a research on how you will implement a webdatabase ,

Question

LENGTH OF WORDS-700

Conduct a research on how you will implement a webdatabase ,described in the above business case,in cloud instance.your research should be based on recent developments in the field of database technologies.Your response should address not only the implementation considerations,but also the security issues

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 systemm 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

Explanation / Answer

UPDATE: Let me know in the comment, if this question requires anything apart from database aspect of the application.

1. Lets first start with Trainees entity where each row/record of the entity holds a single trainee information. This entity even has an attribute called trainee_id which is the primary key for this entity.

So, the entity can be something like Trainee(trainee_id, first_name, last_name, age, gender, etc)

2. Since this a web application and public web pages are open to every one, there needs to be some authentication of all the users of the application. We'll use username and password based login authentication. For this, each trainee needs to have a username and password. Lets maintain this another entity.

Note: Storing plain text passwords is huge security concern. The password field here assumes that the original passwords are salted and the encrypted form of the passwords are stored in the database.

So, the entity can look like User (username, password, trainee_id, created_date, etc)

Here, trainee_id is the foreign key to the trainee_id in the Trainee entity.

3. Coming to the key part of the business, i.e., Training Sessions. Let's have an entity for this as well.

TrainingSession(id, session_name, start_time, end_time)

This entity will only hold the data of just the training information but nothing related to the trainees who are attending. We will have a separate entity for that.

4. To capture the trainees who are interested/ want to enroll for a training session, we use a transactional entity named TrainingEnrollment entity. This entity holds all the information of all the trainees who want to attend/enroll for a training session.

TrainingEnrollment(id, training_session_id, trainee_id, attending, etc)

Here, training_session_id is a foreign key to the id of the TrainingSession entity and Trainee_Id is a foreign key to the id of Trainee entity.

5. Finally, all the webpages data will only be visible to those who are logged into the systems which is achieved by User entity. For the ease of quickly implementing the system, we can make use of cloud databases (AWS, Azure, etc) which are very easy to setup and get them up and running.

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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