Problem 1 Create a table wordlist id: number, and primary key entry: string. max length 50 definition: string. max length 200 Problem 2 Create a sequence seq id. it starts with 1000, and increments by 1. Problem 3 Execute the query script InsertWords.sql. When the InsertWord.sql is completed, execute “SELECT count(*) from worldlist”. It should return 109609. If ”InsertWords.sql” fails, check your table description. If your table and sequence are created correctly, “InsertWords.sql” should work. Dont forget to execute commit. Problem 4 What is the word with maximum length? Write the SQL statement to find that word. Problem 5 List 15 longest words and their lengths. Write the SQL statement. answer: ...... 23 disestablismentarianism 23 electroencephalographic 22 counterclassifications 5 ........ Problem 6 Count the words that start with letter “s”. Write the SQL statement. Problem 7 Count the words that start with letter “a” or letter ”b”. Write the SQL statement. Problem 8 List all words that contain “decima”. Write the SQL statement Problem 9 List all words that contain “epp” and length is smaller than 8. For example: “pepper” Page 2 of 4 Anwar Mamat CMP 556 (Anwar 11:59pm): Assignment #1 Problem 9 Problem 10 What is the average length of all words that start with the letter t? Write the SQL statement. Problem 11 For each letter in alphabet, count the words that start with that letter. Write SQL statement example: letter count ..... a some number b some number 5 ....... s 12108 ...... Problem 12 Count the number of words, in which “w” is the 5th letter. For example: “homework” Problem 13 Fill in the definition for the word “universal”. Write the SQL Statement. Problem 14 Which letter has the minimum number of words that end with that letter? Write the SQL statement. For example,if we have words abc, bbc, and bbd, then d has minimum number of words that end with d. Problem 15 Write a SQL statement to check if the wordlist table has duplicated entries. Problem 16 Write a SQL statement to compute the average length of all words that ends with “e”. Problem 17 Write a SQL statement to delete all duplicated words. For each duplicated word, keep the first word, and delete duplicated. For example, there are 3 copies of “experimental”. Delete 2, keep 1 and so on. Problem 18 Write a SQL statement to list words from 10th to 15th from the sorted list where the words are sorted by their length. Page 3 of 4 Anwar Mamat CMP 556 (Anwar 11:59pm): Assignment #1 Problem 18 What will you learn from this assignment Creating tables, sequences, SQL

Read less