From the course: Database Foundations: Data Structures

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Challenge: Choosing data types

Challenge: Choosing data types

From the course: Database Foundations: Data Structures

Start my 1-month free trial

Challenge: Choosing data types

“

(upbeat music) - [Instructor] We've covered a lot of information about the different options that you have when choosing the type of data that your tables will hold. Let's put what we've learned into practice with the first challenge for the course. I'd like you to create a table in the Two Trees database to hold information about the company's employees. You'll need separate columns to store the following information, the employees first and last names, phone number, the cubicle or office number that they're assigned to, their hire date, and their annual salary. Your goal is to think through the kinds of information that needs to be stored and choose an appropriate data type for each column. Once you've created the table, insert a new row for the first employee. The specific values that you use isn't important as long as they represent the kinds of data that you're likely to come across in the real world. Verify that each…

Contents