Search & Filtering
IPL
A win earns a team 3 points. A draw earns 1. A loss earns 0.
The following information is expected:
MP: Matches Played
W: Matches Won
D: Matches Drawn (Tied)
L: Matches Lost
P: Points
The team information should be displayed in descending order of points.Input
Each of those lines has information on the T1, T2) which played and the outcome (O) in format T1;T2;O.
The outcome (O) is one of 'win', 'loss', 'draw' and refers to the first team listed.
See Sample Input/Output for better understanding.
CSK, Matches Played: 4, Won: 2, Lost: 1, Draw: 1, Points: 7' for each team in a new line.
If there are no teams to print in summary, print "No Output".
Constraints
Names of teams may contain spaces but will be less than 24 characters
100 >= N >= 0
Sample Input
6
CSK;RR;loss
RR;DD;draw
MI;KKR;win
KKR;RR;loss
CSK;DD;draw
MI;DD;draw
Sample Output
Team: RR, Matches Played: 3, Won: 2, Lost: 0, Draw: 1, Points: 7
Team: MI, Matches Played: 2, Won: 1, Lost: 0, Draw: 1, Points: 4
number is negative then increment it by 3 and multiply the result by 4, however if it’s a positive
number then decrement by 4 and multiply it by 3.
a) Create a flowchart to be followed to solve the above task
b) Create a java program using your flowchart and see samples below
Sample run 1:
Enter a whole number: 4
Output: The Number 4 is above zero hence,
Result of the calculations = 0
Sample run 2:
Enter a whole number: -5
Output: The Number -5 is below zero hence,
Result of the calculations = -8
In March 2020, COVID-19 was declared a pandemic. As a result, businesses and schools were closing,
cities and countries were locking down. No one knew what the next day would bring or how this global
crisis would impact all of us—physically, emotionally, or financially. COVID-19 has impacted small
businesses in different ways, and many have re-invented or re-launched their products and services
to reach new markets and take advantage of new opportunities. The COVID-19 pandemic has changed
our way of living. Businesses and work have moved online.
A client has approached you to create a website specific to their business. This website will serve as a
way of marketing their business, attracting clients and allowing them to make queries. The client
wants the website to keep track of users by storing their details for survey and marketing purposes.
The client requests that the website should have a database to keep track of these users.
2.3 Given the relations R (A, B) and S (B, C) where values are all integers. Examine the undermentioned three relational algebra expressions: a. A, C(R⋈B=1S) b. A(B = 1R)XC(B = 1S) c. A, C (ARXB = 1S) Two of the three expressions are equivalent (i.e., they produce the same answer on all databases), while one of them can produce a different answer.
2.3.1 Which query can produce a contrasting answer? Give the simplest database instance you can think of where a different answer is produced. (5)
2.3.2 Why do we care that the expressions are equivalent? (5)
2.3.3 How can we determine that the expressions are equivalent?
Input
The first line contains a single integer M.
Next M lines contain two integers Pi, Ci separated with space, where Pi denotes power and Ci denotes co-efficient of Pi for polynomial A.
After that next line contains a single integer N. Next N lines contain two integers Pj, Cj separated with space, where
Pj denotes power and Cj denotes co-efficient of Pj for polynomial B.
Output
Print the addition of polynomials A and B.
The format for printing polynomials is: Cix^Pi + Ci-1x^Pi-1 + ... + C1x + CO, where Pi's are powers in decreasing order, Ci is co-efficient and CO is constant, there will be space before and after the plus or
minus sign. If co-efficient is zero then don't print the term. If the term with highest degree is negative, the term should be
represented as -Cix^Pi. For the term where power is 1 represent it as C1x instead of C1x^1. If the degree of polynomial is zero and the constant term is also zero, then just print 0 to represent the polynomial.
2.1 Assuming the following relations from a customer database, write relational algebra expression for each statement using symbolic notations. Customer (cid, cname, rating, salary) Item (iid, iname, type) Order (cid, iid, day, qty)
2.1.1 Find the names of customers who have ordered item with id 087. (2)
2.1.2 Find the names of customers who have ordered a television i.e., an item of type television.
2.2 Use information on MYSQL student_reg table to login making sure you are using proper credentials.
2.3 Register button should take the user to a new page that allows them to register if they are not registered in the system.
2.4 If student’s credentials do not match the one in the database when trying to login, the page should display login error message and only three attempts are permitted before the user is kicked out of the system for 30 minutes
Designing a Web site for a company called Nkwali Yenkosi that designs and sells leather clothing and accessories. The Web site must have 5 Web pages (Home, About the leather, DIY Methods, Brick & Mortar and Shop Now). Create the Shop Now Web page and 2 Web pages connecting to it.
a) The Web page should be titled Shop Now. The navigation bar includes
images of 3 social media which are links to the different social media
pages. The Nkwali Yenkosi logo. The link to the Hamburger style
navigation.
b) The Hamburger style navigation should contain all the links to the 5 web
pages.
c) when user scrolls down, they should see the Shop Now! Heading and the
different clothing items they can shop, with the prices and the icon to
click on to buy the item
d) user clicks on the icon to buy a pop box will appear which will allow them to
select how many items they want to buy. It should calculate accordingly.
e) clicks check out. They should be redirected to the Checkout page, where they need to fill in information.
You are part of the Web development Team, currently designing a Web site for A company called Nkwali Yenkosi that designs and sells leather clothing and accessories. The Web site is made up of 5 Web pages (Home, About the leather, DIY Methods, Brick & Mortar and Shop Now). You are responsible for creating the Shop Now Web page and 2 Web pages connecting to it. You must follow the following instructions to complete the Shop Now Web page, use the Assets folder provided for resources such as images required and font family to be used. a) The Web page should be titled Shop Now. The navigation bar includes images of 3 social media which are links to the different social media pages. The Nkwali Yenkosi logo. The link to the Hamburger style navigation and the landing page should look as illustrated below:
Secret Message - 2
Given a string, write a program to print a secret message that replaces characters with numbers 'a' with 1, 'b' with 2, ..., 'z' with 26 where characters are separated by '-'.
You need to replace both uppercase and lowercase characters. You can ignore replacing all characters that are not letters.
abcdefghij12345678910
klmnopqr1112131415161718
stuvwxyz1920212223242526
The input will be a string in the single line containing spaces and letters (both uppercase and lowercase).Output
The output should be a single line containing the secret message. All characters in the output should be in lower case.
For example, if the given input is "python", "p" should replaced with "16", similarly"y" with "25","t" with "20","h" with "8","o" with "15","n" with "14". So the output should be "16-25-20-8-15-14".
Sample Input 1
python
Sample Output 1
16-25-20-8-15-14
