What is the concept of degree and cardinality in the context of SQL?

In the context of SQL, degree and cardinality in sql for developing a database for your university, the degree refers to the number of attributes or even fields within a table.

For example, a “student” table may include the attributes such as “student I’d”, “name”, “email” “age” etc. Therefore, in this given example the degree of the “students” table is 4.

On the other hand, cardinality refers to the relationship between the tables in terms of how many instances of one entity are related to another entity.

For instance, consider a scenario where two tables are present “Students” and “Courses”:-

CREATE TABLE Students (

    Student_id INT PRIMARY KEY,

    Name VARCHAR(50),

    Email VARCHAR(100),

    Age INT

);

CREATE TABLE Courses (

    Course_id INT PRIMARY KEY,

    Course_name VARCHAR(100),

    Instructor VARCHAR(50)

);

Now, for establishing relationships:-

One-to-many relationship from “student” to “courses”

ALTER TABLE Courses

ADD COLUMN student_id INT,

ADD FOREIGN KEY (student_id) REFERENCES Students(student_id);

Many-to-many relationship

CREATE TABLE Student_Course (

    Student_id INT,

    Course_id INT,

    PRIMARY KEY (student_id, course_id),

    FOREIGN KEY (student_id) REFERENCES Students(student_id),

    FOREIGN KEY (course_id) REFERENCES Courses(course_id)

);