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

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

Please read below before answering, this is for your reference!

Salah is another word for Prayer

Salah Time is Prayer Time

Salah Date is Prayer Date

1st Shawwal is the First Day of the Islamic Month

Person Name is Primary

Isha Salah is Isha Prayer Time

Fajr Salah is Fajr Prayer Time

Qaza is OffTime Prayer

Missed Salah Time is just a Missed Prayer Time.

There are 5 prayers in a Day (Fajr [morning prayer], Zuhr [Noon Prayer], Asr [After Noon Prayer], Maghrib [Evening Prayer], Isha[Night Prayer])

If a prayer time is missed it can be offered at another time and counts as Qaza Prayer which is OffTime Prayer.

Hopefully that is all the data you need to answer this.

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!

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

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

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

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

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

How many 20-digit quaternary (0, 1, 2, 3) sequences are there where: (a) There is at least one 2 and an odd number of 0's? (b) No symbol occurs exactly twice? (c) No symbol occurs exactly three...

Both Oracle Corporation and Cisco Systems' are in the computer industry. The data that follows (in millions) are from the end of their fiscal years 2011. Compare the payables turnover and days...

You want to retire and have $ 7 3 0 0 0 0 in your retirement account exactly 3 2 years from today. You will make annual deposits at the end of each year to fund his retirement account. If you can...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. For many years General Electric (GE) has been recognized as one of the worlds most admired companies. Visit GEs Web site at www.gecareers.com and click on Why GE and then Leadership & Learning...

1. Go to the American Society for Training and Development (ASTD) home page on the World Wide Web. The address is www.astd.org. Investigate the links on the home page. One link is to T D magazine....

12. Explain how training relates to attracting new employees, employee retention, and motivation.