19. Creating Employees Database Using SQL Part 2

Video Content -Creating the Projects and Workson relations and inserting data into them. Altering tables to assign foreign keys.

Click the following link to view/download the document containing the database and queries used in this video:

Watch part 1 of this video for creating the employees and departments relations of the database:

Watch the following video for a detailed explanation of the database used in this video:

Review Questions:
1. What is the syntax of the select query?
2. How can you display only certain columns of the table using the select query?
3. How can you create a primary key in a table using alter table query?
4. How can you create a foreign key in a table using the alter table query?
5. What is the meaning of parent key not found error?
6. How can the parent key not found error be resolved?
7. What error will you get if you insert a duplicate value in a primary key column?

[ShivamSharma-uxpn]

This deserves more attention, exectly what i wanted, instructions are very clear and on point. thank you mam

[priyasparks]

Hi, how can we insert a value which is ‘always no greater than 1’ in a table?

[DeepakKumar-nozl]

Hi Ma'am I dropped table and created again because I made spelling mistake in one, Please tell how to edit the column without dropping and creating the table again
Thanks for the help