This HW is to be done in the same groups as Lab 2A

Create a version of the hybrid merge-join method that is suitable for situations where both relations are not physically sorted but have a sorted secondary index on the attributes to be joined?

It may be advantageous to keep the join as a materialized view if a parallel data-store is used to hold two relations r and s and we need to connect them. What are the advantages and disadvantages in terms of total throughput, space utilization, and user query response time?

PLZ help with the following: Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints. Normalize the relations to 3NF.

Create an MVC web application having the index view given below. The given view will be populated from the model book having data members (Id, Title). Write only the code for the model class with the action SubmitImg() to submit the data in the database table book(id, title). Use suitable data annotations attributes to perform empty field validation also. No need to write view code.

This question is based on the View Ridge Gallery database you have been using in the labs. See the textbook for background to the case and the table structures. The tables are: ARTIST CUSTOMER WORK TRANS CUSTOMER_ARTIST_INT You can use the dtoohey tables that we have been using. If you prefer, you can create your own copies of these tables under your own account to work with. If you do so, you should ensure you copy the same sample data and constraints as in the dtoohey tables. List the total amount of sales of works of art by the gallery for each year, and the number of works sold that year.

The Driver Relationship team wants to analyze drivers and their car usages in InstantRide for the month October. Thus, they want to focus on each driver and respective car allocation occurred. In more detail, the team requires the DRIVER_ID and the CAR_ID with their usage counts as the TOTAL column for the travels occurred in the month of October. Since the team wants to also learn the total number of the travels by the drivers you need to use GROUP BY ROLLUP functionality.

II. Synthesis: Analyze the given case and answer the following question accordingly. Q3. Based on the given tables FACULTY, COURSE, Perform the PROJECT operation using SELECT and JOIN operations as given in the query to create a subset of data. Show the output in a table format Table1: FACULTY Professor D P8259 P8261 P8444 P8263 Table2 COURSE CourselD COMPS11 COMP621 COMP532 COMPS42 COMP553 COMP564 ProfessorName Will Joy Charles Andres CourseName Compute Fundamentals Web Technologies IT Infrastructure Data Mining Cloud Computing Web Applications Professor Address 190, Blue Mountain 4567, Miller Street 2320, 7th Avenue 173, Adams Boulevard Semester First Second Third Fourth Fifth Sixth ProfessorID P8444 P8263 P8259 P8261 ProfessorCity California New York Seattle Texas P8444 P8259 ZipCode 6789 4567 2334 3245 Query: SELECT FACULTY.ProfessoriD, FACULTY ProfessorName, FACULTY Professor City, COURSE CourselD, COURSE CourseName FROM COURSE, FACULTY WHERE COURSE ProfessorID=FACULTY.ProfessorID…

A set of 11 data points is given in the attached Excel spreadsheet: PS5_prob1_FD_data.xlsx.Task: Perform numerical differentiation to approximate the second derivative of theprovided data. In doing so, address the following prompts:1. Write your own MATLAB code to perform an appropriate Finite Difference (FD)approximation for the second derivative at each point in the provided data. Note:You are welcome to use the “lowest order” approximation of the second derivative f ′′(x).a) “Read in” the data from the Excel spreadsheet using a built-in MATLAB com-mand, such as xlsread, readmatrix, or readtable – see docs for more info.b) Write your own MATLAB function to generally perform an FD approximationof the second derivative for an (arbitrary) set of n data points. In doing so, usea central difference formulation whenever possible.c) Call your own FD function and apply it to the given data. Report out/displaythe results.2. Reflect on your results by comparing to the exact solution.a) The…

Use the iloc() function to extract the first 20 features of the dataframe har_train. Save this new dataframe to first_twenty. Next, using the seaborn library create a heatmap for the correlation matrix. First you have to create the correlation matrix from the pandas dataframe (save it in a dataframe called corr) and then plot it using seaborn with these customizations: Set the seaborn style to white. Generate a mask using np.triu(np.ones_like()) with the dtype as boolean to only show the lower triangle of the correlation matrix. Save it in a variable called mask. Set up the figure with matplotlib with figsize=(11,9). Use fig, ax = ... Generate a custom diverging colormap for the heatmap with the arguments (220, 10, as_cmap=True). Save it in a variable called cmap. Draw the heatmap with the mask and correct aspect ratio, using the arguments corr, mask=mask, cmap=cmap, vmax=.3, center=0, square=True, linewidths=.5, cbar_kws={"shrink": .5}). Finally, use fig.tight_layout() just before…

Query design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing:

The aim of assignment 1 is to implement a database schema and execute different types of SQL queries in Oracle SQL developer. Given the following relational schema: Student (studid, FirstName, LastName, Email, phoneNumber, DateofBirth, GPA) Club (clubid, ClubName, #studid) MemberOf (#clubid, #studid, joiningDate ) Activities (actid, actdt, place, durationNbHour) Organize (#actid , #clubid , fee) 1. Write SQL queries to create the following tables according to the below descriptions. Table name: Student studid |Char(9) Primary key FirstName Varchar2(50) NOT NULL LastName Varchar2(50) NOT NULL Email Varchar2(50) NOT NULL, UNIQUE phoneNumber Number(8) NOT NULL, UNIQUE DateofBirth Date NOT NULL GPA Number(1,2) NOT NULL Table name: Club clubID Number(3) Primary key ClubName Varchar2(20)NOT NULL NULL, UNIQUE, NOT Foreign key studid Char(9) Table Name: MemberOf ClubID Number(3) Primary Key, Foreign Key Studid Char(9) Primary Key, Foreign Key joiningDate Date Table Name: Activities Actid…

Give a normalized version of the Index_metadata relation, and explain why using the normalized version would result in worse performance.

Query design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing:

Create an MVC web application having the index view given below. Given view will be populated from the model book having data members (Id, Title). Write only the code for the model class with the action Submitlmg() to submit the data in database table book(id, title). Use suitable data annotations attributes to perform empty field validation also. No need to write view code. Book Form Book Id Book Title Save

Task 2: ' The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.

The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. Task   Return a list of all the residents and owners

Task 5: ' The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED field in the active drivers table. Since all the drivers are already active in InstantRide, their driving licenses should be checked regularly. The team wanted you to remove the field from the table.   ANSWER IN MYSQL PLEASE

Create a new iteration of the hybrid merge-join method, in which none of the relationships are ordered physically but instead have a main index on the attributes that are being merged.

Make sure the SQL script file can be run successfully in MySQL and show the outcome of the code on MySQL