What is a data type? List the data types commonly found in a database.

Question

What will be an ideal response?

Answer 1

Student responses will vary, but should be drawn from the following information from the text.?The data type specifies the kind of data a field can contain and how the field is used. Common data types include:• Text: Letters, numeric characters, or special characters• Number (also called numeric values): Positive or negative numbers, and the number zero, with or without decimal points• AutoNumber: Unique number automatically assigned by the DBMS to each added record, which provides a value that identifies the record (such as a student ID)• Currency: Dollar and cent amounts or numbers containing decimal values• Date (also called date/time): Month, day, year, and sometimes time• Memo (also called long text): Lengthy text entries, which may or may not include separate paragraphs• Yes/No (also called Boolean): Only the values Yes or No (or True or False)• Hyperlink: Email address or web address that links to a webpage on the Internet or document on a network• Object (also called BLOB, for binary large object): Photo, audio, video, or a document created in other programs or apps, such as word processing or spreadsheet, stored as a sequence of bytes in the database• Attachment: Document or image that is attached to the field, which can be opened in the program that created the document or image (functions similarly to email attachments)