Couchbase Assignment | Online Assignment

(Show screenshots of your results) construct a NoSQL database, using the modern data platform, Couchbase populate it with JSON documents relevant to your proposal query ( within the analytics module ) and retrieve data from those documents, according to the (5+) questions you wanted answered in your initial proposal. How to do this will be the subject of tutorials in the final weeks( this will be much easier than installing and running SQL-Server actually )! MAKE SURE TO USE THE INITIAL PROPOSAL TO GET THIS DONE AND I NEED ALL THE REQUAIRMENTS DONE WITH A SCREENSHOT PLEASE.

Introduction and Context

In the current world, education is considered to be a dynamic field that has seen the implementation of technology in order to improve learning. I have picked this area as it is of interest to me regarding how data is supposed to be stored and utilized in order to make it easier for the managers and faculty to spearhead policies that would benefit the learners and stakeholders. Some of the information that is stored in school databases includes the grades of the students, the fees paid, the demographics, as well as the abilities among the students displayed in clubs and other co-curriculum activities. All these are instrumental in managing a school and they need to be stored in a website that would be secure. Unlike finance, any infiltration of such a database might not be as costly as one would expect as the unauthorized personnel might not use the data for monetary gains.

Importance of the Area

To me, education is a crucial aspect that needs to be taken into consideration as it determines the future of any country. When it is substandard, the chances are high that the learners would be half0baked and they would end up making costly mistakes in their respective fields. For example, graduate engineers who were taken through a faulty or poorly managed education system would come up with systems which are flawed, causing harm to the unsuspecting public. This sector is also instrumental in understanding how schools can manage databases for easier access by authorized parties who can use it for research or even improve the curriculum design and implementation at any particular instance.

In recent times, private schools have been considered to have the highest quality of education based on how they are being managed. This means that accessing data from such schools is easier, and teachers can easily compare performances over certain periods. They can also compare notes regarding the development of other rival schools so long as they have access to the data from such institutions. Thus, this field elicits some crucial aspects of interest, which would be instrumental for educators as well as policymakers in equal measures. Additionally, comprehending the nested components and attributes would be helpful to a database manager who would like to make a user-friendly system that data would be stored. Recently, curriculum development and similar amendments have been spearheaded by officials from some of the high-ranking leadership positions (Prananosa, Wahyudi, & Widodo,2019). However, such changes might not bear any fruits if the best databases are not put in place. This is because decision-making processes need to consider what has been documented in the past and the number of students who are set to profit from the same.

Acquisition and Description of a Small Collection of Information

In the education sector, there exist some probable collections of information that can be stored in the database (Prananosa, Wahyudi, & Widodo,2019). All these make up the entire system which determines how students are being instilled with the knowledge that they are in need of and the manner in which all these aspects create an environment conducive for running many other activities. The first one is the school entity with the attributes;

1. school_id
2. school-name
3. school_type
4. school_description

The next entity is the student entity which usually captures the information of the learners in the school setting. The attributes are captured as follows;

1. student_college_id
2. student_name
3. student_mobile
4. student_email
5. student_username
6. student_password

In this structure, the coder will be limited to one particular category per student even though this is not the case in most of the cases. However, there is a need to list categories in multitudes and also adding relationships with other sections of the education system databases for proper management.

The third entity is classes entity which is made up of;

1. class_student_id,
2. class_room,
3. class_name,
4. class_type,

The fourth one is the teaching entity which includes attributes such as;

1. teacher_id
2. teacher_college_id
3. teacher_name
4. teacher_password

The fifth is courses entity which has attributes such as;

1. course_id
2. course_student_id
3. course_registration
4. course_name
5. course_type
6. course_year

The last one is registrations entity which is made up of;

1. registration_id
2. registration_student_id
3. registration_course_id
4. registration_name
5. registration_type
6. registration_number
7. registration_date

Regarding the relation aspects, the following can be noted;

1. Student must have courseID attribute
2. Unit should have courseID attribute
3. Teacher should have departmentID attribute
4. Course should have departmentID attribute

Questions

When the items listed above will be stored in the database, there will be the need to understand their exact quantities.

1. How many students are doing a specific course?
2. Which course has the most students?
3. Which department has most lecturers?
4. How many students are in year 1 of college?”
5. How many instructors teach computer-related courses?”
6. How many students should be served by one teacher without feeling exhausted?”

All these questions will help in designing the database while considering the available resources. For example, it can be vital in allocating classes and managing syllabuses without making the teachers demotivated in whatever they do. This way, they will be instrumental towards the success of the institution.

Modeling Diagram

In this modeling diagram, crucial tips would be derived which can then be used in the coding session using Python. The entities listed above have been contextualized to understand the existing relationships between them as well as how the attributes have been directed in the design of the database that would be used for educational purposes. By doing so, one is able to understand how students, teachers, as well as departments can interplay to give the best results in the end.

Fig 1: Modeling diagram for the JSON chart.

References

Prananosa, A. G., Wahyudi, M., & Widodo, S. E. (2019). Model Development of School Database Management Information System.

Appendices

The codes expected in the project

Your final project is in the nature of a (limited) research task, which is the kind of task you will be routinely required to do at your work or, in any organization for that matter.  You are always going to have to go out and dig up the knowledge, information, and/or technology you need to get your assignment done. Rarely will all of this  be available when you need it, let alone marked as an exercise with an accompanying rubric! So, I am going to ask you to do some original research:

NOTE: students usually have a little trouble in distinguishing the Query module of  Couchbase from the Analytics module.  They are not the same! The Query module is where you load your data for transactional processing (OLTP). This module is for the day to day operations such as updating your database or querying a table, quick and simple operations. If, on the other hand, you need a longer term process like computing rolling averages for the last year, it would be better to have a separate system that wouldn’t impact day to day operations, hence the Analytics module.

So data/documents are loaded into the Query module, then  copied over to the Analytics module  ( called datasets in this module) and then analyzed. So, first you create your buckets in the Query module, then load data into  these buckets and then, do a copy operation of that  data to the Analytics module for analytics analysis.

That is, from the query nodule buckets, you create what are called datasets in the Analytics module. These datasets are copies of the query data.

Think about this for a moment, doesn’t it make sense to do long running tasks “offline”? In the modern database world, this equates to having a different module to do   these “offline” tasks, that’s the Analytics module.

Overview ( details follow):

(Show screen shots of your results)

• construct a NoSQL database, using the modern data platform, Couchbase
• populate it with  JSON documents relevant to your proposal
• query ( within  the analyticsmodule ) and  retrieve data from those documents, according to the (5+) questions you wanted answered in your initial proposal.
• How to do this will be the subject of tutorials in the final weeks( this will be much easier than installing and running SQL-Server actually )!