Question: Write corresponding relational algebra expression: ( a. Number of rakats prayed as Qaza by each person b. How many females have skipped fajar salah on
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
SQL queries
a)select distinct(Person name ) from table2 where prayed rakats ="Qaza";
b) SELECT COUNT (name) from female where question1=Null
c) SELECT Count(SALAH) From SALAH WHERE follow=false
d) select AVG(time) from prayer where name ="M.Noman"
e) SELECT name from slalah where repetation=max
f) select name from salah where repetation
You have to give relational algebra expressions for the first six parts of the question.
I attached SQL Queries just to ensure if this is correct or not ?
If it is wrong then please send Correct SQL Queries + Algebric Expressions.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
