1. Create the following tables by properly specifying the primary keys and the foreign keys.
COURSE –course_id, course name, duration
STUDENT – std_id, name, dob, address, phone, course_id
SUBJECT –subj_id, subj_name, faculty, course_id
2. Enter at least 3 rows for COURSE, 5 rows for STUDENT and SUBJECT relation. 10
3. Show the name of student whose name begins with letter ‘L’
4. List all the students who take BCA course
5. Show the subject name and faculty order by faculty
6. Show course name, subject name from course and subject relation.
7. Count the total number of student for each course.
Answers
Answered by
0
Explanation:
hsslgs ke GK of ai Leela up at to
Similar questions