MYSQL Relationship between Courses Table with multiple Subcategories from same Category

Question

Home

MYSQL Relationship between Courses Table with multiple Subcategories from same Category

0

mysql
php

I’m engineering a MySql database structure for the new version of my website. I need to create a relation between Courses that can have mutiple subcategories but selected only from the same category. I’ve set the relation as you can see in the photo by setting the category foreign key inside course table and linking courses with subcateogries in the middle table and I’m planning to use php to force the user in selecting subcategories only from the same category.

Is there a better and more efficient way to structure the database?

I hope I’ve been clear and thanks for the answers.

Database EER Diagram:

Tadkathrinefrancesca Asked on July 16, 2020 in Mysql.

Share
Comment(0)

Add Comment

0 Answer(s)

Votes
Oldest

Your Answer

Answer 1

BuddyPress is a plugin for WordPress that enables you to create a social network or community website. It has all the...

Answer 2

I value you getting some margin to help me with this task. Without you, no part of this would have...

Answer 3

Try to define a Cohesive class, until and unless the methods are written relevant to the class and it defines...

Answer 4

Try to add exportAllData: true, as an other option, hope it helps :)

Answer 5

DataSet can read an XML, infer schema and create a tabular representation that's easy to manipulate: DataSet ip1 = new...

Answer 6

I created a class and used Xml Linq : using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml; using...

Answer 7

XDocument first = XDocument.Load(args[0]); XDocument second = XDocument.Load(args[1]); var result = new XElement( "ipaddresses", first.Root.Elements("ip") .Zip(second.Root.Elements("ip"), (f, s) => {...

Answer 8

Following your code for the header row, you could achieve this by an <xsl:apply-templates select="/report/order_actions/order_action[order_id = current()/order_id]" /> As well...

Answer 9

BuddyPress is a plugin for WordPress that enables you to create a social network or community website. It has all the...

Answer 10

I value you getting some margin to help me with this task. Without you, no part of this would have...

Answer 11

Try to define a Cohesive class, until and unless the methods are written relevant to the class and it defines...

Answer 12

Try to add exportAllData: true, as an other option, hope it helps :)

Answer 13

DataSet can read an XML, infer schema and create a tabular representation that's easy to manipulate: DataSet ip1 = new...

Answer 14

I created a class and used Xml Linq : using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml; using...

Answer 15

XDocument first = XDocument.Load(args[0]); XDocument second = XDocument.Load(args[1]); var result = new XElement( "ipaddresses", first.Root.Elements("ip") .Zip(second.Root.Elements("ip"), (f, s) => {...

Answer 16

Following your code for the header row, you could achieve this by an <xsl:apply-templates select="/report/order_actions/order_action[order_id = current()/order_id]" /> As well...

LATEST ANSWERS

MYSQL Relationship between Courses Table with multiple Subcategories from same Category

Your Answer

TOP USERS

HOT QUESTIONS

LATEST ANSWERS

MYSQL Relationship between Courses Table with multiple Subcategories from same Category

Your Answer

Tags Widget

TOP USERS

HOT QUESTIONS