After modifying your erwin erd, modify your sql server database (erwin forward engineer) to includethe functionality described in deliverable 1. be sure to name your improved database using this syntax: lastname-f-p4. be sure to include both the data file (mdf) and the lock file (ldf).once you have modified your database, you must then populate it with data using your insert intostatements; however, you will need to modify your insert into statements for your product entitysince it no longer has the unitprice attribute. after populating all of the other tables in your improved database, you will then need to populate theprice_history entity by using insert into statements. use the previous unit price value with price valid from 1/1/2017 until 3/31/2017.then from 4/1/2017 until 5/20/2017, increase each unit price by 4% from the previous price. then from 5/21/2017 until 5/29/2017, increase each unit price by 5% from the previous price. then from 5/30/2017 until 7/07/2017 decrease each unit price by 10% from the previous price. then from 7/08/2017 until 11/25/2017, increase each unit price by 10% from the previous price. then from 11/26/2017 until 12/31/2018, increase each unit price by 4% from the previous price. populate your tables with the correct data. here are a list of the entities and attributes for the statementscustomer_tcustomerid (pk)

What are ways to switch windows in excel? check all that apply. on the status bar, click the windows button, and then click the file name. on the task bar, click to display the excel jump list, and then click the file name. on the view tab, in the window group, click switch windows, and then click the file name. on the review tab, in the viewing group, click files, and then click the file name.

This question involves a class named textfile that represents a text file. public class textfile { private string filename; private string filename; private arraylist words; // constructors not shown // postcondition: returns the number of bytes in this file public int filesize() { } // precondition: 0 < = index < words.size() // postcondition: removes numwords words from the words arraylist beginning at // index. public void deletewords(int index, int numwords) { } // precondition: 0 < = index < = words.size() // postcondition: adds elements from newwords array to words arraylist beginning // at index. pub lic voidaddwords(int index, string[] newwords) { } // other methods not shown } complete the filesize() method. the filesize() is computed in bytes. in a text file, each character in each word counts as one byte. in addition, there is a space in between each word in the words arraylist, and each of those spaces also counts as one byte. for example, suppose the words arraylist stores the following words: { mary had a little lamb; its fleece was white as snow. } the filesize() method would compute 4 + 3 + 1 + 6 + 5 + 4 + 6 + 3 + 5 + 2 + 5 as the sum of the lengths of each string in the arraylist. the value returned would be this sum plus 10, because there would also be 10 spaces in between the 11 words. complete the filesize() method below: // postcondition: returns the number of bytes in this file public int filesize() { }

Retype the statements, correcting the syntax errors. system.out.println("num: " + songnum); system.out.println(int songnum); system.out.println(songnum " songs"); note: these activities may test code with different test values. this activity will perform two tests: the first with songnum = 5, the second with songnum = 9. see how to use zybooks.