Question: 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

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 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 Note: Please don't Copy paste i need a proper answer with explanations and relational algebra expression for all don't skip any of them. Thanks Extra Inofrmation: Salat Management System tables information: Person Name, Gender , Age, Date, Time, Prayed Rakats, Ontime/Offtime, Time to pray table1 -> Person name, gender, age, date , time table2 -> Person name, prayed rakats table3 -> Person name ,on-time/offtime table4 -> Person name, time to pray

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.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.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.4. Answer the following as SQL queries. Also write corresponding relational algebra expression: (15 marks) Person Name, Gender , Age, Date, Time, Prayed Rakats, Ontime/Offtime, Time to pray a....

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

READ THE WHOLE QUESTION ANSWER ACCORDINGLY. ANSWER THE COMPLETE QUESTION OR YOU WILL GET A DISLIKE. . Answer the following as SQL queries. Also write corresponding relational algebra expression: a....

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...

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,...

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...

Answer the following as SQL queries. Also write corresponding relational algebra expression: (15 marks) Person Name, Gender , Age, Date, Time, Prayed Rakats, Ontime/Offtime, Time to pray a. Number of...

For each of the following, find a (piecewise) smooth parametrization of C and compute C F Tds. a) C is the curve y = x2 from (1, 1) to (3, 9), and F(x, y) = (xy, y - x). b) C is the intersection of...

The bills of materials for two finished products (D and E), inventory status, and other relevant information are given below. Compute the planned order releases and projected on-hand balances for...

In which of the following listings of citric acid cycle intermediates are the compounds listed in the order in which they are encountered in a turn of the cycle? citrate, oxaloacetate, fumarate...

please answer as it teaches in the book need to study SMITH COMPUTER CENTER To assist you in recording these transactions for the month of January, at the end of this problem is the schedule of...

1. Interview a relative or friend who is currently employed. The interview should a. Identify her current career development stage. b. Identify a special career management challenge she faces. c....

7. How could you help downsized survivors remain motivated and productive? Rank your recommendations in order of importance. Provide a rationale for your ranking.

6. Why should managers be trained as part of establishing supportive work-life policies?