mysql to mongodb database and query conversion

Course Queries Syllabus Queries 3 years ago

1.1K 2 0 0 0

User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 3 years ago

The following structure as defined in MySQL db

  1. I have a one table for degree
    contain two columns : degree_id ,degree_name
    2.Another Table for branch
    branch_id,branch_name,degree_id
    3.Subject table
    subject_id,subject_name,subject_code,degree_id,semester
    4.syllabus
syllabus_id,syllabus_name,sort_note,attachment,semester,degree_id,branch_id,subject_id

Now i can easily fetch the syllabus of particuler degree,branch,semester using mysql but i am new in mongo db please help

0 views
0 shares

profilepic.png
manpreet 3 years ago

 

In MongoDb you have to take the concept more general and include all the relation in it.

Your database Mysql, looks like this on mongodb:

     degree{
            _id : ...,
            name : ...,
            branches :[ {
                         _id: ...
                         name: ....,
                         syllabus : [ {
                                       _id: ...,
                                       name: ....,
                                       sort_note: ....
                                       attachment:...
                                       semetster,... 
                                      } , ..   ],...{
                       } ],
             subjects: [ {
                          _id: ..,
                          name: ....,
                          code: .....,
                          semester: ....
                       }, ...]
             }

If id_branch and id_degree are uniques like a contraint is an object else is an array.

Regards


0 views   0 shares

No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

Similar Forum