Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Challenge: Changing the Books Structure | Populating a Database
Introduction to SQL

bookChallenge: Changing the Books Structure

Your manager has decided that the books_table table should have an auto-incrementing book_id to uniquely identify each book. Additionally, the book_id will be set as the primary key for the table.

Task

Swipe to start coding

You are tasked with recreating the books_table table with the following columns:

  • book_id - The unique id of the book (SERIAL), PRIMARY KEY;
  • title - The title of the book (VARCHAR, max-length 255), NOT NULL;
  • author - The author of the book (VARCHAR, max-length 100);
  • genre - The genre/category of the book (VARCHAR, max-length 50);
  • published_year - The year the book was published (INTEGER);
  • isbn - The International Standard Book Number (VARCHAR, max-length 20);
  • publisher - The publisher of the book (VARCHAR of max-length 100);
  • pages - The number of pages in the book (INTEGER);
  • language - The language of the book (VARCHAR of max-length 50);
  • is_available - Whether the book is available for lending (BOOLEAN);

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 4. ChapterΒ 10
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Summarize this chapter

Explain the code in file

Explain why file doesn't solve the task

close

Awesome!

Completion rate improved to 1.72

bookChallenge: Changing the Books Structure

Swipe to show menu

Your manager has decided that the books_table table should have an auto-incrementing book_id to uniquely identify each book. Additionally, the book_id will be set as the primary key for the table.

Task

Swipe to start coding

You are tasked with recreating the books_table table with the following columns:

  • book_id - The unique id of the book (SERIAL), PRIMARY KEY;
  • title - The title of the book (VARCHAR, max-length 255), NOT NULL;
  • author - The author of the book (VARCHAR, max-length 100);
  • genre - The genre/category of the book (VARCHAR, max-length 50);
  • published_year - The year the book was published (INTEGER);
  • isbn - The International Standard Book Number (VARCHAR, max-length 20);
  • publisher - The publisher of the book (VARCHAR of max-length 100);
  • pages - The number of pages in the book (INTEGER);
  • language - The language of the book (VARCHAR of max-length 50);
  • is_available - Whether the book is available for lending (BOOLEAN);

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

close

Awesome!

Completion rate improved to 1.72
SectionΒ 4. ChapterΒ 10
single

single

some-alt