Is it possible to make more than one field as a primary key in your table?(Yes/No)

Yes, it is possible to have more than one field as a primary key in a table. This is known as a composite primary key. A composite primary key is formed by combining two or more columns in a database table to create a unique identifier for each record. This approach is beneficial when a single column is not sufficient to ensure the uniqueness of each record.

For example, in a table that stores information about students and their courses, neither the student ID nor the course ID alone may be unique. However, the combination of both fields (student ID and course ID) can serve as a composite primary key to uniquely identify each enrollment entry for students in various courses.

It's important to note that all fields in a primary key, including composite keys, must contain unique values and cannot contain NULLs, ensuring the integrity of the data.