Computers and Technology, 17.04.2021 15:20 stodd9503

/PRICE: / INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);
INSERT INTO PRICE VALUES (2, 'New Release', 3.5, 3);
INSERT INTO PRICE VALUES (3, 'Discount', 1.5, 1);
INSERT INTO PRICE VALUES (4, 'Weekly Special', 1, .5);
/MOVIE:/
INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2014, 39.95, 'FAMILY', 2);
INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2011, 59.95, 'ACTION', 1);
INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2015, 59.95, 'DRAMA', 2);
INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2014, 29.95, 'COMEDY', 2);
INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2015, 89.95, 'DRAMA', NULL);
INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2005, 25.49, 'DRAMA', 3);
INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2012, 45.49, 'ACTION', 1);
INSERT INTO MOVIE VALUES (1246, 'What He Doesn''t Know', 2013, 58.29, 'COMEDY', 1);
/VIDEO:/
INSERT INTO VIDEO VALUES (54321, '18-JUN-15', 1234);
INSERT INTO VIDEO VALUES (54324, '18-JUN-15', 1234);
INSERT INTO VIDEO VALUES (54325, '18-JUN-15', 1234);
INSERT INTO VIDEO VALUES (34341, '22-JAN-14', 1235);
INSERT INTO VIDEO VALUES (34342, '22-JAN-14', 1235);
INSERT INTO VIDEO VALUES (34366, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (34367, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (34368, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (34369, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (44397, '21-OCT-15', 1237);
INSERT INTO VIDEO VALUES (59237, '14-FEB-16', 1237);
INSERT INTO VIDEO VALUES (61388, '25-JAN-14', 1239);
INSERT INTO VIDEO VALUES (61353, '28-JAN-13', 1245);
INSERT INTO VIDEO VALUES (61354, '28-JAN-13', 1245);
INSERT INTO VIDEO VALUES (61367, '30-JUL-15’, 1246);
INSERT INTO VIDEO VALUES (61369, '30-JUL-15', 1246);
/MEMBERSHIP:/
INSERT INTO MEMBERSHIP VALUES (102, 'TAMI', 'DAWSON', '2632 TAKLI CIRCLE', 'NORENE', 'TN', '37136', 11);
INSERT INTO MEMBERSHIP VALUES (103, 'CURT', 'KNIGHT', '4025 CORNELL COURT', 'FLATGAP', 'KY', '41219', 6);
INSERT INTO MEMBERSHIP VALUES (104, 'JAMAL', 'MELENDEZ', '788 EAST 145TH AVENUE', 'QUEBECK', 'TN', '38579', 0);
INSERT INTO MEMBERSHIP VALUES (105, 'IVA', 'MCCLAIN', '6045 MUSKET BALL CIRCLE', 'SUMMIT', 'KY', '42783', 15);
INSERT INTO MEMBERSHIP VALUES (106, 'MIRANDA', 'PARKS', '4469 MAXWELL PLACE', 'GERMANTOWN', 'TN', '38183', 0);
INSERT INTO MEMBERSHIP VALUES (107, 'ROSARIO', 'ELLIOTT', '7578 DANNER AVENUE', 'COLUMBIA', 'TN', '38402', 5);
INSERT INTO MEMBERSHIP VALUES (108, 'MATTIE', 'GUY', '4390 EVERGREEN STREET', 'LILY', 'KY', '40740', 0);
INSERT INTO MEMBERSHIP VALUES (109, 'CLINT', 'OCHOA', '1711 ELM STREET', 'GREENEVILLE', 'TN', '37745', 10);
INSERT INTO MEMBERSHIP VALUES (110, 'LEWIS', 'ROSALES', '4524 SOUTHWIND CIRCLE', 'COUNCE', 'TN', '38326', 0);
INSERT INTO MEMBERSHIP VALUES (111, 'STACY', 'MANN', '2789 EAST COOK AVENUE', 'MURFREESBORO', 'TN', '37132', 8);
INSERT INTO MEMBERSHIP VALUES (112, 'LUIS', 'TRUJILLO', '7267 MELVIN AVENUE', 'HEISKELL', 'TN', '37754', 3);
INSERT INTO MEMBERSHIP VALUES (113, 'MINNIE', 'GONZALES', '6430 VASILI DRIVE', 'WILLISTON', 'TN', '38076', 0);
/RENTAL:/
INSERT INTO RENTAL VALUES (1001, '01-MAR-16', 103);
INSERT INTO RENTAL VALUES (1002, '01-MAR-16', 105);
INSERT INTO RENTAL VALUES (1003, '02-MAR-16', 102);
INSERT INTO RENTAL VALUES (1004, '02-MAR-16', 110);
INSERT INTO RENTAL VALUES (1005, '02-MAR-16', 111);
INSERT INTO RENTAL VALUES (1006, '02-MAR-16', 107);
INSERT INTO RENTAL VALUES (1007, '02-MAR-16', 104);
INSERT INTO RENTAL VALUES (1008, '03-MAR-16', 105);
INSERT INTO RENTAL VALUES (1009, '03-MAR-16', 111);
/DETAILRENTAL:/
INSERT INTO DETAILRENTAL VALUES (1001, 34342, 2, '04-MAR-16', '02-MAR-16', NULL);
INSERT INTO DETAILRENTAL VALUES (1001, 34366, 3.5, '04-MAR-16', '02-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1001, 61353, 2, '04-MAR-16', '03-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1002, 59237, 3.5, '04-MAR-16', '04-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1003, 54325, 3.5, '04-MAR-16', '09-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1003, 61369, 2, '06-MAR-16', '09-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1003, 61388, 0, '06-MAR-16', '09-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1004, 34341, 2, '07-MAR-16', '07-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1004, 34367, 3.5, '05-MAR-16', '07-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1004, 44392, 3.5, '05-MAR-16', '07-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1005, 34342, 2, '07-MAR-16', '05-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1005, 44397, 3.5, '05-MAR-16', '05-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1006, 34366, 3.5, '05-MAR-16', '04-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1006, 61367, 2, '07-MAR-16', NULL, 1);
INSERT INTO DETAILRENTAL VALUES (1007, 34368, 3.5, '05-MAR-16', NULL, 3);
INSERT INTO DETAILRENTAL VALUES (1008, 34369, 3.5, '05-MAR-16', '05-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1009, 54324, 3.5, '05-MAR-16', NULL, 3);
/Write the SQL command to save the rows inserted in Problem 47./
COMMIT;

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 02:20

The reset circuit used on the four 3-bit counters analyzed in this activity reset the counts to zero (000). it makes sense for the up-counters to start at zero (000), but the down-counters should start at seven (111). what would you need to change so that the 3-bit binary down counter with j/k flip-flops you just created would reset to seven (111)?

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:50

Define a class named movie. include private fields for the title,year, and name of the director. include three public functions withprototypes void movie: : settitle(cstring); , voidmovie: : setyear(int); , void movie: : setdirector(string); . includeanother function that displays all the information about a movie.write a main() function that declares a movie object namedmyfavoritemovie. set and display the object's fields.this is what i have but know its wrong since it will notcompile: #include#includeusing namespace std; //class declarationclass movie{private: string movietitle ; string movieyear; string directorname; public: void settitle(string title); void setyear(string year); void setdirector(string director); void displayinfo(); }; //class implementationvoid movie: : settitle(string title){ movietitle = title; cout< < "what is the title of themovie? "< > temp; myfavoritemovie.settitle(temp); cout< < "enter movie year"< > temp; myfavoritemovie.setyear(temp); cout< < "enter director'sname"< > temp; myfavoritemovie.setdirector(temp); //display all the data myfavoritemovie.displayinfo(); system("pause"); return 0; this code is not entirely mine someone on cramster edited my firstcode but then i try manipulating the new code and i still get acompile error message : \documents\visual studio 2008\projects\movie\movie\movie.cpp(46) : error c2679: binary '< < ' : no operator found which takes aright-hand operand of type 'std: : string' (or there is no acceptableconversion)c: \program files (x86)\microsoft visual studio9.0\vc\include\ostream(653): could be'std: : basic_ostream< _elem,_traits> & std: : operator< < > (std: : basic_ostream< _elem,_traits> & ,const char *)w

Answers: 1

Answer

Computers and Technology, 23.06.2019 03:30

In vista and windows 7, the appearance and personalization option allows you to change the

Answers: 1

Answer

Computers and Technology, 23.06.2019 07:00

What are three software programs for mobile computing?

Answers: 1

Answer

You know the right answer?

/*PRICE: */ INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);
INSERT INTO PRICE VALUES (2, 'New...