Tag: one-to-many

SQL- Get results based on four dependable tables with relations

I am trying to write sql query for a problem I am facing, but I can not get my head around it. I have team_member table with team_id and member_id. role table that stores roles with team_id (..name, slug) team_member_role table that is a many-to-many relationship between team_member and role (contains team_me…

Displaying Multiple Rows of Data from Two Tables with a One to Many Relationship

node.js one-to-many postgresql sql

I have two tables. Tracks and metadata. Tracks can have multiple metadata attributes, but metadata can only be attached to a single track. The metadata table has a foreign key for a track ID, but the tracks table has no foreign keys for metadata. I am trying to find the best way to get this result: Essentiall…

is it violate 2NF?

database-normalization join one-to-many sql

My table book PK ID INT pfK langID INT title VARCHAR description MEDIUMTEXT releaseYear YEAR chaptersPrice DOUBLE thumbnail BLOB Where pfk – Primary-Foreign Key; {ID, langID} – PK; chaptersPrice – price of each chapter of book. Example: BookName1: chaptersPrice=2 BookName2: chaptersPrice=3 I…

Is table order imporant in mysql when creating relation between them?

database-design foreign-keys mysql one-to-many sql

I have quite simple question. I am creating database administration tool, where user will be able to create relations between tables, but I am not sure if table order is important when creating relations. For example: I have two tables ‘user'(user_id(INT, PRIMARY KEY), name(VARCHAR), email(VARCHAR)) and…

Tag: one-to-many

SQL- Get results based on four dependable tables with relations

Displaying Multiple Rows of Data from Two Tables with a One to Many Relationship

is it violate 2NF?

Is table order imporant in mysql when creating relation between them?

How to query rows depending on multiple to-many properties?

MySQL Filtering Results from a One-to-many Relationship

SQL: How to create a database view from tables with OneToMany Relationship?