ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

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

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 5 Weeks Ago, 4 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 26 Apr 2017 My Price 9.00

CREATE if not exists DATABASE RSYSTEM

  1. Find the full names of the students who have taken a CIS course or a History course
  2. Find the full names of the students who have taken both a CIS course and a History course
  3. Find the full names of the students who have taken a CIS course but have not taken a History course

 

 

CREATE if not exists DATABASE RSYSTEM;
USE RSYSTEM;
DROP TABLE if exists registration;
DROP TABLE if exists course;
DROP TABLE if exists student;
CREATE TABLE student(
sid
varchar(10),
fName VARCHAR(30) NOT NULL,
lName VARCHAR(30) NOT NULL,
gpa
double,
dob date,
CONSTRAINT sailor_pk PRIMARY KEY(sid)
)ENGINE = INNODB;
-- NOT NULL auto_increment
CREATE TABLE course(
crn
INT ,
cname VARCHAR(30),
cDiscription
VARCHAR(10),
dept varchar(5),
cNumber int,
cSection int,
credits int,
cyear
char(4),
CONSTRAINT course_pk PRIMARY KEY(crn)
)ENGINE = INNODB;
CREATE TABLE registration(
registration_num INT NOT NULL auto_increment,
sid
varchar(10),
crn
int,
csection int,
rdate TIMESTAMP,
CONSTRAINT registration_pk PRIMARY KEY(registration_num),
CONSTRAINT registration_fk1 FOREIGN KEY (sid) REFERENCES student(sid),
CONSTRAINT registration_fk2 FOREIGN KEY (crn) REFERENCES course(crn)
) ENGINE = INNODB;
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J0901',
'John','Burke', 4.0, '1988-09-12');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J1902', 'Terrence',
'Williams', 1.69, '1987-12-10');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J2903', 'Jennifer',
'Thompson', 3.8, '1998-06-30');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J3904', 'Jasmine',
'Sloane', 3.8, '1979-03-9');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J4905', 'Joseph',
'Nilan', 2.0, '1982-01-14');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J59906', 'Gregory','Moody', 2.7, '1990-02-17');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J6907', 'Harper',
'Dennis', 3.0, '1991-10-10');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J7908',
'Camella','Poindexter', 3.9, '1994-10-10');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J8909',
'Harper','Dennis', 3.2, '1988-09-19');
INSERT INTO student(sid, fName, lName, gpa, dob) VALUES ('J9910', 'Porsha',
'Maner', 3.9, '1988-05-11'); -- The following SQL statements populate the boat table
INSERT INTO course (crn , cName, dept, cNumber, csection, credits, cYear)
VALUES ( 50343,'Data Base Management', 'CIS', 205, 001, 4, '2010' );
INSERT INTO course (crn , cName, dept, cNumber, csection, credits, cYear)
VALUES ( 50344,'Data Base Management', 'CIS', 205, 002, 4, '2010' );
INSERT INTO course (crn , cName, dept, cNumber, csection, credits, cYear)
VALUES ( 50345,'Data Base Management', 'CIS', 205, 003, 4, '2010' );
INSERT INTO course (crn , cName, dept, cNumber, csection, credits, cYear)
VALUES ( 50347,'Operating Systems', 'CIS', 105, 002, 4, '2010' );
INSERT INTO course (crn , cName, dept, cNumber, csection, credits, cYear)
VALUES ( 50445,' American History', 'HIS', 101, 001, 3, '2010' );
INSERT INTO course (crn , cName, dept, cNumber, csection, credits, cYear)
VALUES ( 50645,'English', 'ENG', 105, 001, 3, '2010' );
INSERT INTO course (crn , cName, dept, cNumber, csection, credits, cYear)
VALUES ( 50745,'Calculus I', 'MATH', 105, 001, 3, '2010' ); -- The following SQL statements populate the reservation table
INSERT INTO registration (sid, crn, csection) VALUES ('J0901', 50745, 001); INSERT INTO registration (sid, crn, csection) VALUES ('J0901', 50645, 001); INSERT INTO registration (sid, crn, csection) VALUES ('J0901', INSERT INTO registration (sid, crn, csection) VALUES ('J0901', 50344, 002); INSERT INTO registration (sid, crn, csection) VALUES ('J1902', 50344, 002); INSERT INTO registration (sid, crn, csection) VALUES ('J1902', 50745, 001); INSERT INTO registration (sid, crn, csection) VALUES ('J1902', 50344, 002); INSERT INTO registration (sid, crn, csection) VALUES ('J2903', 50347, 001); INSERT INTO registration (sid, crn, csection) VALUES ('J2903', 50343,001); INSERT INTO registration (sid, crn, csection) VALUES ('J9910', 50343,001); 50445,001);

Answers

(11)
Status NEW Posted 26 Apr 2017 05:04 AM My Price 9.00

-----------

Attachments

file 1493183940-Solutions file 2.docx preview (51 words )
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 -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)