DAT 604 Final Project
Creating the database
Use any DBMS to build the actual database using the following data.
Data Link: https://goo.gl/ckRu7h
Insert your SQL code for creation of database in the following box.
Your SQL code for creating the database |
-- Copy and paste your code here
|
Queries
Query 1
List the names and last names of professors with PhD Degree.
Your SQL code for this query |
-- Copy and paste your SQL query here
|
Run the query and insert the result in the following box.
The result of the query |
Copy and paste the result here (e.g. the screen shot of the result you get by running the query).
|
Query 2
List the names and last names of professors with PhD Degree in Electrical Engineering.
Your SQL code for this query |
-- Copy and paste your SQL query here
|
Run the query and insert the result in the following box.
The result of the query |
Copy and paste the result here (e.g. the screen shot of the result you get by running the query).
|
Query 3
List the titles and course units of the courses that are taught by professors with PhD Degree.
Your SQL code for this query |
-- Copy and paste your SQL query here
|
Run the query and insert the result in the following box.
The result of the query |
Copy and paste the result here (e.g. the screen shot of the result you get by running the query).
|
Query 4
List the names and last names of students who are taking one (or more) course in Mathematics department.
Your SQL code for this query |
10 years ago
Purchase the answer to view it
dat604_-_final_project_-_id_-_your_last_name_-_your_first_name.zip
