Programming & Computer Science Answers

Consider relation EMPLOYEE. Suppose there are two applications that access EMPLOYEE. The first is issued at four sites and attempts to find the Salary of employee by given their numbers. Assume that we have set the simple predicates for application 1 are P1: Job-Title= PRESIDENT,P2: Job-Title= MANAGER, P3: Job-Title= ANALYST The second application is issued at two sites where the employee with a salary less than 15,00 USD are managed at one site, whereas those with salary grater then 15, 00 USD are managed at a second site. Suppose we set the simple predicates for site 2 are P4: Salary<15,00 USD, P5: Salary>=15,00 USD and P6: Commission= 400.00 USD. 1. Perform a horizontal fragmentation of relation EMP with respect to the predicates above. 2. Explain why the resulting fragments of Employee does not fulfill the correctness rules of fragmentation. 

Dynamic Objects and Run Time Polymorphism

Develop a C++ program for mobile users of prepaid and postpost schemes using pure virtual functions. The mobile detail consists of data members such as mobile vendor and Branch. The prepaid account consists of data members such as prepaid_plan. The current account consists of data members such as postpaid_plan. The member functions are getdetails() and display()

Runtime Input :

Aircel

Chennai

199

499

Output :

Aircel

Chennai

199

499

: Define a class called token number that incorporates a token’s number (could be the last 3 digits of your arid number) and its location. Number each token object as it is created. Use two variables of the angle class to represent the token’s latitude and longitude. A member function of the token class should get a position from the user and store it in the object; another should report the serial number and position. Design a main() program that creates three token, asks the user to input the position of each, and then displays each token’s number and position.

Q.No.3: Define a class called token number that incorporates a token’s number (could be the last 3 digits of your arid number) and its location. Number each token object as it is created. Use two variables of the angle class to represent the token’s latitude and longitude. A member function of the token class should get a position from the user and store it in the object; another should report the serial number and position. Design a main() program that creates three token, asks the user to input the position of each, and then displays each token’s number and position.

Given a sentence S, write a program to print the frequency of each word in S. The output order should correspond with the word's input order of appearance.Input

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

The output contains multiple lines, with each line containing a word and its count separated by ": " with the order of appearance in the given sentence.Explanation

For example, if the given sentence is "Hello world, welcome to python world", the output should be

Hello: 1

world: 2

welcome: 1

to: 1

python: 1

Sample Input 1

Hello world welcome to python world

Sample Output 1

Hello: 1

world: 2

welcome: 1

to: 1

python: 1

Sample Input 2

This is my book

Sample Output 2

This: 1

is: 1

my: 1

book: 1

Please I need exact Output for the above question , i mean a code which satisfies both the above two sample inputs

Compile-time polymorphism using operator overloading

Consider a class distance which stores a distance value using kilometer and meter. Overload the = = operator to check the two distance.

RUNTIME INPUT

3

4

5

6

OUTPUT

not equal

Mr. Hadi sent an email using 01 Gbps network bandwidth which contained a message size of 2.5-KB (Kilobyte) . Mr. John is 802 km away from sender who received email at speed of light travels at 2.4 × 108 m/s. You may need to calculate propagation time and the transmission time for the entire communication, and also discuss the dominant factor in this communication. Draw the figure by labelling all above mentioned values and add screen shot in your answer along with your solution.

Write a C++ program to announce student’s result. Demonstrate this scenario through three classes: Students, Results and Examination. The Student class has data members {1st is roll number and 2nd is name}. Create the class Examination by inheriting the Student class. The Exam class input three subjects Marks out of 100 (OOP, English,Maths). Derive the child class Result from the Exam class and it has its own fields such as total Marks. Based on the total marks students must be declared pass or Fail if the total marks achieved by students equal or greater than 150/300 then only he be declared as Pass. Write an interactive program to model this relationship.

Mr. Hadi sent an email using 01 Gbps network bandwidth which contained a message size of 2.5-KB (Kilobyte) . Mr. John is X km away from sender (where X is last 3 digit of your arid number) who received email at speed of light travels at 2.4 × 108 m/s. You may need to calculate propagation time and the transmission time for the entire communication, and also discuss the dominant factor in this communication. Draw the figure by labelling all above mentioned values and add screen shot in your answer along with your solution.

Reusability using inheritance

Design a pay roll system to find the employee total salary using single inheritance. The base class employee consisting of data members such as emp_number and emp_name. The derived class salary consisting of data members such as Basic_pay, HRA, DA, PF, Net_pay.

run time input

1200

raja

12500

1200

1500

1800

output should

1200

raja

12500

1200

1500

1800

17000