Using the AP database, complete the following queries:

Update the Terms Description for the Terms ID of $1$ to say "DUE IN $8$ DAYS!" $($do not include the

quotations$).$

Update all Vendors in California or New Jersey to have a default terms ID of $3.$

Delete all of the invoice line items whose line item amount is less than $$12$

Insert a Vendor $($with whatever data you want, as long as it works$)$ into the vendors table.

Insert the following invoice into the database

VendorID $-6$

InvoiceNumber $-$ AJ$562$GQ$4$M

InvoiceDate $-$ Todays Date $($use a function or literal string$)$

InvoiceTotal $-50$

PaymentTotal $-10$

CreditTotal $-0$

TermsID $-1$

InvoiceDueDate $-$ June $30,2013$

PaymentDate $-$ NULL

Create a Students table with the following columns $($Use appropriate data types$)$

SID $($Make this a primary key column$)$

FirstName

LastName

Age

State $($Which will be stored as a two letter abbreviation$)$

DOB $($date of birth$)$

Email $($make this unique$)$

IsGraduated $($this would be true or false$)$

Answer the following questions with thorough explanations:

Why is it important to normalize a database?

Is a higher level of normalization always better?

Are the built in functions in SQL Server important to know? Why or why not.