Question: table1 -> Person name, gender, age, date , time table2 -> Person name, prayed rakats table3 -> Person name ,on-time/offtime table4 -> Person name, time

table1 -> Person name, gender, age, date ,

time table2 -> Person name, prayed rakats

table3 -> Person name ,on-time/offtime

table4 -> Person name, time to pray

Question 9:-Answer the following as SQL queries. Also write corresponding relational algebra expression:

a. Number of rakats prayed as Qaza by each person

b. How many females have skipped fajar salah on 1st shawwal

c. How many salah are missed by Mr. Noman

d. Average time M. Noman takes for praying Isha Salah

e. Which salah is missed mostly by M. Saleem

f. Which salah is missed the second most by all people

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Answer the following as SQL queries. Also write corresponding relational algebra expression: The normalized form will look like, table1 -> Person name, gender, age, date , time table2 -> Person name,...

Q:

Answer the following as SQL queries. Also write corresponding relational algebra expression: table1 -> Person name, gender, age, date , time table2 -> Person name, prayed rakats table3 -> Person name...

Q:

Q.4. Answer the following as SQL queries. Also write corresponding relational algebra expression: (15 marks) normalized form will look like table1 -> Person name, gender, age, date , time table2 ->...

Q:

Answer the following as SQL queries. Also write corresponding relational algebra expression: table1 -> Person name, gender, age, date , time table2 -> Person name, prayed rakats table3 -> Person name...

Q:

Write relational algebra expressions : a. Number of Rakats prayed as Qaza by each person b. How many females have skipped fajar salah on 1st shawwal c. How many salah are missed by Mr. Noman d....

Q:

Q.4. Answer the following as SQL queries. Also write corresponding relational algebra expression: a. Number of rakats prayed as Qaza by each person b. How many females have skipped fajar salah on 1st...

Q:

Answer the following as SQL queries. Also write corresponding relational algebra expression: (15 marks) Table 1 ------Person name, gender , age, date and time Table 2 ------Person name, prayed Rakats...

Q:

Fact Find Initial Interview: Time Date Location Referred by: A. Personal Details Applicant 1 Applicant 2 Full Name of Applicant Full Name of Applicant Mr Mrs Miss OMS Dr Mr Mrs Miss OMs Dr Full Name...

Q:

Question 11 pts How would a "pure" risk best be described? Group of answer choices Winning at the poker tables in Las Vegas Experiencing a loss in the stock market Losing some pay from work because...

Q:

ASSESSMENT TASKS - ASSIGNMENT 1 Page 2 ASSIGNMENT 1 Task Using the information contained in the Scenario below, please complete the following 6 tasks. You must complete each task for your submission...

Q:

Transaction analysisvarious accounts. Enter the following column headings across the top of a sheet of paper: Enter the transaction/adjustment letter in the first column and show the effect, if any,...

Q:

About 100 million pounds of jelly beans are consumed in the United States each year, and the price has been about 50 cents per pound. However, jelly bean producers feel that their incomes are too low...

Q:

Knowledge Check Activity 1 - Rocky Springs Beverage Company has two departments, Blending and Bottling. - The Bottling Department received 5 7 , 0 0 0 liters from the Blending Department. - During...

Q:

Rockets Corpus financed by stock and bonds. Currently, the stock is worth $10 milhon in equity and their bonds are worth $6 million. If their cout of quis 19. the cost of debt ist, and their tax...

Q:

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Q:

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

Q:

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...