Questions
Print out the following output. You must use exactly 2 for statements, 2 range statements, and...

Print out the following output. You must use exactly 2 for statements, 2 range statements, and 3 print statements. (python)

Calculating x **

1

1

3

5

====

Calculating x ** 2

1

9

25

====

Calculating x ** 3

1

27

125

====

In: Computer Science

Implement the Cstring function strcpy(dest, source) in c++. Do not use the library. The copy process...

Implement the Cstring function strcpy(dest, source) in c++. Do not use the library. The copy process will only stop at the last "\0". Make sure dest is large enough

In: Computer Science

Can anyone add a validation function to my html? First, ensure that your form uses at...

Can anyone add a validation function to my html? First, ensure that your form uses at least three of the following field types: check boxes, text boxes, option buttons, selection lists, and text areas. Then, program validation for your form ensuring that users enter values or make selections in all fields, and verifying at least one other aspect of at least one of the fields. Provide appropriate feedback to users when the form fails validation. Test your completed program until all validation works reliably with different combinations of valid and erroneous data.

<------------------------------------------------------------------------------------------------------->

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Case Project</title>
<link href="layout.css" rel="stylesheet" type="text/css">
</head>
<body>
<h1>Lamborghini</h1>
<p><a href='index.html'>Lamborghini</a> <a href='ferrari.html'>Ferrari</a> <a href='bugatti.html'>Bugatti</a> <a href='rollsroyce.html'>Rolls-Royce</a></p>
<hr>
<p><img src='https://vignette.wikia.nocookie.net/pawnstarsthegame/images/6/6e/2003_Lamborghini_Murcielago.png'>The Aventador has been created to anticipate the future, as demonstrated by the use of innovative technology, including a V12 engine and the extensive use of carbon fiber. The authentic design masterpieces together stark dynamism with aggression to produce a cutting edge carbon fiber monocoque. The interior of the Aventador combines high-level technology and luxury equipment with premium-quality materials, skilfully crafted with the expertise characteristic of the finest Italian traditions. A supercar family that has already become a legend in its own right. Discover technical specifications, dimensions, performance, and the detailed features of all the new Lamborghini Aventador models.</p>
  

</script>
</body>
</html>

In: Computer Science

Sorting (selection, bubble, insertion) Suppose an array contains the following integers: -1, 20, 10, -5, 0,...

Sorting (selection, bubble, insertion)

Suppose an array contains the following integers: -1, 20, 10, -5, 0, -7, 100, -7, 30, -10. Sort the array using the following algorithms: selection sort, bubble sort, and insertion sort. For each algorithm, write the array content after each pass (i.e., from pass 1 to pass 9). Each pass is defined as one iteration of the outer loop. There are total of n − 1 passes, where n is the array size.


The answer should not be Java or code

In: Computer Science

PYTHON PROGRAM! Exercise 3 - Go forth and discover! Find some interesting good sized text datasets...

PYTHON PROGRAM!

Exercise 3 - Go forth and discover!

Find some interesting good sized text datasets (most likely csv's) of at least several hundred points online. These could be related to any topic. Some ideas might be:

  • COVID-19 statistics or science
  • Wildlife populations
  • Cost vs. strength of building materials
  • Solar Power generation
  • etc . . .

Use Python to import one of those datasets and provide at least 2 useful visualizations (charts) of that data on a single figure. You may use any chart type that would be useful, and you can certainly pre-process or analyze the data (i.e. see filtering to fires > 500 acres in Ex. 2) before plotting it. Make sure to label the charts appropriately.

In: Computer Science

Write assembly code for the following C procedure: i = 1; sum = 0; while (i...

Write assembly code for the following C procedure:

i = 1; sum = 0;

while (i ≤ n) {

sum += i;

++i;

}

i and sum corresponds to $s1 and $s2. n is preloaded into $s3

In: Computer Science

write three functions in C++: one that declares a large array statically, one that declares the...

write three functions in C++: one that declares a large array statically, one that declares the same array on the stack, and one that creates the same array on the heap. Call each of them a number of times (at least 100,000) and output the time required by each. Explain the results.

In: Computer Science

Q. 3 [35 pts] Print out the following output. You must use exactly 2 for statements,...

Q. 3 [35 pts] Print out the following output.

You must use exactly 2 for statements, 2 range statements, and 3 print statements. No modules are to be used for this problem.

Calculating x ** 1
1
3
5
====
Calculating x ** 2
1
9
25
====
Calculating x ** 3
1
27
125
====

In: Computer Science

Java - In this lab, you will be writing your own method using the brute force...

Java - In this lab, you will be writing your own method using the brute force algorithm, to solve a second degree polynomial.
This method will take in four parameters, three coefficients, and one constant, and it will have the following signature:

public static String bruteForceEquationSolver(int one, int two, int three, int constant){}

The equation you are trying to solve is of the following format, given the parameters stated above:

(constant) = (one) * x + (two) * y + (three) * z

X, Y, and Z are variables that you are finding solutions for.

For example, if you were to call the method with parameters (2, 3, 4, 42), you would be finding the solution for the equation 2x + 3y + 4z = 42.

Some specifications for the method:

  • Your method should try every possibility within the range (1-10) for each variable. Check possibilities using nested for loops, starting with x, then y, then z.

  • Your method should return if a solution is found, and return a string with the solutions in the following format:

    x: xSolution y: ySolution z: zSolution

    There should be a space between the solution and the next variable, and each variable letter should be followed by a colon and a space.

  • If no solution is found, return the string “Solution not found.”.

Call the testBFES() method from main after completing this method to ensure it is working as expected.

Here's what I have so far:

public static String bruteForceEquationSolver(int one, int two, int three, int constant) {
    // student code here
        for (int i = 1; i <= 10; i++) {
            for (int j = 1; j <= 10; j++) {
                for (int k = 1; k <= 10; k++) {
                }
            }
        }
        return String.format("x:%d y:%d z:%d", one, two, three); 
}
public static void testBFES() {
System.out.println("Testing Brute Force Equation Solver");
String expected = "x: 2 y: 3 z: 4";
System.out.println("Expecting: " + expected);

String actual = bruteForceEquationSolver(3, 4, 6, 42);
System.out.println("Actual: " + actual);

boolean correct = expected.equals(actual);
System.out.println("Outputs equal? " + correct);
}

public static void testMT() {
System.out.println("Testing Multiplication Table");

String expected = "1\t2\t3\t4\t\n2\t4\t6\t8\t\n3\t6\t9\t12\t\n";
System.out.print("Expecting:\n" + expected);

String actual = multiplicationTable(3, 4);
System.out.print("Actual:\n" + actual);

boolean correct = expected.equals(actual);
System.out.println("Outputs equal? " + correct);
}

In: Computer Science

doing some research on Google or Bing for Hotel TV remote control systems .  List your sources....

doing some research on Google or Bing for Hotel TV remote control systems .  List your sources. Be sure to answer all the questions listed below

Discuss each of the following:
1. What does the device do?
2. What data does the device store, manage, or transmit?
3. How valuable is the data?
4. How could an intruder get this data?
5. What harm would result if the intruder succeeded in getting the data or in controlling the device?

In: Computer Science

1. For this question, assume a simple programming language (SPL) has been designed to write a...

1. For this question, assume a simple programming language (SPL) has been designed to write a straight-line program (SLP). Programs written in this simple programming language, such as the sample program P1 shown below, allow the implementation of only statements and expressions, but no loops or if-statements. Note the print function will take an expression list as its arguments.


       Program P1:
           a := 2 + 5; b := (print (a, a-1), 7 * a) ; print (b)
      

Execution of this program will yield output
                       7 6

49


a.) What is the grammar being used to specify the syntax of this language?

b.) What is a concrete syntax of the program? (Hint: parse tree)

In: Computer Science

Implement the following in Classless IP Addressing in C programming using decimal number system (a) Compute...

Implement the following in Classless IP Addressing in C programming using decimal number system (a) Compute First Address, Last address and Number of address from given IP address and mask. Input is given by the user

In: Computer Science

Write a program of linked list in which in which element can be inserted only at...

Write a program of linked list in which in which element can be inserted only at the end of the linked list and deletion can also take place at the end.

Code needed in java.

In: Computer Science

                                     SPOOL output.log DROP TABLE Customers

                                     SPOOL output.log


DROP TABLE Customers CASCADE CONSTRAINT;

DROP TABLE Orders CASCADE CONSTRAINT;

DROP TABLE Products CASCADE CONSTRAINT;

DROP TABLE Distributors CASCADE CONSTRAINT;

DROP TABLE Catalogs CASCADE CONSTRAINT;

DROP TABLE Rentals CASCADE CONSTRAINT;

CREATE TABLE Customers (
Customer_id NUMBER(10) NOT NULL,
CustomerFirst_name VARCHAR(20) NOT NULL,
CustomerLast_name VARCHAR(20) NOT NULL,
CustomerStreet_address VARCHAR(30) NOT NULL,
CostumerCity VARCHAR(20) NOT NULL,
CustomerState CHAR(2) NOT NULL,
CostumerZip VARCHAR(9) NOT NULL,
CustomerPhone_number VARCHAR(12) NOT NULL,
CONSTRAINT Customer_PK PRIMARY KEY (Customer_id));

--Customers
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState,
CostumerZip, CustomerPhone_number) VALUES ('100', 'Ben', 'Bill', '201 Ash Street', 'San Silva', 'MD', '20850', '443-123-4567');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState, CostumerZip,
CustomerPhone_number) VALUES ('101', 'James', 'Seth', '142 Athens Avenue', 'Silver Boro', 'MD', '20841', '443-230-4444');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState,
CostumerZip, CustomerPhone_number) VALUES ('200', 'Victor', 'Jones', '124 Flower Street', 'Rockville','MD', '20857', '301-547-2036');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState, CostumerZip,
CustomerPhone_number) VALUES ('300', 'Ashley', 'Maverick', '105 University Boulevard', 'Baltimore', 'MD', '21593', '228-567-8174');
INSERT INTO Customers (Customer_id, CustomerFirst_name, CustomerLast_name, CustomerStreet_address, CostumerCity, CustomerState, CostumerZip,
CustomerPhone_number) VALUES ('450', 'Bill','Booker', '208 New Hampshire Avenue', 'Wheaton', 'MD', '20103', '250-413-7020');


CREATE TABLE Orders(
Order_id NUMBER(10) NOT NULL,
OrderDate DATE DEFAULT SYSDATE,
CONSTRAINT Order_PK PRIMARY KEY (Order_id));

-- Order
INSERT INTO Orders (Order_id, OrderDate) VALUES ('1', TO_DATE('02/05/2007','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate) VALUES ('2', TO_DATE('2/20/2011','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate) VALUES ('3', TO_DATE('02/05/2003','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate) VALUES ('4', TO_DATE('02/05/2005','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('5', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('6', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('7', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('8', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('9', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('10', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('11', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('12', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('13', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('14', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('15', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('15', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('16', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('17', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('18', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('19', TO_DATE('02/05/2006','MM/DD/YYYY'));
INSERT INTO Orders (Order_id, OrderDate)VALUES ('20', TO_DATE('02/05/2006','MM/DD/YYYY'));

CREATE TABLE Products (
Product_id NUMBER(10) NOT NULL CONSTRAINT Product_PK PRIMARY KEY,
ProductDescription VARCHAR2(50),
ProductMovieType varchar(11),
Order_id NUMBER(10) NOT NULL
CONSTRAINT Product_FK REFERENCES Orders (Order_id));

-- Product
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('1', 'Beauty and the Beast', 'Romance','6');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('2', 'Mist', 'Thriller','7');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('3', 'Police Academy', 'Comedy','8');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('5', 'When Sally met Harry', 'Romance','9');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('6', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('7', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('8', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('9', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('10', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('11', 'Rambo', 'Action','10');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('12', 'Beauty and the Beast', 'Romance','6');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('13', 'Mist', 'Thriller','7');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('14', 'Police Academy', 'Comedy','8');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('15', 'When Sally met Harry', 'Romance','9');
INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('16', 'Rambo', 'Action','10');

CREATE TABLE Distributors (
DistributorDisc_id NUMBER(11,0) NOT NULL,
DistributorPrice NUMBER(11,0) NOT NULL,
DistributorOrderQuantity NUMBER(11),
Order_id NUMBER(10) NOT NULL,
CONSTRAINT Distributor_PK PRIMARY KEY (DistributorDisc_id) ,
CONSTRAINT Distributor_FK FOREIGN KEY (Order_id) REFERENCES Orders (Order_id));

-- Distributor
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('1', '5','10', '11');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('2', '5','10', '12');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('3', '15','10','13');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('4', '5','10', '14');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('5', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('6', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('7', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('8', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('9', '5','10', '15');
INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('10', '5','10', '15');

CREATE TABLE Catalogs (
Catalog_id NUMBER(5,0) NOT NULL,
CatalogRating VARCHAR(10) NOT NULL,
CatalogAcademyAwards VARCHAR(50) NOT NULL,
CatalogDateReleased DATE DEFAULT SYSDATE,
Product_id NUMBER(10) NOT NULL,
Order_id NUMBER(10) NOT NULL,
DistributorDisc_id NUMBER(11,0) NOT NULL,
CONSTRAINT Catalog_PK1 PRIMARY KEY (Catalog_id),
CONSTRAINT Catalog_FK1 FOREIGN KEY (Order_id) REFERENCES Orders (Order_id),
CONSTRAINT Catalog_FK2 FOREIGN KEY (Product_id) REFERENCES Products (Product_id),
CONSTRAINT Catalog_FK3 FOREIGN KEY (DistributorDisc_id) REFERENCES Distributors (DistributorDisc_id));

-- Catalog
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('1', 'Rated R','2',TO_DATE('02/05/2000','MM/DD/YYYY'),'7','16','6');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('2', 'Parental Guide', '12', TO_DATE('02/05/2001','MM/DD/YYYY'),'8','17','7');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('3', 'Youth','3',TO_DATE('02/05/2002','MM/DD/YYYY'), '9','18','8');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('4', 'Everyone','8', TO_DATE('02/05/2003','MM/DD/YYYY'),'10','19','9');
INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
VALUES ('5', 'Preschool','9',TO_DATE('02/05/2004','MM/DD/YYYY'),'11','20','10');


CREATE TABLE Rentals(
Rental_id NUMBER(9) NOT NULL,
RentalReturnDate DATE DEFAULT SYSDATE,
RentalRentedQuantity VARCHAR(2) NOT NULL,
RentalTotal_charge NUMBER(19,4) NOT NULL,
RentalTax NUMBER(19,4) NOT NULL,
Product_id NUMBER(10) NOT NULL,
CONSTRAINT Rental_PK PRIMARY KEY(Rental_id),
CONSTRAINT Rental_FK FOREIGN KEY(Product_id) REFERENCES Products(Product_id));
-- Rental
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('1', TO_DATE('04/05/2009','MM/DD/YYYY'), '35','17.99', '0.3','11');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('2', TO_DATE('03/04/2001','MM/DD/YYYY'), '34','17.99', '0.3','12');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('3', TO_DATE('04/03/2002','MM/DD/YYYY'), '33','17.99', '0.3','13');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('4', TO_DATE('04/01/2003','MM/DD/YYYY'), '32','17.99', '0.3','14');
INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
VALUES ('5', TO_DATE('04/03/2004','MM/DD/YYYY'), '31','17.99', '0.3','15');

SPOOL OFF;

Error message

             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('1', 'Beauty and the Beast', 'Romance','6')
                                                                                                                        *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('2', 'Mist', 'Thriller','7')
                                                                                                        *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('3', 'Police Academy', 'Comedy','8')
                                                                                                                  *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('5', 'When Sally met Harry', 'Romance','9')
                                                                                                                        *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('6', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('7', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('8', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('9', 'Rambo', 'Action','10')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('10', 'Rambo', 'Action','10')
                                                                                                          *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('11', 'Rambo', 'Action','10')
                                                                                                          *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('12', 'Beauty and the Beast', 'Romance','6')
                                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('13', 'Mist', 'Thriller','7')
                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('14', 'Police Academy', 'Comedy','8')
                                                                                                                   *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('15', 'When Sally met Harry', 'Romance','9')
                                                                                                                         *
ERROR at line 1:
ORA-01722: invalid number


INSERT INTO Products (Product_id, ProductDescription, ProductMovieType, Order_id) VALUES ('16', 'Rambo', 'Action','10')
                                                                                                          *
ERROR at line 1:
ORA-01722: invalid number


CREATE TABLE Distributors (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('1', '5','10', '11')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('2', '5','10', '12')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('3', '15','10','13')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('4', '5','10', '14')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('5', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('6', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('7', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('8', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('9', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


INSERT INTO Distributors (DistributorDisc_id, DistributorPrice, DistributorOrderQuantity, Order_id) VALUES ('10', '5','10', '15')
*
ERROR at line 1:
ORA-00001: unique constraint (CM320P17.DISTRIBUTOR_PK) violated


CREATE TABLE Catalogs (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found


INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found


INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found


INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found


INSERT INTO Catalogs (Catalog_id,CatalogAcademyAwards,CatalogRating, CatalogDateReleased, Product_id, Order_id, DistributorDisc_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.CATALOG_FK2) violated - parent key
not found


CREATE TABLE Rentals(
              *
ERROR at line 1:
ORA-00955: name is already used by an existing object


INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found


INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found


INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found


INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found


INSERT INTO Rentals (Rental_id, RentalReturnDate, RentalRentedQuantity, RentalTotal_charge, RentalTax, Product_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (CM320P17.RENTAL_FK) violated - parent key not
found

In: Computer Science

**Please don't use handwriting **Please don't copy and paste use your own word Q1:What are the...

**Please don't use handwriting
**Please don't copy and paste use your own word


Q1:What are the roles of a project sponsor and the approval committee during the different SDLC phases?


Part 2:

Assume the following scenario:

A small company needs to develop an information system for the Finance and Accounting Department. As an analyst which process model would you prefer and why?



Part 3:There are three techniques which help users discover their needs for the new system, list and compare these techniques in terms of impactful changes. Also, explain BPR.

In: Computer Science

Subjects