See the table below. Currently the audio-visual support department at a large university keeps track of its equipment and its servicing of that equipment using an excel document such as the one below. Individual devices can be identified by their serial numbers. Each row of this table captures the service of a device by some technician. The audio-visual support department keeps track of the quantity of each device type that it has under management. The budget code of a university department uniquely identifies the department.

SerialNumber	123445	123445	456112
PurchaseDate	4/1/2011	4/1/2011	11/1/2012
PurchasePrice	$3,200	$3,200	$1,750
BrandName	Sony	Sony	Sony
ModelNumber	PJ100	PJ100	PJ100
ProductDescription	4K Projector	4K Projector	4K Projector
QuantityUnderManagement	13	13	13
BuildingCode	298	298	301
BuildingAddress	115 W Grace	115 W Grace	315 W Main St
BuildingName	Harris Hall	Harris Hall	Queally Hall
RoomNumber	134	134	401
RoomType	Classroom	Classroom	Board Room
DepartmentName	Mathematics	Mathematics	Business
BudgetCode	1001	1001	2100
DateOfInstallation	5/13/2011	5/13/2011	5/1/2012
TechnicianID	2375	2456	2375
TechnicianName	Emily Mann	Jon Pinsky	Emily Mann
ServiceTicketID	2002	1301	5401
ServiceDate	4/15/2014	2/1/2015	12/13/2016
ServiceNotes	Changed Lamp	Changed Power Supply	I changed the defective lamp

1. Is the table above a relation? If not, what would need to be done for it to become a relation?

2. Create a complete dependency diagram for the data below (note that you must show the primary key to be able to do this)

3. If the table is not in 3^rd normal form, normalize it to 3^rd normal form by showing a series of relations in 3^rd normal form. Show all referential integrity constrains; all relations must have names.