● Create a python file called database_manip.py. Write the code to do the following tasks: ○ Create a table called python_programming. ○ Insert the following new rows into the python_programming table: id name grade 55 Carl Davis 61 66 Dennis Fredrickson 88 77 Jane Richards 78 12 Peyton Sawyer 45 2 Lucas Brooke 99 ○ Select all records with a grade between 60 and 80. ○ Change Carl Davis’s grade to 65. ○ Delete Dennis Fredrickson’s row. ○ Change the grade of all people with an id below than 55.

a. Normalize the Bank Accounts Table to 1NF by increasing the records in the existing table. b. Normalize the Bank Accounts Table to 1NF by creating a new separate table in addition to the existing table.

Task B.  Import the data shown in pictures into the two tables created.

table not copied

Hive table’s column, PERSON has an array value, [“jihee”, “jong”,“hemo”]. What function generate three records from the array value,[“jihee”, “jong”, “hemo”]?a. RECORDS(PERSON)b. EXPLODE(PERSON)c. LINES(PERSON)d. ROWS(PERSON)

Task 8: Create the DEL_OWNER procedure to delete the owner whose number is stored in I_OWNER_NUM (provided as a parameter).

Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int   RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1)   Write SQL code to:  1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2.  How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?

What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? ( refer to the tables in the JustLee Books database).                                                              a. 0 b. 1 c. 30 d. 255

Population Database   Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population.   CreateCityDB.java import java.sql.*; /**  This program creates the CityDB…

Insert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total).  Subject   subjectNumber Name gradeLevel 62 Algebra 9 33 Biology 10 83 Legal Studies 11 35 Entomology 9 70 Norse Mythology 10 23 Geography 10 67 Literature 12 78 World History 11 13 US History 12 9 Astronomy 9 53 Self Defense 12 85 Introduction to Computer Science 11 43 Algebra II 10