l want to insert statement inside the table student on My SQL program the latest version but there is an error l am not able determine how to applied or insert a row as:
Steps
In each of these queries you’re shown the columns to display in
your result. Make your column headers look exactly like the example
shown. All these queries use the Starter database.
0. Even if you downloaded it for the previous assignment, to make
sure you have the very latest version, download StarterCreate.SQL
from Blackboard now. Before you run the StarterCreate.SQL, modify
it to put your name in as the first student. Scroll down in the
StarterCreate.SQL file until you see the first INSERT statement for
the Student table. Put your name in the First and Last fields, in
the Email Address and possibly, change the sex. Be sure not to
accidently delete the single quotes. Then run the SQL.
this is the pictures to insert
l am not really shore why l have an error when l try to insert statement
l want to insert as
but how to insert statements probably l am wrong based on the above instuction
Homework Answers
Hi,
As you have not shared the column data types and column lengths of your table, it is difficult to predict the exact cause of the failure. But,I can give you some general reasons for insert statements failure-
1. The column data type does not mat with the actual data that you are trying to insert.
2. The date format which you are using to insert in your insert statement may not be correct. To me it looks fine in your code.
3. The length of data for each field which you are trying to insert must be lesser than the column length defined in the table structure. Please check on this point.
4. All varchar fields should be kept inside the single quotes.
Please observe above statements and see if your insert statement meets those guidelines.
If you still face issue, please share the complete table structure and the insert statement being used.
Add Answer to:
l want to insert statement inside the table student on My SQL
program the latest version...
SQL Homework exercises: 1. Write INSERT statements that add two rows to the Members table for...
SQL Homework exercises: 1. Write INSERT statements that add two rows to the Members table for member IDs 1 and 2, two rows to the Groups table for group IDs 1 and 2, and three rows to the Group_Membership table: one row for member 1 and group 2; one for member 2 and group 1; and one for member 2 and group 2. Then, write a SELECT statement that joins the three tables and retrieves the group name, member last...
Question 1.Write a SQL statement for each of the following questions based on the above tables...
Question 1.Write a SQL statement for each of the following
questions based on the above tables (50 Points).
1) Create “Enrollment” table.
2) Change the credits of “Database” course from 2 to 3.
3) List the course titles (not Course_No) and grades John Doe
had taken.
4) Calculate average of Café Balance, and name new field as
Average Balance.
5) Create a roster for “Database” course (list student ID, last
name, first name, major, and status for each student enrolled...
Put all of your SQL code in a file named grades.sql and submit it below. Download...
Put all of your SQL code in a file named grades.sql and submit it below. Download the starter code, which contains import_grades.sql and the grades.csv file. Using he import_grades, sql file, create your database and table. - 0 eded. 1 T Une Modify the LOAD DATA INFILE to correct the path to load the grades.csv file, and add/remove LOCAL he only modification you may make to the import_grades.sql or the grades.csv files. The data represents grades for assignments in a...
Overview This lab provides you the opportunity to insert and update data with the use of SQL comm...
Overview This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you must have successfully completed Lab # 6. In Lab # 6, you executed a script that was provided to you. This script created 7 of the FLIX2YOU tables as documented in the Entity Relationship Diagram in the FLIX2YOU problem document. The second part of lab...
The lab for this week addresses taking a logical database design (data model) and transforming it...
The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...
If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top o...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...
I am having trouble with my Python code in this dictionary and pickle program. Here is...
I am having trouble with my Python code in this dictionary and
pickle program. Here is my code but it is not running as i am
receiving synthax error on the second line.
class Student:
def__init__(self,id,name,midterm,final):
self.id=id
self.name=name
self.midterm=midterm
self.final=final
def calculate_grade(self):
self.avg=(self.midterm+self.final)/2
if self.avg>=60 and self.avg<=80:
self.g='A'
elif self.avg>80 and self.avg<=100:
self.g='A+'
elif self.avg<60 and self.avg>=40:
self.g='B'
else:
self.g='C'
def getdata(self):
return self.id,self.name.self.midterm,self.final,self.g
CIT101 = {}
CIT101["123"] = Student("123", "smith, john", 78, 86)
CIT101["124"] = Student("124", "tom, alter", 50,...
Currently in my program I am trying to use and if else statement to choose either...
Currently in my program I am
trying to use and if else statement to choose either to add or
subtract. I'm calling eitehr my addition method or my subtraction
method in the statemenet. However i keep getting an error. "
Exception in thread "main" java.lang.Error: Unresolved
compilation problem:
at ArithmeticOperators.main(ArithmeticOperators.java:19)"
I'm not sure what is causing this at all, below is my code.
import java.util.*;
public class ArithmeticOperators{
public LinkedList head;
private static Scanner userChoice;
public String toString() {
...
Any little bit of information will be helpful. Thank you. Problem Statement You are to develop a program to read Mo...
Any little bit of information will be helpful. Thank
you.
Problem Statement You are to develop a program to read MotoGP rider information from an input file. You will need a MotoGpRider class whose instances will be used to store the statistics for a MotoGP motorcycle racer. The Rider class will have attributes for last name, first name, racing number, nation, motorcycle make, world championship points, world championship position, and an array that stores the number of top finishes (number...
I need help with this assignment in C++, please! *** The instructions and programming style detai...
I need help with this assignment in C++,
please!
*** The instructions and programming style details
are crucial for this assignment!
Goal: Your assignment is to write a C+ program to read in a list of phone call records from a file, and output them in a more user-friendly format to the standard output (cout). In so doing, you will practice using the ifstream class, I'O manipulators, and the string class. File format: Here is an example of a file...
Question 1.Write a SQL statement for each of the following
questions based on the above tables (50 Points).
1) Create “Enrollment” table.
2) Change the credits of “Database” course from 2 to 3.
3) List the course titles (not Course_No) and grades John Doe
had taken.
4) Calculate average of Café Balance, and name new field as
Average Balance.
5) Create a roster for “Database” course (list student ID, last
name, first name, major, and status for each student enrolled...
Put all of your SQL code in a file named grades.sql and submit it below. Download the starter code, which contains import_grades.sql and the grades.csv file. Using he import_grades, sql file, create your database and table. - 0 eded. 1 T Une Modify the LOAD DATA INFILE to correct the path to load the grades.csv file, and add/remove LOCAL he only modification you may make to the import_grades.sql or the grades.csv files. The data represents grades for assignments in a...
The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...
I am having trouble with my Python code in this dictionary and
pickle program. Here is my code but it is not running as i am
receiving synthax error on the second line.
class Student:
def__init__(self,id,name,midterm,final):
self.id=id
self.name=name
self.midterm=midterm
self.final=final
def calculate_grade(self):
self.avg=(self.midterm+self.final)/2
if self.avg>=60 and self.avg<=80:
self.g='A'
elif self.avg>80 and self.avg<=100:
self.g='A+'
elif self.avg<60 and self.avg>=40:
self.g='B'
else:
self.g='C'
def getdata(self):
return self.id,self.name.self.midterm,self.final,self.g
CIT101 = {}
CIT101["123"] = Student("123", "smith, john", 78, 86)
CIT101["124"] = Student("124", "tom, alter", 50,...
Currently in my program I am
trying to use and if else statement to choose either to add or
subtract. I'm calling eitehr my addition method or my subtraction
method in the statemenet. However i keep getting an error. "
Exception in thread "main" java.lang.Error: Unresolved
compilation problem:
at ArithmeticOperators.main(ArithmeticOperators.java:19)"
I'm not sure what is causing this at all, below is my code.
import java.util.*;
public class ArithmeticOperators{
public LinkedList head;
private static Scanner userChoice;
public String toString() {
...
Any little bit of information will be helpful. Thank
you.
Problem Statement You are to develop a program to read MotoGP rider information from an input file. You will need a MotoGpRider class whose instances will be used to store the statistics for a MotoGP motorcycle racer. The Rider class will have attributes for last name, first name, racing number, nation, motorcycle make, world championship points, world championship position, and an array that stores the number of top finishes (number...
I need help with this assignment in C++,
please!
*** The instructions and programming style details
are crucial for this assignment!
Goal: Your assignment is to write a C+ program to read in a list of phone call records from a file, and output them in a more user-friendly format to the standard output (cout). In so doing, you will practice using the ifstream class, I'O manipulators, and the string class. File format: Here is an example of a file...
Most questions answered within 3 hours.
-
A regression equation that describes the relationship between
the amount of the bill ($) at a...
asked 1 minute ago -
284 mL of a 0.52 M potassium hydroxide solution is added to 467
mL of a...
asked 29 minutes ago -
exercise on VSEPR and molecular structrue.
octahedral
SeCl62-
TeCl62-
ClF62-
distorted
SeF62–
IF6–
asked 30 minutes ago -
Little’s Law: Val d’Costa is a world famous ski village in the
French Alps. Because of...
asked 1 hour ago -
Find the absolute error D for the calculation if A + B/C=D A=
9.4 +/- 0.4...
asked 1 hour ago -
New Air Heating and Cooling, manufactures furnaces and central
air units. The company pride itself on...
asked 1 hour ago -
A coach uses a new technique to train gymnasts. Seven
gymnasts were randomly selected and their...
asked 3 hours ago -
While rotating the tires on your car you notice a rock [mass =
0.1 Kg] stuck...
asked 5 hours ago -
Using MARS simulator, write MIPS programs according to
the following scenarios: Receive a positive integer number...
asked 7 hours ago -
An object in front of a concave mirror has a real image that is
11.5 cm...
asked 7 hours ago -
Consider the reaction, C3 H8 + O2 --> CO2 + H2O. How many
moles of O2...
asked 9 hours ago -
You and your opponent both roll a fair die. If you both roll the
same number,...
asked 9 hours ago