Question: 2. Data creation Create some appropriate data for the database (at least 6 tuples for cach table) and insert this data in your implementation. Choose

2. Data creation Create some appropriate data for the database (at least 6 tuples for cach table) and insert this data in your implementation. Choose you data properly so that the following queries return at least a relation with one tuple student-name se-numb title year 3. SQL Queries Design and implement MySQL statement for the following queries: 1. List all the students 2. List all the courses . List all the lecturers 4. What students take course CS04? 5. Which lecturer leaches course CS04? 6. What courses does Dr. Dodd teach? 7. Are there any students not enrolled in any course and who are they? 8. Are thcre any courses with no students enrolled and what are thcy? 9. Delete a tuple from table student, check the results. 10. Update the value of course number in table course, check the results. student enrols course lecturer teaches 4. What to submit? Subit te list of SOL-queries, query-outpur, and the list of tuples of all relations in the database room-number lecturer-name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
