Scribd
Upload
14 views2 pages

SQL

The document shows the SQL commands to create three database tables: Students, Courses, and Student_Courses. The Student_Courses table establishes a many-to-many relationship between Students and Courses using composite primary keys.

Uploaded by

Subhajit Kundu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
14 views2 pages

SQL

The document shows the SQL commands to create three database tables: Students, Courses, and Student_Courses. The Student_Courses table establishes a many-to-many relationship between Students and Courses using composite primary keys.

Uploaded by

Subhajit Kundu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

1.

sql:

CREATE TABLE Students (


student_id INT PRIMARY KEY,
name VARCHAR(50),
age INT,
gender VARCHAR(10),
address VARCHAR(100)
);

2:
CREATE TABLE Courses (
course_id INT PRIMARY KEY,
course_name VARCHAR(50),
instructor VARCHAR(50),
credit_hours INT,
department VARCHAR(50)
);

3.
CREATE TABLE Student_Courses (
student_id INT,
course_id INT,
FOREIGN KEY (student_id) REFERENCES Students(student_id),
FOREIGN KEY (course_id) REFERENCES Courses(course_id),
PRIMARY KEY (student_id, course_id)
);

*** In this table, student_id and course_id together form the composite primary
key, representing the enrollment of students in courses. Each entry in this table
signifies a student-course relationship.
The student_id field references the student_id field in the Students table,
establishing a many-to-one relationship from Student_Courses to Students.
The course_id field references the course_id field in the Courses table,
establishing a many-to-one relationship from Student_Courses to Courses.

This setup ensures that each student can be associated with multiple courses (one-
to-many relationship), and each course can have multiple students enrolled in it.
The Student_Courses table serves as the bridge table to represent this
relationship.****

To address your exercise, let's break down each part and provide SQL queries to
accomplish them:

a. Find out the names of all clients:

sql

SELECT Name
FROM Client_Master;

b. Retrieve the entire contents of the client_master table:

sql
SELECT *
FROM Client_Master;

c. Retrieve the list of names, city, and the state of all the clients:

sql

SELECT Name, City, State


FROM Client_Master;

d. Destroy the table client_master along with its data:

sql

DROP TABLE Client_Master;

Please note that executing the DROP TABLE command will permanently delete the
Client_Master table along with all its data. Make sure to use it cautiously, as
data loss cannot be undone.

You might also like