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

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

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:

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:

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: (15 marks) Table 1 ------Person name, gender , age, date and time Table 2 ------Person name, prayed Rakats...

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:

****Note: u have to make draft of salat management system for performing these queries**** Answer the following as SQL queries. Also write corresponding relational algebra expression: (15 marks) a....

Q:

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

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:

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: The normalized form will look like, table1 -> Person name, gender, age, date , time table2 -> Person name,...

Q:

Find the AM1 geometries and dipole moments of the two conformers of formic acid and compare with HF results (Prob. 15.57). Also find the AM1 difference in Hf ,298 for these conformers.

Q:

You are an analyst at Bank of Ireland. You have identified a way in which you can use customer data to inform customers of bank offers and offers from other vendors, based on their credit card...

Q:

Two key concepts that you should remember when borrowing are the finance charge and the annual percentage rate.

Q:

How much money would you have to deposit in an account today in order to have $17,500 in the account in 14 years? The account pays interest at 4.5% compounded annually.

Q:

B In an effort to quell the uprisings in Egypt in 2011, the Egyptian government blocked citizens access to the Internet, yet protests continued. What does this say about the pervasive nature of...

Q:

A What role did group communication play in this scenario? Might cliques have been involved? What were other communication options?

Q:

B Is it unethical to attempt to gain Merediths vote even if you honestly believe that its in the best interest of the group?