18. Creating Employees Database using SQL Part 1
Video Content -Creating the Employees and Departments relations and inserting data into them.
Click the following link to view/download the document containing the database and queries used in this video:
https://drive.google.com/file/d/1smDN...
Watch part 2 of this video for the rest of the database and foreign keys:
• 19. Creating Employees Database Using...
Watch the following video for a detailed explanation of the database used in this video:
• 8. ER Diagram for an Employees Database
Review questions:
Write SQL queries for the following questions:
1. Create a table to store details of instructors with a primary key.
2. Create a table to store details of subjects with a primary key.
3. Create a table teaches which can connect an instructor ID with the ID of the subject they teach.
4. Describe the schema of the instructor relation.
5. Describe the schema of the subjects relation.
6. Describe the schema of the teaches relation.
7. Insert at least 3 rows in each of the tables created above.
На этой странице сайта вы можете посмотреть видео онлайн 18. Creating Employees Database using SQL Part 1 длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Coding Christi -Python, Java, SQL 21 Июль 2020, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 32,703 раз и оно понравилось 369 зрителям. Приятного просмотра!
