2- Calculate the support and confidence for the following dataset (Bread, Cheese} Milk TID items bought (in the form of brand-item_category) {King's-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread} {Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread} {Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie} {Wonder-Bread, Sunset-Milk, Dairyland-Cheese} cust ID 01 T100 02 T200 01 Т300 03 T400

Q: difference between strong scaling and weak scaling?

A: Scalability will be used for indicating the ability of software and hardware for delivering greater…

Q: Create a Horse table with the following columns, data types, and constraints: ID - integer with…

A: I have provided the query to create a horse table with Id, RegistreredName, Breed and Height and…

Q: Q3: How can you tell the difference between Attribute Value Skew and Partition Skew?   Please…

A: Intro Attribute value skew alludes to the way that a few qualities show up in the parceling ascribes…

Q: Note: Students must submit a PDF document with screenshots, showing their T-SQL coding, object…

A: SELECT orderid, orderdate, custid, empid,   DATEFROMPARTS(YEAR(orderdate), 12, 31) AS endofyear FROM…

Q: Determine for each update anomaly whether or not the relation Abnormal_Rel is susceptible to that…

A: - The question want to examine the succeptibility capacity of the provided relation.

Q: Explain why an index is only helpful if an attribute's values are sufficiently diverse.

A: Introduction Use of an index with a wide range of values A file index is a table or other data…

Q: Q5) Run the code below to check on the model behavior for different polynomials (2,3, 5,10,20).…

A: Run the code below to check on the model behavior  for different polynomials(2,3,5,10,20) ..

Q: ier a dataset for [C1, The features are given by F1, F2 and F3. Each of these features have two…

A:

Q: Consider the following schema for a company database and answer the following questions: DEPARTMENT…

A: The  question did not say which DBMS platform has to be used.So MS SQL Server has been used to…

Q: Which of the following are part of data preprocessing steps? a. Aggregation b. Modelling c.…

A: The correct answer is a,c,e,f.

Q: Design two stored procedures as the following (4 marks) Create a PARAMETER based SELECT QUERY stored…

A: Q: Write query based on given values Note: Please ensure to update correct field names as they are…

Q: Using the following DB schema for the PATIENT table, right a query that will return all fields for…

A: Answer: SELECT * from PATIENT WHERE State=“KS” and State LIKE ‘K%’ ORDER BY MRN asc;

Q: Q3: What is the distinction between Attribute Value Skew and Partition Skew?

A: Intro Attribute value skew alludes to the way that a few qualities show up in the parceling ascribes…

Q: How do I find year from a date attribute using RA expression? For example, i have a table of set of…

A: Formula    SELECT {attribute}+ FROM {table}+ [ WHERE {boolean predicate to pick rows} ] [ ORDER BY…

Q: 5. Convert the following ERD to a relational model. SEATING RTABLE Seating ID Uses RTable Nbr Nbr of…

A: ERD(Entity Relationship Diagram) An entity relationship diagram (ERD), also known as an entity…

Q: Task-4: Plot a scatter plot with the Model Year values in the x-axis and their value counts in the…

A: 4. Algorithm: Start Import pandas and matplotlib.pyplot as plt First create series with given data…

Q: Consider an attribute whose data type is specified as NUMERIC(4, 2). Which of the following values…

A:

Q: Please excute the given SQL script…

A: Note: as per company guidelines we are supposed to answer only first 3-sub parts at a time. please…

Q: Q1/ 1- Find the name and the department of employees who has salary between 22000 and 32000 and work…

A: Answer: we have given table and we need to write the SQL command to find their given some task. we…

Q: Can a composite attribute be part of a composite key

A: Composite attribute as a composite key Composite attribute is a attribute that contains more than…

Q: Observe the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S111 Paul R1 S222…

A: Given two tables, Seller and Realtor. Seller table RealtorID attribute is depends on the Realtor…

Q: The first DataFrame must be called features, which is your feature matrix. The features DataFrame…

A: Answer: We have written code in the Python programming language  Algorithm Step1: We have import…

Q: Create a list that shows each department name, # of employees, maximum salary, minimum salary, total…

A: First EMP and DEPT tables have to join basing deptno in both.  Then group them by using dname. Then…

Q: Have a look at the figure below and then answer the following questions: extend- include-, identily…

A: We have given a figure which is a case diagram for the entities like Guest, Receptionist, Reserver.…

Q: You will normalize the following data (each user gets different data), and insert the following data…

A: SQL queries to solve the problem.Normalized data and inserted into the database. Schema and insert…

Q: For executing a query, which specifies a range of values in the WHERE clause, among Ordered indexing…

A: - We need to talk about the indexing to use for getting data from WHERE clause.

Q: Normalize the following schema up to third normal form by showing 1NF, 2NF and 3NF. DepartmentID…

A: We need to create 1NF, 2NF and 3NF normal forms for the given data table.

Q: Suppose you have a table with a primary key composed of two columns. When another column in this…

A: Suppose you have a table with a primary key composed of two columns. When another column in this…

Q: Please help me answer these three questions regarding Oracle database.  All are T or F.  Explanation…

A: Question 1: MAX, COUNT, SUM are said to be the group functions which do ignore NULL values. When we…

Q: Adjust the ARIMA instance below to build an autoregression model using your training data from Step…

A: Step 1 Build a train/test split using Amazon data. Dataset name is  amzn. Training Data starts in…

Q: Explain in detail the syntax and functionalities of the following Mongoose code:…

A: Below is the explanation:

Q: E4.5a Using the AIRPORT KLX Table, describe an example that illustrates the insertion anomaly. E4.5b…

A: E4.5a solution :-If a new terminal needs be added which is not operational , no Airline has been…

Q: Define the relationship between ‘View’ and ‘Data Independence’.

A: Answer: A view is a virtual table that gets its data from one or more underlying base tables rather…

Q: Consider a table called Employee with schema (empID, salary, rank, deptID) and a table called…

A: We have to fetch the employee id's who are working in HR department Then we will check if manager of…

Q: Q10. Show all jobs where the max salary remains under 10,000 even with a 25% increase. Columns to…

A: Among the given tables, we need to use Jobs table to display the required columns.

Q: Consider the following relational database schema that contains information about employees and…

A: {pid,pname} {pid,pname,budget} {pname,managerid} {pname,budget,managerid}

Q: 1. Assume that the following data definition statements for defining the COMPANY schema given in…

A: Given: Here we have tables and we need to write the SQL query for the following questions: Insert…

Q: what is meaning of O value into (min,max) Your answer - we can put an attributes on the relationship…

A: In min, 0 is the initial or starting value. In max, 0 is the end or last value.

Q: In Oracle, a calculated field such as item_price * item_quantity differs from a table field in what…

A: A field is nothing but a column in database table. A calculated or computed is a field that makes…

Q: Consider the following schema for a company database and answer the following questions: DEPARTMENT…

A: Q1. SQL DDL statements  CREATE DATABASE EmpDepProjDBGOUSE EmpDepProjDBGO  CREATE TABLE…

Q: Question 11 Which one is NOT correct? LOTSIA Property id County_name Lot Area FD1 FD2 FD5 LOSTS1A is…

A:

Q: 11.1: LAB-Create Horse table with constraints se Management Systems home > ● •…

A: The CREATE TABLE command is used to create a table in MYSQL.  Syntax: CREATE TABLE table_name (…

Q: 1) Given the View, which of the following statements are valid? CREATE VIEW DEPT_SUMMARY (D, C,…

A:

Q: Write a script that attempts to insert a new category named “Guitars” into the Categories table. If…

A: In the script, So the category 'Guitars' that you want to insert is already present, then logic is…

Q: Question 1: answer by true or false - The level of Ordinal data can characterized with a fixed zero…

A: 1. Data that may be meaningfully ordered by order of magnitude are said to be at the ordinal level.…

Q: Can we utilize custom settings and custom metadata in formula fields? Please explain the difference…

A: The following are the differences between custom settings and custom metaData in Salesforce: Yes,…

Q: (Data exploration and Mining Method Proposal): Here you will explore your data both visually and/or…

A: Note: Answering in python as no language is mentioned. Task : Load the dataset. Add statistical…

Q: Consider the following ERD; consider additional attributes if needed Write relational algebra…

A: Here i write relational algebra query for all :…

Q: The below data is in first normal form. Normalise the data to third normal form, howing all steps…

A: Here the primary key is {PlayerName, CharacterName} The FDs possible are PlayerName->Player…