Programming & Computer Science Answers

. Explain using an example how you would covert subtype/supertype relationships to relations in database design. 

Luthando Housing is a company that specializes in real estate business. It's properties are managed by sales representatives. Each sales representatives is allocated to at least one property to market and sell to prospective customers. After a trading month, these sales representatives receive their salaries as follows

Gross salary

Commission (2% of the sold property)

Less PAYE (12% of gross pay)

Less UIF (3% of gross pay)

Write a C++ program that calculates the net salary that each sales representative receives. The program should allow the user to input the gross salary and sales then output the net salary

All Possible Subsets

Given a sentence as input, print all the unique combinations of the words of the sentence, considering different possible number of words each time (from one word to N unique words in lexicographical order).Input

The input will be a single line containing a sentence.Output

The output should be multiple lines, each line containing the unique combination from one word to N words in lexicographical order.Explanation

For example, if the given sentence is "apple is a fruit".

All possible one-word unique combinations are

a
apple
fruit
is

All possible two words unique combinations are

a apple
a fruit
a is
apple fruit
apple is
fruit is

All possible three words unique combinations are

a apple fruit
a apple is
a fruit is
apple fruit is

All possible four words unique combinations are

a apple fruit is

In the below-mentioned example, there is an EMP Table having records of EMP_NAME, EMP_NO, SALARY, MANAGER_ Dep.

Now, you have to perform the following operations by using the commands INSERT INTO, DELETE, UPDATE and SELECT in detailed SQL code by following the main steps:

⦁ Firstly, you insert the data by using the command INSERT INTO.

⦁ Then, you have to update the SALARY record of Saqib by 80,000 to 85,000 by using the command UPDATE.

⦁ Finally, and delete the record of Shahid from the table by using the command DELETE.

EMP_NAME EMP_NO SALARY MANAGER_ Dep

Haseeb 1 70,000 Marketing

Saqib 11 80,000 Accounts

Shiraz 12 65,000 HR

Shahid 13 80,000 Supply chain

Consider a situation that a user wants to print first n (any value, e.g. first 10) numbers of Fibonacci series. You need to implement a program that gets a number from user and prints first n Fibonacci series numbers. Write a function for this purpose that prints Fibonacci series recursively. This function should accept a number in parameter and then print n number of elements of Fibonacci series.

Write a class “Circle” with one data member radius. Write three member functions as follows

o set_radius() that accepts a value in parameter and assigns to radius

o get_area() that calculate and return area

o get_circum() that calculate and return circumference

The program should create two objects of class and input radius for these objects. The program should display area for first object and circumference for second object.

Write a program to create a student structure that stores four (4) student data such as:

i. Name

ii. Gender

iii. Matrix number

iv. Student age

*Refer the output below:

STUDENT 1

ENTER STUDENT NAME: AMINAH BINTI ABU

ENTER STUDENT GENDER: FEMALE

ENTER MATRIC NUMBER: 01DDT090

ENTER STUDENT AGE: 20

STUDENT 2

ENTER STUDENT NAME: BORHAN BIN BAHAR

ENTER STUDENT GENDER: MALE

ENTER MATRIC NUMBER: 01DDT091

ENTER STUDENT AGE: 30

STUDENT 3

ENTER STUDENT NAME: JESICA A/P JOHN

ENTER STUDENT GENDER: FEMALE

ENTER MATRIC NUMBER: 001DTK890

ENTER STUDENT AGE: 21 STUDENT 4

ENTER STUDENT NAME: BEH CHAI WONG

ENTER STUDENT GENDER: MALE

ENTER MATRIC NUMBER: 01DEE789

ENTER STUDENT AGE: 25

Write a program to create a student structure that stores four (4) student data such as:

i. Name

ii. Gender

iii. Matrix number

iv. Student age

*Refer the output below:

STUDENT 1

ENTER STUDENT NAME: AMINAH BINTI ABU

ENTER STUDENT GENDER: FEMALE

ENTER MATRIC NUMBER: 01DDT090

ENTER STUDENT AGE: 20

STUDENT 2

ENTER STUDENT NAME: BORHAN BIN BAHAR

ENTER STUDENT GENDER: MALE

ENTER MATRIC NUMBER: 01DDT091

ENTER STUDENT AGE: 30

STUDENT 3

ENTER STUDENT NAME: JESICA A/P JOHN

ENTER STUDENT GENDER: FEMALE

ENTER MATRIC NUMBER: 001DTK890

ENTER STUDENT AGE: 21 STUDENT 4

ENTER STUDENT NAME: BEH CHAI WONG

ENTER STUDENT GENDER: MALE

ENTER MATRIC NUMBER: 01DEE789

ENTER STUDENT AGE: 25

Write a program that accept the string, removes all empty space in the string, and replace all character ‘a’ to ‘A’ by display a new string. The program needs to write using array.

*Refer the output below:

Type your Story:

aminah works as a medical assistant at HRPB. She performed her duties as a dedicated frontliner throughout the covid19 outbreak. #stayathome. #staysafe.

Display a new string:

AminahworksAsAmedicalAssistantAtHRPB.SheperformedherdutiesAsAdedicAted frontlinerthroughoutthecovid19outbreAk.#stAyAthome.#stAysAfe.

You have decided to enter a model boat race. You put your boat at the start line next to your 

best friend Jill’s boat. Create a program to print out the distance that both of your boats 

travelled given the speed your boat travels in (feet per minute), the speed that Jill’s boat 

travels and the number of minutes in the race. 

Distance = speed * time 

Use the following as your sample Data: 

speedMe = 6.2 

speedJill = 5.9 

time = 2 

distanceMe = speedMe * time = 6.2 * 2 = 12.4 

distanceJill = speedJill * time = 5.9 * 2