From the course: Database Foundations: Data Structures

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Solution: Link tables with keys

Solution: Link tables with keys

From the course: Database Foundations: Data Structures

Start my 1-month free trial Buy for my team

Solution: Link tables with keys

“

(upbeat music) - [Narrator] I hope you were able to add in the employee bonus table to the two trees database to expand on information that was stored in the employees table. Let's walk through the different steps in order to accomplish that goal. I'm going to right click on the two trees database in my SQL Server instance since that's the database server that I was working on earlier to create the employees table. So I right click there and just choose new query. And the first thing I want to do is just take a look at my employees table. So I'll just select everything from employees, and I'll just run that. So this is the starting point, you're going to have different data in your table, but I have two rows, one for myself and then one for a person named Judith Leonard. And we have the employee IDs that we added in, in the last challenge over here on the far right. Now I want to make sure that I know the data…

Contents