DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Firstname
|
|
|
Age
|
|
|
Address
|
|
|
ID number
|
Detailed explanation-1: -An AutoNumber field makes a good primary key.
Detailed explanation-2: -A primary key is either an existing table column or a column that is specifically generated by the database according to a defined sequence.
Detailed explanation-3: -A primary key, also called a primary keyword, is a column in a relational database table that’s distinctive for each record. It’s a unique identifier, such as a driver’s license number, telephone number with area code or vehicle identification number (VIN). A relational database must have only one primary key.
Detailed explanation-4: -1 Answer. field Roll Number is suitable for the primary key.
Detailed explanation-5: -In the Navigation Pane, right click a table, and select Design View. Select the field or fields you want to use as the primary key. Select Design > Primary Key.