Programming & Computer Science Answers

1. Create a SQLite database for Places‐of‐Interests (POI) 2. Apply the CRUD concept using Python‘s function (def) 3. Test each of your CRUD functions with the following use case: a. Create the appropriate table with it‘s table structure,  b. Populate 20 POIs into the table c. Get the latest row in the table d. Retrieve all POI data e. Update several POI data f. Delete two POI records g. Undo the deletion record proces

Square at Alternate Indices

Given an array

myArray of numbers, write a function to square the alternate numbers of the myArray, starting from index 0 using the array method map.Input

• The input will be a single line containing an array myArray

Output

• The output should be a single line containing an array with alternate numbers squared

Constraints

• Each value in the array must be a number

Sample Input 1

[ 1, 2, 3, 4, 5 ]

Sample Output 1

[ 1, 2, 9, 4, 25 ]

Sample Input 2

[ 2, 4 ]

Sample Output 2

[ 4, 4 ]

String Slicing

Given two strings

inputString and subString as inputs, write a JS program to slice the inputString if it includes the subString. Slice the inputString starting from the subString to the end of the inputString.Input

• The first line of input contains a string inputString
• The second line of input contains a string subString

Output

• The output should be a sliced string or inputString (if the inputString does not include the subString)

Sample Input 1

JavaScript

S

Sample Output 1

Script

Sample Input 2

Language

air

Sample Output 2

Language

String Ending with Vowel

Given an array of vowels in the prefilled code and a string

inputString as an input, write a JS program to check whether the inputString ends with a vowel.

Quick Tip

You can use the string methods toUpperCase() and endsWith().

Input

• The input will be a single line containing a string inputString

Output

• The output should be a single line containing a boolean value

Sample Input 1

Five

Sample Output 1

true

Sample Input 2

Apples grow best where there is cold in winter

Sample Output 2

false

Series of Operations

Given an array

1. myArray of numbers, write a JS program to perform the following steps and log the result. Multiply each value with 9.
2. Subtract 20 from each value.
3. Multiply each value with 7.
4. Log the values of the resulting array separated by a space.

Input

• The input will be a single line containing an array myArray

Output

• The output should be a single line with values separated by a space

Constraints

• Each value in the array must be a number

Sample Input

[ 12, 2, 2, 4, 1 ]

Sample Output

616 -14 -14 112 -77

Provide a detailed hardware specification for the computer system to be sourced

for John. The hardware specification should centre around the main components

common to all computer systems and should specify details such as make, model,

cost, power or capacity and supplier.

Provide a detailed hardware specification for the computer system to be sourced

for John. The hardware specification should centre around the main components

common to all computer systems and should specify details such as make, model,

cost, power or capacity and supplier.

Create a class GeometricShape including

• A pure virtual function named show() is create in GeometricShape class

Derive a class Rectangle from class GeometricShape including

• data members for length and width of rectangle,

• respective mutator and accessor functions to set and get values of length and width.

• overriding function computeArea() to compute area of rectangle (length x width)

• overriding function show() to display details associated with instance of class Rectangle.

From Rectangle class, derive a class Cuboid containing

• a data field height in addition to length and width,

• two functions setHeight and getHeight() to set and get value of height data field.

• overriding function computeArea() to calculate the area of a cuboid (length x width x height)

• overriding function show() to display the details associated with an instance of class Cuboid.

In main function, create instance of derived classes to access respective show() function using dynamic binding.

Railway management system project with 4 classes

Create a class named Person, which contains

• A pure virtual function named print()

• Two data fields i.e. personName and age

A class named Student inherits Person class, which contains

• Two data fields i.e. Std_id and Cgpa

• Overridden function print() to display all details relevant to a patient

A class named Regular inherited from class Student which holds

• A data field representing the name of School

• A data filed representing the Fee

• Overridden function print() to display all details relevant to a Regular student

A class named Private inherited from class Student which holds

• A data field representing the address

• A data filed representing the Fee

• Overridden function print() to display all details relevant to a private Student.

In the main function, create instances of derived classes to access respective print() function using dynamic binding.