IDNLearn.com: Your go-to resource for finding expert answers. Ask your questions and receive reliable and comprehensive answers from our dedicated community of professionals.

Introduction to Database: Tutorial
10 of
Name
Nancy
Date of Birth Age Blood Type
9/17/97
17 o positive
10/23/97 17 A positive
Hobby
Talent Show Registration Unique ID
drawing and painting, music Yes
A_001
reading, creative writing Yes
A_002
William
Philip
2/22/97
18
B positive
Yes
A_003
Jean
7/25/97
17
No
A_004
playing guitar
sports
George
7/29/98
16
Yes
A_005
Allan
8/16/97
17
Yes
O positive
A negative
O positive
o positive
o negative
AB positive
computer games
sports
A_006
A_007
17
No
Roger 12/11/97
Kimberly 5/12/98
16
Yes
A_008
Anne
6/10/97
17
Yes
A_009
video games
watching TV
reading fiction
listening to music
William
5/22/98
16
O positive
Yes
A_0010
Diane
3/24/97
17
A positive
Yes
A_0011
Part A
What are the field names in the database? Explain what data type is appropriate for each field.
B I y X
Х.
Font Sizes
AA
= = 三 三 三 三


Sagot :

Answer: this is the best situation

Explanation: it shows the process

Answer:

PLATO ANSWER. Sample Answer

Explanation:

The field names in the database are Name, Date of Birth, Age, Blood Type, Hobby, Talent Show Registration, and Unique ID. Here are the types of data that you can enter into each field.

Name:This field has 5 to 10 characters and accepts text data only.

Date of Birth: This field accepts dates only. It uses a medium-length entry in the form of month/day/year (mm/dd/yy).

Age: This field is numerical and contains numerical data only.

Blood Type: This field contains text data, with a maximum of 11 characters.

Hobby: This field can be a memo, and it can accept large volumes of data in any format. This data type can include null values as well.

Talent Show Registration: This is a Boolean data field that contains the values Yes or No.

Unique ID: This field accepts alphanumeric data, so this, too, is a text field.