Question

Tina has made a database table in Access containing fields_name, Class, Roll_No. and Contact_no. She has set the primary key for the field ‘Student_name’. Has she done the right thing by setting the primary key for this field? Give reason.

Answer 1

Answer:

its simple

the answer is that student_name can not be the primary key because it is always possible that other students with the same name may join.

Explanation:

mark me as brainliest!

Answer 2

Answer:

Yes. Because by entering the student name you will proceed to the next information.in fields name we write the name and then we add the other information of that name entered. student_name can not be the primary key because it is always possible that other students with the same name may join.

Explanation:

• If you are moving existing data into a database, you may already have a field that you can use as the primary key. Often, a unique identification number, such as an ID number or a serial number or code, serves as a primary key in a table. For example, you might have a Customers table where each customer has a unique customer ID number. The customer ID field is the primary key.
• Access automatically creates an index for the primary key, which helps speed up queries and other operations. Access also ensures that every record has a value in the primary key field, and that it is always unique.
• When you create a new table in Datasheet view, Access automatically creates a primary key for you and assigns it a field name of "ID" and the AutoNumber data type.