considered the above table:-
i. Can ITEM NO. be taken as a primary key. Explain your reason.
ii. What is data type of the field -- ITEM NO. and PURCHASE DATE.
iii. Write the steps to add a new record/row in this table?
please help me fast it is urgent!
I'll report the spam answer and Mark BRAINLIEST to the correct answer
Answers
Answer:
1) A primary key is a column -- or a group of columns -- in a table that uniquely identifies the rows in that table. For example, in the table below, CustomerNo, which displays the ID number assigned to different customers, is the primary key. CUSTOMERS. CustomerNo. FirstName.
2)Think of a field's data type as a set of qualities that applies to all the values that are contained in the field. For example, values that are stored in a Text field can contain only letters, numbers, and a limited set of punctuation characters, and a Text field can only contain a maximum of 255 characters.
3) Click the “New Record” button at the right end of the record navigation button group. It is located in the lower left corner of the datasheet view. It is the button with the arrow and asterisk [►*] on its face. Then enter the information into the fields in the “New Record” row.
Explanation:
hope this helps to you ☺️☺️