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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!