One-to-many relationships in GraphQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a one-to-many relationship in databases?

It is a connection where one record in a table can be linked to many records in another table. For example, one author can write many books.

beginner

How do you represent a one-to-many relationship in GraphQL?

You use a field in the 'one' type that returns a list of the 'many' type. For example, an Author type has a books field that returns a list of Book types.

intermediate

Why is a foreign key important in one-to-many relationships?

A foreign key in the 'many' table points back to the 'one' table, linking records together. It helps keep data connected and organized.

intermediate

Example: In GraphQL, how would you define an Author type with many books?

type Author { id: ID! name: String! books: [Book!]! } This means each author has a list of books.

beginner

What happens if you try to query a one-to-many field in GraphQL?

You get a list of related records. For example, querying an author's books returns all books written by that author.

In a one-to-many relationship, which side holds the foreign key?

A The 'many' side

B The 'one' side

C Both sides

D Neither side

The 'many' side holds the foreign key pointing to the 'one' side.

How do you represent multiple related items in a GraphQL type?

A As a single object

B As a list of objects

C As a scalar value

D As a string

You use a list (array) of objects to represent multiple related items.

Which GraphQL type field best shows a one-to-many relationship?

A books: [Book!]

B books: Book

C books: String

D books: ID

A list of Book objects (books: [Book!]) shows many books related to one author.

What does the exclamation mark (!) mean in GraphQL types like ID! or [Book!]?

A The field is optional

B The field is deprecated

C The field is required (non-null)

D The field is a list

The exclamation mark means the field cannot be null; it is required.

If an Author has many Books, what would a query for an author’s books return?

A A single book

B An error

C Nothing

D A list of books

The query returns a list of all books related to that author.

Explain how a one-to-many relationship works using a real-life example.

Think about how one teacher can have many students.

Describe how you would define a one-to-many relationship in a GraphQL schema.

Focus on how the 'one' type includes a list of the 'many' type.

Practice

1. In GraphQL, what does a one-to-many relationship mean?
One-to-many connects one item to many related items. Which statement is true?

easy

A. Many parents share one child.

B. Each child has multiple parents.

C. One parent has many children linked to it.

D. Parents and children are unrelated.

Solution

1. Step 1: Understand the meaning of one-to-many

   One-to-many means one item (parent) connects to many items (children).

2. Step 2: Match the description to options

   One parent has many children linked to it. correctly states one parent has many children, matching the definition.

3. Final Answer:

   One parent has many children linked to it. -> Option C

4. Quick Check:

   One-to-many = One parent, many children [OK]

Hint: Remember: one parent, many children in one-to-many [OK]

Common Mistakes:

• Confusing one-to-many with many-to-one
• Thinking children have multiple parents
• Assuming parents and children are unrelated

2. Which of the following is the correct GraphQL schema snippet to represent a one-to-many relationship between Author and Book?

easy

A. type Author { id: ID! name: String! books: [Book!]! } type Book { id: ID! title: String! authorId: ID! }

B. type Author { id: ID! name: String! book: Book } type Book { id: ID! title: String! author: Author }

C. type Author { id: ID! name: String! books: Book } type Book { id: ID! title: String! authorId: ID! }

D. type Author { id: ID! name: String! books: Book! } type Book { id: ID! title: String! authorId: ID! }

Solution

1. Step 1: Identify list type for many children

   In GraphQL, a one-to-many uses a list type like [Book!]! for multiple books.

2. Step 2: Check each option's books field

   type Author { id: ID! name: String! books: [Book!]! } type Book { id: ID! title: String! authorId: ID! } uses books: [Book!]! correctly; others use single Book or wrong types.

3. Final Answer:

   type Author { id: ID! name: String! books: [Book!]! } type Book { id: ID! title: String! authorId: ID! } -> Option A

4. Quick Check:

   List type for many children = [Type!]! [OK]

Hint: Use square brackets [] for lists in GraphQL schema [OK]

Common Mistakes:

• Using single type instead of list for many children
• Missing non-null ! on list or items
• Confusing field names or types

3. Given this GraphQL query and schema, what will be the output?

type Author { id: ID! name: String! books: [Book!]! } type Book { id: ID! title: String! authorId: ID! }

Query:

{ author(id: "1") { name books { title } } }

Assuming author 1 has two books titled "Book A" and "Book B".

medium

A. {"author":null}

B. {"author":{"name":"Author One","books":{"title":"Book A"}}}

C. {"author":{"name":"Author One","books":null}}

D. {"author":{"name":"Author One","books":[{"title":"Book A"},{"title":"Book B"}]}}

Solution

1. Step 1: Understand the schema and query

   The author has a list of books; query requests author name and all book titles.

2. Step 2: Match expected output

   Author 1 has two books, so books field returns a list with two titles.

3. Final Answer:

   JSON with author name and books list of two titles -> Option D

4. Quick Check:

   One author, many books = list output [OK]

Hint: Lists in schema return arrays in query results [OK]

Common Mistakes:

• Expecting single object instead of list for books
• Assuming books field is null if empty
• Confusing null author with empty books

4. This GraphQL schema snippet has an error for one-to-many relationship. What is wrong?

type User { id: ID! name: String! posts: Post } type Post { id: ID! content: String! userId: ID! }

medium

A. The posts field should be a list type [Post!]! instead of Post.

B. The userId field should be removed from Post.

C. The name field in User should be optional.

D. The id fields should be of type String, not ID.

Solution

1. Step 1: Check the posts field type for one-to-many

   One user can have many posts, so posts must be a list, not a single Post.

2. Step 2: Verify other fields

   userId in Post is correct to link back; name optionality and id type are unrelated.

3. Final Answer:

   posts field must be a list [Post!]! -> Option A

4. Quick Check:

   One-to-many needs list type for many children [OK]

Hint: Use brackets [] for multiple related items in schema [OK]

Common Mistakes:

• Using single object instead of list for many children
• Removing foreign key fields mistakenly
• Changing unrelated field types

5. You want to design a GraphQL schema for a blog where each Category has many Posts, and each Post belongs to one Category. Which schema design correctly models this one-to-many relationship and allows querying all posts in a category?

hard

A. type Category { id: ID! name: String! post: Post } type Post { id: ID! title: String! category: Category } Query { posts: [Post!]! }

B. type Category { id: ID! name: String! posts: [Post!]! } type Post { id: ID! title: String! categoryId: ID! } Query { category(id: ID!): Category }

C. type Category { id: ID! name: String! posts: Post } type Post { id: ID! title: String! categoryId: ID! } Query { category(id: ID!): Category }

D. type Category { id: ID! name: String! posts: [Post] } type Post { id: ID! title: String! category: Category! } Query { category(id: ID!): Category }

Solution

1. Step 1: Model one-to-many with list in Category

   Category should have posts as a list [Post!]! to represent many posts.

2. Step 2: Use categoryId in Post to link back

   Post has categoryId to link to its single category, enabling queries from both sides.

3. Step 3: Check Query type for fetching category

   Query allows fetching category by id, then posts can be queried from category.

4. Final Answer:

   type Category { id: ID! name: String! posts: [Post!]! } type Post { id: ID! title: String! categoryId: ID! } Query { category(id: ID!): Category } -> Option B

5. Quick Check:

   List in parent + foreign key in child = one-to-many [OK]

Hint: Parent has list, child has foreign key ID for one-to-many [OK]

Common Mistakes:

• Using single Post instead of list in Category
• Missing foreign key in Post
• Incorrect Query type for fetching data