Programming & Computer Science Answers

a) Using the Google Meet platform as a practical example, discuss how it would be categorized under this course and discussing its different components and their purposes

Railway Management System

The Main aim of the Railway

Management Mini DBMS project is

to ease the process of railway

reservation. We aim to

demonstrate the use of create,

read, update and delete MySQL

operations through this project. In

this project, we first add the details

of trains and their halting stations.

Then passengers can book a ticket

by adding their details, source and

Destination. Passenger module

shows the number of passengers

boarding to the station. Trains and

Stations can be added or deleted

and the train details can be

updated for changing the timing on

arrival and departure or just

increasing or decreasing the

amount for tickets based on

classes such as 2A,3B,etc.

b) Consider the employee data. Give an expression in SQL for the following query:

Employee (employeeName, street, city)

Works (employeeName, companyName, salary)

Company (companyName, city)

Manages (employeeName, managerName)

 i)Find the name and cities of residence of all employees who work for Bangladesh Bank.

 ii)Find all employee in the database who do not work for Bangladesh Bank.

 iii) Find all employee in the database who earn more than every employee of UCB bank.

a) Write SQL commands

 1. To create the above table structure with proper constraints.

 2. Select all the PROG type published by BPB from Library. 

 3. Display a list of all books with Price more than 130 and sorted by Qty.

 4. Display all the books sorted by Price in Ascending Order. 

 5. Display a report. Listing Book No. current value and misplacement charges for each book in the above 

table. Calculate the misplacement charges for all books Price*1.25

 6. Count the number of books published by PHI 

 7. Insert a new book in the library. 

 8. Count the no of books in each Type. 

 9. Add one more attribute “No_of_copies” in the above table. 

 10. Update the new attribute value with 2 for each book.

 11. Count the total number of Publishers.

Question 1

a) Using the AIT website as a case study, discuss the difference(s) between a Domain Name and an IP Address, indicating their purpose/usage, and how they work together when accessing the AIT website.

b) With a practical example, discuss how a CSS (Cascading Style Sheet) file could be used in Wordpress and for what purpose.

c) With practical examples, discuss the difference(s) between the Internet and the World Wide Web, and also discussing the difference(s) between the main protocols used in each.

Question 2

a) Using the AIT website and Lemass as examples, discuss their difference(s) in terms of how they could be categorized, why they have different Domain Names and on different Name Servers in the Domain Name System and how accessing each is made possible.

b) With a practical example, explain how a Search Engine operates.

c) Explain why, for example, you would go in for Wordpress as compared to Joomla and Drupal for web authoring and content management.

John has n sweets which are to be distributed equally to m kids. Design the flowchart such that it also prints number of sweets each kid gets and the remaining sweets with John

4. A Java interface can only contain method signatures and fields. The interface can be used 

to achieve polymorphism. In this problem, you will practice your knowledge on interfaces.

You are given an interface AdvancedArithmetic which contains a method signature int 

divisor_sum(int n). You need to write a class called MyCalculator which implements the 

interface.

divisorSum method just takes an integer as input and return the sum of all its divisors. For 

example divisors of 6 are 1, 2, 3 and 6, so divisor_sum should return 12. The value of n will be 

at most 1000.

When a subclass inherits from a superclass, it also inherits its methods; however, it can 

also override the superclass methods (as well as declare and implement new ones). Consider 

the following Sports class:

class Sports{

 String getName(){

 return "Generic Sports";

 }

 void getNumberOfTeamMembers(){

 System.out.println( "Each team has n players in " + getName() );

 }

}

Next, we create a Soccer class that inherits from the Sports class. We can override the 

getName method and return a different, subclass-specific string:

class Soccer extends Sports{

 @Override

 String getName(){

 return "Soccer Class";

 }

}

Each team has 11 players in Soccer Class

Finish the Teacher constructor. Use super to use the Person constructor to set the fields 

inherited from Person. It should print “Destini 20” followed by “Erica 55 Masters in Teaching”.

public class Person

{

 private String name;

 private int age;

 public Person(String name, int age)

 {

 this.name = name;

 this.age = age;

 }

 public String getName() { return this.name; }

 public int getAge() { return this.age; }

 public String toString()

 {

 return getName() + " " + getAge();

 }

 public static void main(String[] args)

 {

 Person p = new Person("Destini", 20);

 System.out.println(p);

 Teacher p2 = new Teacher("Erica", 55, "Masters in Teaching");

 System.out.println(p2);

 }

}

class Teacher extends Person

{

 String degree;

 public String getDegree() { return this.degree; }

 public String toString()

{

 return getName() + " " + getAge() + " " + getDegree();

 }

 public Teacher(String name, int age, String theDegree)

 {

 // ADD CODE HERE

 }

}