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

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, prayed rakats

table3 -> Person name ,on-time/offtime

table4 -> Person name, time to pray

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: (15 marks) Person Name, Gender , Age, Date, Time, Prayed Rakats, Ontime/Offtime, Time to pray a. Number of...

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:

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: table1 -> Person name, gender, age, date , time table2 -> Person name, prayed rakats table3 -> 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: 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:

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:

Question-1 Marks [10] (a) You are designing a Library Management System and you have the following requirements to design it. Draw a ERD (Entity Relationship Diagram) of the system. Requirement:...

Q:

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

Q:

Distinguish between a reporting study and a descriptive study.

Q:

a. Calculate the z-score for an of 46.5 from a sample of size 35. b. Could this z-score be used in calculating probabilities using Table 3 in Appendix B? Why or why not?

Q:

Given the information below, what is the gross profit? Sales revenue $ 310,000 Accounts receivable 51,000 Ending inventory 119,000 Cost of goods sold 239,000 Sales returns 29,000 Multiple Choice...

Q:

please dont use chat gpt AI 8 5 0

Q:

The chapter notes that the rise in the U.S. trade deficit during the 1980s was due largely to the rise in the U.S. budget deficit. On the other hand, the popular press sometimes claims that the...

Q:

In 1998, the Russian government defaulted on its debt payments, leading investors worldwide to raise their preference for U.S. government bonds, which are considered very safe. What effect do you...

Q:

A case study in the chapter analyzed purchasing-power parity for several countries using the price of Big Macs. Here are data for a few more countries: Predicted Country Big Mac Rate Rate Indonesia...