Question

Question No. 6
a. A database table “Student_Info” has fields as: Student ID, Name, Enrollment, Department and Current Status. Which of these fields can be set as Primary Key(s)? Define your reason.
b. Almost every business needs to maintain a database for storing and manipulating necessary data, mention at least eight strong reasons why it is necessary to maintain?

Answer 1

Answer:

a. student id or enroll. will be the primary key.

Explanation:

as in a table student_info there can be multiple students with same name, many students can have same dept. or current status but Student ID or students enroll. no can be uniquely identified in table.