SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 337 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 15 Nov 2017 My Price 10.00

different forms of the INSERT command to add a student

Need some assistance with this assigment. Can someone please provide help

6.39 Write SQL commands for the following:

 

A. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table.

 

 

 

B. Now write a command that will remove Lopez from the student table.

 

 

C. Create a SQL command that will modify the name of the course ISM 4212 from Database to Introductions to Relational databases.

 

 

 

6.40 Write SQL queries to answer the following questions:

 

A. Which students have an ID number that is less than 50000

 

 

B. What is the name of the faculty member whose ID is 4756? 

 

C.what is the smallest section number used in the first semester of 2015?

 

6.41 Write SQL queries to answer the following questions:

 

A. How many students are enrolled in Section 2714 in the first semester of 2015?

 

B. Which faculty members have qualified to teach a course since 2008? List the faculty ID, course, and date of qualification.

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 15 Nov 2017 07:11 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)