The ages are like 19, 28, 28, 29, 13, 17, 42, 33, 22, 18, 41, 43, 58, 58, 49, 36, 36, 38, 41, 59, 15, 22, 34, 14, 13, 60, 17, 46, 39, 55. Smooth the data with a bin depth of 3 using all the available Binning methods
Q: Table Store_Information store_name Sales Date Los Angeles $1500 Jan-05-1999 San Diego $250…
A: Given:
Q: Q2) Consider the following table is used to store contact information: Name Company Address Phone1…
A: The above table is not normalized, because it has no such column in which values could be unique.…
Q: A survey of 400 college seniors resulted in the following crosstabulation regarding their…
A: The answer is given below:-
Q: You make a contingency table that compares if a person made a purchase and if they were exposed to…
A: As per our guidelines we are suppose to answer only first question. Post the remaining question as…
Q: 6( The HR Department wants to display all the employees who were hired either on 01-JAN-2021 or…
A: The Correct answer is c i.e. SELECT * FROM employees WHERE hire_date IN ('01-JAN-2021', '31-…
Q: Below is the answer that I have but it is incorrect can anyone help? select PROJ_NUM,…
A: Here you have simply used the ROUND(value,2) function. This will simply round the value to 2 places…
Q: What are the SQL query commands to create the COURSE table (attached) with appropriate attributes…
A: Query to create a “COURSE” table:CREATE TABLE COURSE (COURSE_TYPE VARCHAR (20) NOT NULL UNIQUE,…
Q: An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is…
A: To find the value using excel sheet.
Q: Suppose your company calculates the SLE for employee hard drive theft to be $200 and the ARO is 2.…
A: SLE is short for Single Loss Expectancy and it is the amount an organization expects to lose from a…
Q: Given the following data: Age (A) 10 15 Number of Hours Online per Week (B) 0-5 5-10 2 10-20 20- 30…
A: Given : Given the association between two types of groups : Age Number of hours online per…
Q: any as a project manager and you are required to design a Home automation for a client using…
A: Step 1: Smart home systems have grown in popularity in recent decades because they improve comfort…
Q: In the spreadsheet model shown below, an analyst makes the following data entries. Cell B3 В4 В5 В6…
A: Month Revenue Change(%) Rounded January 93000 February 119000 0.27957 0.27 March…
Q: 1. The following data records cigarette smoking and death rates due to leukemia in 14 states. We…
A: 1. Enter the given data about cigarette smoke and death rate due to Leukemia in Excel sheet 2.…
Q: Consider the frequent itemset I = {Ij, I>}. Which association rules could be generated from I?…
A: the answer is given below:
Q: Damon Davis was preparing the worksheet for Drano Plumbing Company. He calculated the net income to…
A: The unadjusted trial balance, adjustments, adjusted trial balance, and financial statements,…
Q: A school is conducting a survey of students to learn more about how they get to school. Students…
A: Overview - According to the question there is some student's data collected through survey form…
Q: Question 18 The following figure is an example of: ROOM office ="Y" classroom="Y" lab="Y" CLASSROOM…
A: Disjointness: A disjointness constraint means that the subtypes do not share any common entities.…
Q: Which of the following is the purpose of using Classification modelling? a. Creating a statistical…
A: Customers can be classified into distinct groups depending on their spending habits, web store…
Q: Grace Hopper attended which university?
A: Grace Brewster Murray Hopper was an American computer scientist and United States Navy rear admiral.…
Q: (1) What do you mean by Binning ? Explain different method of Binning? (11) For the Age data given…
A: Introduction: Noisy data: Noise is a random error or variance in a measured variable. Data smoothing…
Q: Main Street Bank is offering an annual interest rate discount based on the client’s credit score.…
A: // PaymentSchedule.java import java.util.Scanner; public class PaymentSchedule { public static void…
Q: !Consider the following table Policy No. Agreement No. Work_Hours Worker_Name Restaurant_Number…
A: i provide the answer below
Q: QUESTION 13 The expression sl.regionMatches(0, "art", 0, 3) has the same result as which of the…
A: Here , the java statements are given where string matching is perform. The given option output's…
Q: 3. Consider the following tables and then provide a pipe diagram for the requested output. ID Age ID…
A: According to the Bartleby guideline we are suppose to answer only first 3 sub part of the question…
Q: Hello, I am trying to study for a class and one question will be on utility function on excel, I was…
A: Answer: I have given answered in the handwritten format in brief explanation
Q: Three of the mentors started writing notes for the CS Subjects and before they started they had set…
A: Introduction :Given , Number of mentors = 3Further conditions are also defined , we have to…
Q: Calculate the gain and loss percentage for bearish and bullish patterns in stock market. What will…
A: The relаtive strength index (RSI) is а mоmentum indiсаtоr used in teсhniсаl аnаlysis…
Q: Consider the following scenario: you want to investigate the relationship between the number of…
A: Introduction: Although multiple regression analysis (and variants such as regression in stages or…
Q: a) Suppose that You have gotten a job planning databases for the European Union. Your first on job…
A: The entity-relationship diagram is one of the diagrams in the database management systems that…
Q: Q6. Given below figure, answer the following questions a. What is the purpose of time, in steps 1…
A: The question has been answered in step2
Q: Task-2: Amazon wants to reward the customer who has done the most number of transactions, by…
A: a=[] b=[] for i in (Data1.head(200) and Data1.tail(200)): if i[-2] not in a:…
Q: Student with the following attributes: Student_ld, student fell name, average mark and course_id.…
A: In questions with many individual demands, we must answer the first three. All the classes with…
Q: A survey asked people what alternative transportation modes they use. Using the data to complete a…
A: Given, the people who use all three is 2% So, the venn diagram looks like
Q: Which of the following classifiers is least likely to underfit or overfit the data? Group of answer…
A: Here have to determine correct option for classifiers for least underfit or overfit.
Q: Imagine that you are the person in charge of the database for the iTunes store. How may one make use…
A: NOTE :- Below i explain the answer in my own words by which you understand it well. In business,…
Q: A startup team is interested in creating a productivity app. In estimating the cost of creating the…
A: b2 = +0.251
Q: Given the following EER model for an airline business: Date of (1.1) (0.n) Birth Customer Airport…
A: Рleаse find belоw the steрs tо соnvert ERD tо Relаtiоnаl Dаtа Mоdel: Steр 1: Find…
Q: How would you organize this flat file for the collection of data?
A: A database stored in a file called a flat-file database. Now the question is how can you create a…
Q: From worksheet sheet3, in cell 14, display the Performance of an employee as "Amazing" if the Total…
A: Required:
Q: For items A and B the support counts are as follows. Support count of A: 50, support count of B: 40,…
A: Given Support count of A= 50 Support count of B = 40 Support count of A and B = 20 Total no.of…
Q: college major depend on whether you are an athlete or not? A survey asks a group of college students…
A: test stat = 128 critical value = 9.210 test stat > critical value, REJECT Ho so,
Q: Given employee data from some company, the semantics of each row are: employee ID, employee name,…
A: According to the question employee data is given. the semantics of each row are: employee ID,…
Q: T; |-2|1 13 y: 12 1-1|1 and the model y = a, + a, sin(x) In the sense of the least square, which one…
A: Choice 1
Q: Consider the following DFAs: a) Create a DFA that recognizes L(M1) ∩ L(M2). b) Create a DFA that…
A: A single DFA which simulates operation of two DFAs in parallel! Let the two DFAs be M1 and M2…
Q: Does this ERD make any sense? Does it have 1NF, 2NF and 3NF? Business Rules Teacher: Teacher can…
A: ERD is incorrect. The inaccuracies are explained in terms of normalization. 1NF Every entity…
Q: (1) What do you mean by Binnıng ? Explain different method of Binning? (11) For the Age data given…
A: Binning:- Binning is a way to group a number of more or less continuous values into a smaller number…
Q: Question. The term MATCHING is used as a code word by a shopkeeper to indicate the prices of an…
A:
Q: Martin created a website where users could randomly generate a "strong password." He claims that 22%…
A: Probability of getting a strong password is 22% ie 22/100 Probability of getting 4 strong passwords…
Step by step
Solved in 2 steps
- The scenario is for a small life insurance agency and their need to keep track of clients, agents, insurers, and quotations. 1) A Client is a customer, potential customer, or contact of the agency. We need to assign each client a number and save their last name, first name, birth date, gender, telephone number, email address, and the agent who brought the client into the agency. If a client is a “walk in” they are assigned to the first available agent. All clients must have one primary agent. 2) An agent is a licensed individual with the state. Each agent has a nationally unique license number, last name, first name, telephone number, and email address. An agent must be the primary agent for at least one client but may not be primary for more than 500 clients. An agent must also be part of at least one quotation and may share in an unlimited number of quotes. 3) The agency represents (does business with) many insurance companies (insurers). We will need to track each insurer with an…Damon Davis was creating the Drano Plumbing Company's spreadsheet. He determined that the net income would be $50,000. When he tallied the columns on the Balance Sheet, the totals were as follows: debit, $400,000; and credit, $300,000. What was the most likely reason for this discrepancy? If this was not the case, how should he proceed to determine the source of the error?How to normalise this realtion From 1NF to 3NF Employee( em_id,name, school_No, Name, Phone, Position, wage) school_no foreign key School_no—>transitive the address from school to employee , teacher,student School (school_No,Address, size) Class(ClassID, Class_name, class_ Descrpt, teacher_id) teacher_id foreign key Student (student_id, Name, DOB, Phone , school_No) school_no foreign key Teach(teacher_id, student_id) both foreign key Take(classID, student_id) both foreign key Payment (PaymentID, paymentDate,Amount, student_id) student_id foreign key Teacher(emp_id ,certificate , subject, school_No) emp_id foreign key school_No foreign key
- Draw an ER model based on following scenario.A travel agency has different bus stations at different location. Each station has a unique name, locationand buses. Each bus has a unique bus number, color and type. The bus takes routes between stations.Each route has a name, arrival time and departure time. A single bus can take routes to different stations.Some buses may not take any route in some days however a station must have a route each day. Eachbus contains seats. Each seat has unique number, row and seat type. There are three different types ofseats as first class, standard and economy. Passengers can make reservations. Passenger has id number,full name, age, gender and address. Each reservation will have a unique reservation number, fare, dateand time. Each reservation can have any numbers of seats. The reservation is dependent on passenger.a) Suppose that You have gotten a job planning databases for the European Union. Yourfirst on job assignment is to help the various countries maintain information about theirinhabitants. Your model should capture the following information:• In each country, there are provinces, which contain towns. There cannot be twoprovinces with the same name in a single country. Similarly, there cannot be two townswith the same name in a single province.• People live in towns. Men and women work in a town. Children learn in a school in atown.• A person can be a man, a woman, or a child, and has a first-name, last-name, id, andbirthday.Children are any people under the age of 18.• A man can be married to a woman (polygamy is not allowed, i.e., one man can bemarried only to one woman). Although the Pope strongly disapproves, divorce, andsubsequent remarriage, is possible.• For each marriage, store the date of the marriage and information about who are thechildren of the married couple. You should…Finally, we can select cell E2, grab the drag handle, and then drag down to E4 to obtain the other two Total Cost values. This technique uses relative cell references, meaning the values can change as you drag downward. In the given spreadsheet, three investments are listed in rows 4-6. Column B contains the expected growth rate for each investment as a percentage. Calculate the expected value of Investment A in cell D4 by multiplying its value in Year 0 by the quantity ( 1 + Growth rate). Then drag cell D4 down to D6 to get the other two investment values after one year given different growth rates and place those values below: Investment A: : (to the nearest dollar) Investment B:$(to the nearest dollar) InvestmentC:$(to the nearest dollar) Absolute Cell References By placing a dollar sign (\$) in front of the row and/or column of a cell you can "lock down" elther the row, column, or both so no change occurs when you drag to fill other cells. In row 13, we would like to calculate the…
- For an order of 100 bicycles, what would be the total time in minutes (including queue time, setup, and processing time) to complete this order? Use the routing parameters from lab exercise 4, task 2( the picture). Assume wait and move times are zero but queue time is not zero. Show your work in a spreadsheet. Also assume the process for this company is job shop.Computer Science THREE TABLES: 1. PROJECT WORKER_TABLE COLUMNS leavedate, worker_id, joindate, project_id, performance 2. PROJECTS TABLE COLUMNS projectid, project_name, capacity, startdate 3. WORKERS table COLUMNS worker_id, worker_name, gender, companyjoindate, birthdate, birthday, supervisory_id USE MYSQL TO ANSWER QUESTION BELOW Q: Find the ID and name of the project(s) that have a gender ratio of greater than one[Gender ratio = #of females/# of males]Hello, Just want to check if the attached Crow's Foot ERD is correct for the following problem: Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: A large university consists of several schools. Each school is chaired by one employee. An employee may be the dean of one and only one school.
- Customers have ID, names, phones and addresses. Cars have a CAR_ID, a model and make, as well as a year. A customer can rent many cars A car can be rented by many customers Some customers do n ot rent cars All cars are rented by at least one customer. Given the above, there is a many-to-many relationship between customer and car. Draw the many-to-many ER model in Crow's Foot notationLastly, you will notice that more people scored "Above Average" than "Below Average" using 5 as the cut point. Redefine the LOOKUP formula so that a roughly equal number of employees are classified as "Above Average" and as "Below Average." 6. What is the new cut off point? Answer this question.This is the ER model for the case where there exists the entity of Product, which has the attributes of costPrice, salePrice, Identifier, factoryCode, description. These Products are manufactured by a Factory that has the attributes of description, factoryCode, factoryAddress, and this Factory sells its products to the Distributor entity, which has the attributes of distributorCode, factoryCode, email, description, distributorName. Please do the next thing: The requirement has been expanded with the following information: 'Currently, an Excel sheet is used where we store the information of the products that customers have ordered through orders; information is stored about when an order has been delivered and who or which company has made the delivery of the order.' Expand the ER diagram seen in class to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has." Please do the IMAGE E-R Diagram Expanded