Create tables for the following, where the first 2 are entity-types and the last one is relationship. Feel free to add additional fields that you think are appropriate. Course: courseNum, department, semester, maximumEnrolled Instructor: ssn, instructorid, firstName, lastName. Teaches: instructorid, courseNum Pay special attention to assigning primary key and foreign key in each table and use appropriate data types. Print out the SQL commands that you use to create the tables. Then populate your tables with at least 2 rows each and print out the contents of each table with SELECT. (Include the content of the print-out in your homework). I want answers for this part Get to know the HR database, its tables, and their contents. Show the SQL query and the output. Use INNER JOIN for multiple table query. 1- Display details of jobs where the minimum salary is greater than 10000. 2- Display the first name and join date of the employees who joined between 2002 and 2005. 3- Display first name and join date of the employees who is either IT Programmer or Sales Man. 4- Display details of employee with ID 150 or 160
Create tables for the following, where the first 2 are entity-types and the last one is relationship. Feel free to add additional fields that you think are appropriate.
Course: courseNum, department, semester, maximumEnrolled Instructor: ssn, instructorid, firstName, lastName.
Teaches: instructorid, courseNum
Pay special attention to assigning primary key and foreign key in each table and use appropriate data types.
Print out the SQL commands that you use to create the tables.
Then populate your tables with at least 2 rows each and print out the contents of each table with SELECT. (Include the content of the print-out in your homework).
I want answers for this part
Get to know the HR
Use INNER JOIN for multiple table query.
1- Display details of jobs where the minimum salary is greater than 10000.
2- Display the first name and join date of the employees who joined between 2002 and
2005.
3- Display first name and join date of the employees who is either IT Programmer or Sales
Man.
4- Display details of employee with ID 150 or 160
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
