Subject (DBA)

use MYSQL workbench select my guitar shop database as default schema

Question text

Problem10

Write a script that implements the following design in a database named household_chores:

Details

• Include a statement to drop the database if it already exists.
• Include statements to create and select the database.
• Include any indexes that you think are necessary.
• Specify the utf8 character set for all tables.
• Specify the InnoDB storage engine for all tables.

Solution

______ DATABASE IF EXISTS ______ ;

CREATE DATABASE household_chores CHARSET _________ ;

________ ;

______   _______ (

         person_id       INT          PRIMARY KEY ______ ,

         first_name    VARCHAR(50) NOT NULL,

         last_name     VARCHAR(50) NOT NULL

) ENGINE = InnoDB;

CREATE TABLE chores (

         chore_id   INT         PRIMARY KEY _______

         name VARCHAR(100) UNIQUE

) _______

CREATE TABLE tasks (

         task_id   INT         PRIMARY KEY AUTO_INCREMENT,

         chore_id INT,

         name   _______ UNIQUE,

         CONSTRAINT fk_tasks_chores

                 _________

                 REFERENCES _______

) _______ = InnoDB;

CREATE TABLE assignments (

         _______    INT         PRIMARY KEY AUTO_INCREMENT,

         person_id   ______ ,

         task_id   INT,

         _______ fk_assignments_people

                 _______

                 REFERENCES _______ ,

         CONSTRAINT fk_assignments_tasks

                 ______

                 _______ tasks (task_id)

_______

The uncertainty principle arises from a common-sense idea: To measure something, you must affect it somehow. For instance, when you use a pressure gauge to measure air pressure in a car tire you release a small amount of air into the gauge.

• Why does shining very short wavelength photons on an electron not tell you exactly where the electron is?
• Describe two other examples of situations in which measuring something about an object somehow changes it.

Q.4.     A) How Data Dissemination in Vehicular Ad hoc Networks (VANETs) is achieved?

explain in detail

Use the normal distribution to find a confidence interval for a proportion p given the relevant sample results. Give the best point estimate for p, the margin of error, and the confidence interval. Assume the results come from a random sample. A 95% confidence interval for p given that p Overscript ^ EndScripts equals 0.42 and n equals 450. Round your answer for the best point estimate to two decimal places, and your answers for the margin of error and the confidence interval to three decimal places.

best point estimate ?

MOE?

95% CI?

What the four techniques for leading cross cultural projects?

Let μ1 denote true average tread life for a premium brand of P205/65R15 radial tire, and let μ2 denote the true average tread life for an economy brand of the same size. Test H0: μ1 − μ2 = 5000 versus Ha: μ1 − μ2 > 5000 at level 0.01, using the following data: m = 35, x = 42,100, s1 = 2500, n = 35, y = 36,900, and s2 = 1500. Calculate the test statistic and determine the P-value. (Round your test statistic to two decimal places and your P-value to four decimal places.) z = 0.4058 Correct: Your answer is correct. P-value = 0.5942 Incorrect: Your answer is incorrect.

11. For a local basketball league, there were 10 teams whose players were assigned to a team based on their score on an abilities test. Those results are given below.

The summary statistics are:

1. From just looking at the summary data, what conclusions might you draw? (You may want to talk about average and/or variance)

You are a project manager for a consulting firm. You are going to hire four new employees. The candidates that you are choosing from are named Amy, Bob, Charlie, Debbie, and Elizabeth. You are managing two projects that you will use your new employees to complete. Project 1 will require at least 700 labor hours and Project 2 will require at least 870 labor hours. Elizabeth is the owner’s daughter so you will have to hire her. Amy and Charlie used to work together, but they can’t stand each other. If you hire one, you can’t hire the other.

You have contracts that guarantee a set fee for each of the projects. Your profit will be determined by your ability to minimize your labor costs. Each of the employees you hire will require a signing bonus. The respective signing bonuses required for each employee if hired follow: Amy $24,000; Bob $11,000; Charlie $16,000; Debbie $17,000; Elizabeth $15,000.

The hourly rate you pay each employee is determined by the type of project to which they are assigned. For Project 1, the required hourly rates for each employee if hired follow: Amy $100; Bob $95; Charlie $85; Debbie $50; Elizabeth $45. For Project 2, the required hourly rates for each employee if hired follow: Amy $60; Bob $40; Charlie $75; Debbie $120; Elizabeth $130. If you hire an employee, they can be used for both projects. Labor should be allocated in one hour increments.

During the lifespan of these two projects, the candidates are available to work the following number of hours: Amy 440; Bob 730; Charlie 520; Debbie 680; Elizabeth 590. Which candidates will you hire?

Using Python

Implement Recursive Selection Sort with the following recursive method.

1. Find the smallest number in the list and swaps it with the first number.

2.Ignore the first number and sort the remaining smaller list recursively.

Build a html form with the following elements. The form must be within a table structure.

• Current date: a non-editable textbox and should be in the format as shown (e.g. 12 October 2020 Monday 05:35 PM)

• Number of weeks till end of the year: a label showing the total number of weeks from now till 31st Dec 2020. (e.g. 17 days is 2 weeks and 3 days)

class listnodes{
int data;//first part of the node(data)
listnodes link;//second part of the node(address)
listnodes()
{
data=0;
link=null;
}
listnodes(int d,listnodes l)//10|null
{
data=d;
link=l;
}
}
class singlelinkedlist{
void display(listnodes head){
listnodes current=head;
while(current.link!=null){
System.out.print(current.data+"-->");
current=current.link;
}
System.out.print(current.data);
  
}
public listnodes insert(listnodes head,int data)
{
//create new node
listnodes newnode=new listnodes(data,null);
//link the newnode to the head node
newnode.link=head;
//make newnode the first node
head=newnode;
return head;//return the first node
}
//insert at a position(after or before a node)
public listnodes InsertAtPostion(listnodes head,int data,int position){
listnodes newnode=new listnodes(data,null);   
listnodes previous=head;
int count=1;
while(count<=position-1){//(count<position)
previous=previous.link;
count++;
}
// listnodess current=previous.link;
listnodes current=previous;
current=previous.link;
newnode.link=current;
previous.link=newnode;
return head;


}
public listnodes deletefirst(listnodes head){
listnodes temp=head;//rename
head=head.link;//move head
temp.link=null;//temp alone
return temp;
}
public listnodes deletelast(listnodes head){

if(head==null){
return head;
}
listnodes last=head;
listnodes previoustolast=head;
while(last.link!=null){
previoustolast=last;
last=last.link;
}
previoustolast.link=null;
return last;
}
public int length(listnodes head){
listnodes curr=head;
int c=0;
while(curr!=null){
c++;
curr=curr.link;
  
}
return c;
}
public boolean find(listnodes head,int searchkey){
listnodes curr=head;
while(curr!=null){
if(curr.data==searchkey)
{
return true;
}
curr=curr.link;
}
return false;
}
}

public class linkedlist {
public static void main(String[] args) {
//craete first node
listnodes head=new listnodes(10,null);
//create an object of class where all the methods are   
singlelinkedlist sl=new singlelinkedlist();
//insert at postion
sl.InsertAtPostion(head, 30, 1);

//insert at front
listnodes newhead=sl.insert(head,20);
sl.display(newhead);

//delete last
System.out.println(" ");
System.out.println("Delete a node at end");
listnodes l=sl.deletelast(head);
sl.display(l);
System.out.println(" ");
//delete first
System.out.println("\nDelete a node at begining and return head: \n");
listnodes first=sl.deletefirst(head);
sl.display(first);
System.out.println(" \n");
//find length
System.out.println("length is="+sl.length(head));
System.out.println(" ");
//Search a node
System.out.println("Search for a node");
if(sl.find(head, 10)){
System.out.println("key found");}
else
System.out.println("key not found");
}
}

ON THIS CODE

Write an application and perform the following:

-Create at least three classes such as:

1. listnode- for data and link, constructors

2. Singlelinkedlist-for method definition

3. linkedlist-for objects

-Insert a node at tail/end in a linked list.

-and display all the nodes in the list.

-Delete a node at a position in the list

Java

How to read a comma separated value file using Scanner

for example Scanner sc = new Scanner(filename);

I need to assign each value separated by a comma to different variable types.

I need a good example to know how it works and implement it in my project

Please only use Scanner to read the file

Explain how MIS enabling business communications at Facebook? (250 words)

Primary Topic: “Western Christianity or World Christianity?" post a short-essay in this FORUM for each question that you answer

Discuss important achievements of Pope Gregory