Bio activity done

DTSC670: Foundations of Machine Learning Models Module 1 Assignment 2: COVID-19 Data Wrangling Name: The purpose of this assignment is to hone your data wrangling skills. Your task for this assignment is to perform the data preparation as instructed in the DTSC670_Assignment_2 pdf listed in Brightspace. After performing all the data preparation tasks outlined in the document, run the code in the "Prepare DataFrames for Grading" section. You are supplied an Excel file called BrazilcOVIDData.xlsx - be sure to put the data file in the same directory as this Jupyter Notebook. Please note that it may take around 5 minutes to read-in all of the data in this file. In [ ]: N ### ENTER CODE HERE ### # Insert as many cells as you need, but be sure your code is very neat and very well documented. In [ ]: N # Get Final Features DataFrame # features = ### ENTER CODE HERE ### # Get Final Response DataFrame # response = ### ENTER CODE HERE ###

Apply the INGRES algorithm (the detachment technique) to the following query: Select std_name,std_dpt FROM std_info,std_absence WHERE std_info.std_id%3Dstd_absence.std_id AND std_absence.abs_hrs > 1 AND std_absence.date = '2020-12-06'; std_info I std_id ! std_name ! std_dpt I std_avg ! 1 1 Ahmed 2 I Ali ! Information ! I Networks 75 1 80 : std_absence | std_id : std_name : date I abs_hrs I 1 ! Ahmed 2 I Ali 1 1 Ahmed | 2020-12-06 1 | 2020-12-06 I 2020-12-08 I

C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.

Perform first normalization based on the table information given.

The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.

6. What attribute is used with the element? (A) multiple (B) selected C name D) value

Not to be same as copy contnt

Write the Boolean expression for this truth table output using K-Map. See attachment below of example of it

POSTGRESQL For this problem create a table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor and adds a tuple to the instructor_course_nums table consisting of the instructor's ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the instructor_course_nums table is up-to-date. You must name your procedure: <LastName>_<DOB_DayOfMonth>_insCourseNumsProcWhere <LastName> is your last name and <DOB_DayOfMonth> is the day of the month you were born. Below is an example of how I named my procedure: Morab_05__insCourseNumsProc

MySQL CREATE TABLE students (  id INT PRIMARY KEY,  first_name VARCHAR(50),  last_name VARCHAR(50),  age INT,  major VARCHAR(50),  faculty VARCHAR(50)); CREATE TABLE location (  id INT PRIMARY KEY,  name VARCHAR(50),  rooms INT); CREATE TABLE faculty (  id INT PRIMARY KEY,  name VARCHAR(50),  department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…

In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text.  Here is the table structure: CREATE TABLE USER_ (   USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL,       PRIMARY KEY (USER_ID) );  CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT (   SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL,      PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR (   SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…

Create view_admin.php for this table.

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. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438?   3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4.  Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.

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?

CSC1100 ProductID ProdName 614 Sprinkler G15 Humming bird feeder 620 Garden hose 625 Shovel JG29 Tab connector G43 Leaf roke G46 Pruning Shears 656 Bird House 35 G57 Planter box 130 Answer the following questions about the Products table in this image 1. What are the field names? Products InStock Database Review 78 40 60 30 65 89 8