From the course: Database Foundations: Data Structures

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Solution: Store data in a table

Solution: Store data in a table

From the course: Database Foundations: Data Structures

Start my 1-month free trial Buy for my team

Solution: Store data in a table

“

(upbeat music) - [Instructor] For this challenge, we need to create a table to store information about the shows that local bands are putting on in local venues around the city. We were given a table with some column names, but it was left to us to determine the correct data types for each one depending on the data that each one needs to store. So we can get started here by typing in our CREATE TABLE statement. And the name of the table that we were told to create is called EventSchedule. And I'll just open up a parentheses, and I'll move the closing parentheses down just a couple of lines to get it out of the way. And I might as well also type in the finishing semicolon here at the end, just so I don't forget. Okay, we'll come back up to line number four, and we'll start typing in the individual columns that we were asked to put in. So the first one was named EventID. And for this we're told that it needs to store a whole number, so that means an integer is probably the best choice…

Contents