CJCoding With Joseph
15free / daySign inCreate account
TitleTopicsAction
86
Your First TableCreate a table called `buildings` with two columns: `id`, an `INTEGER PRIMARY KE...
easy○ Not Started
CREATE TABLE
Solve
87
Fill the Blanks With DefaultsCreate `events` with four columns: `id` `INTEGER PRIMARY KEY`; `title` `TEXT NOT...
easy○ Not Started
CREATE TABLE
Solve
88
No Two Rooms Share a CodeCreate `rooms` with `id` `INTEGER PRIMARY KEY`, `code` `TEXT NOT NULL UNIQUE` an...
easy○ Not Started
CREATE TABLE
Solve
89
Prices Are Not Whole NumbersCreate `textbooks` with `id` `INTEGER PRIMARY KEY`, `title` `TEXT NOT NULL`, `pr...
easy○ Not Started
CREATE TABLE
Solve
90
Link Labs to DepartmentsCreate `labs` with `id` `INTEGER PRIMARY KEY`, `name` `TEXT NOT NULL` and `depar...
easy○ Not Started
CREATE TABLE
Solve
91
Rules the Database EnforcesCreate `clubs` with `id` `INTEGER PRIMARY KEY`; `name` `TEXT NOT NULL UNIQUE`; `...
medium○ Not Started
CREATE TABLE
Solve
92
One Membership per Student per ClubCreate `memberships` to record which students belong to which clubs: `id` `INTEG...
medium○ Not Started
CREATE TABLE
Solve
93
Permits That Vanish With the StudentCreate `parking_permits`: `id` `INTEGER PRIMARY KEY`; `student_id` `INTEGER NOT ...
medium○ Not Started
CREATE TABLE
Solve
94
Every Rule at OnceCreate `exams` with every kind of rule at once: `id` `INTEGER PRIMARY KEY`; `cou...
hard○ Not Started
CREATE TABLE
Solve
95
Clubs and MembershipsBuild two related tables in one script. `clubs`: `id` `INTEGER PRIMARY KEY`; `na...
hard○ Not Started
CREATE TABLE
Solve