Overview

This homework assignment is about database data types. You must be able to identify data types and properly declare data types when writing SQL statements. The proper data and format is important within database technology. It helps ensure the integrity and accuracy of our data. In Part 1 of this assignment, you will identify the data types of values entered into the SQL statements. In part 2 you will create the appropriate values for the data type assigned to the data.

Part 1: Identify the Data Type

Identify the data type of each attribute in the following query. You do not have to identify database specific data types, just use the generic data type such as String, Number, Date, or Boolean based on the data entered into the query and its format.

UPDATE student

SET fName = XXXX,

lName = XXXX,

graduation = 19/12/2009,

email = xxx@xxx.edu,

creditHours = 60,

height = 190cm,

alumni = Y

WHERE SID = 2010222222

Write the appropriate data type next to each attribute. (String, Number, Date, Boolean)

Answer

fname: _____________________

lName:_____________________

graduation: _________________

email:______________________

creditHours: ________________

height:_____________________

alumni :____________________

SID:_______________________

Part 2: Finish the Query

Finish the INSERT statement with the values provided using the appropriate format. The table below displays the values to be added to the SQL INSERT statement. The data type for each value is listed in the first row with the values appearing in the second row. Add the values to the INSERT statement in the proper format based on its data type.

	SID	SSN	fName	lName	DOB	GPA	Siblings
Data Type	String	Number	String	String	Date	Number	String
Value	202020202	404224040	John	Doe	04/01/1990	3.5	3

Answer: Provide your answer on the lines below.

INSERT INTO student (SID, SSN, fName, lName, DOB, GPA, Siblings)

Values ( );