Computer Science, asked by guhestui, 4 days ago

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 shardasingh6
0

Explanation:

hsslgs ke GK of ai Leela up at to

Similar questions