reset password
Author Message
harry_520
Posts: 76
Posted 21:08 Oct 30, 2013 |

Dr, Sun, are you going to ask for FDs, and determine either BCNF or 3NF on the midterm?

Last edited by harry_520 at 21:08 Oct 30, 2013.
cysun
Posts: 2935
Posted 21:09 Oct 30, 2013 |

Maybe.
 

xytian
Posts: 70
Posted 20:49 Oct 31, 2013 |

About the grading criteria: such as in the sample midterm 3, (a) Write a stored function round_to_grade() (b) Use the function round_to_grade() to write a query

part (a) takes a lot of time to debug. In case we fail to make (a) work, should we skip doing part (b) or do we still get credit for the query?

 

cysun
Posts: 2935
Posted 22:02 Oct 31, 2013 |
megtian wrote:

About the grading criteria: such as in the sample midterm 3, (a) Write a stored function round_to_grade() (b) Use the function round_to_grade() to write a query

part (a) takes a lot of time to debug. In case we fail to make (a) work, should we skip doing part (b) or do we still get credit for the query?

You'll get credit for the query, but the query is only worth 5pt.

xytian
Posts: 70
Posted 20:50 Nov 01, 2013 |

For question 3(b) in the sample midterm, while calculating the average grade points (value) a professor gave, do we need to take into account the units of different sections?

Last edited by xytian at 20:50 Nov 01, 2013.
xytian
Posts: 70
Posted 21:08 Nov 01, 2013 |

and one more question: what grade is considered a passing grade, is D- count? Thanks

cysun
Posts: 2935
Posted 21:48 Nov 01, 2013 |
megtian wrote:

For question 3(b) in the sample midterm, while calculating the average grade points (value) a professor gave, do we need to take into account the units of different sections?

No.

cysun
Posts: 2935
Posted 21:48 Nov 01, 2013 |
megtian wrote:

and one more question: what grade is considered a passing grade, is D- count? Thanks

C or above for letter grading, and CR for credit/no credit.

harry_520
Posts: 76
Posted 00:06 Nov 02, 2013 |

For the first query question, should I return the result in integer or decimal? And, how do I do the conversion for the counted numbers?

cysun
Posts: 2935
Posted 08:31 Nov 02, 2013 |
harry_520 wrote:

For the first query question, should I return the result in integer or decimal? And, how do I do the conversion for the counted numbers?

Whatever avg() returns.

xytian
Posts: 70
Posted 11:00 Nov 02, 2013 |

For questions like 3(b), which asks to list names and aggregation results

do I need to consider the situation when names have duplicates, i.e., different IDs might have the same same? 

xytian
Posts: 70
Posted 11:34 Nov 02, 2013 |

Also, do we weed to handle the inexact math, e.x.,

for query "select value from grades where value>=0.7", it only shows result above 1

I can only get the correct output by using "select value from grades where value>=0.69"

cysun
Posts: 2935
Posted 23:50 Nov 02, 2013 |
megtian wrote:

For questions like 3(b), which asks to list names and aggregation results

do I need to consider the situation when names have duplicates, i.e., different IDs might have the same same? 

No.

cysun
Posts: 2935
Posted 23:52 Nov 02, 2013 |
megtian wrote:

Also, do we weed to handle the inexact math, e.x.,

for query "select value from grades where value>=0.7", it only shows result above 1

I can only get the correct output by using "select value from grades where value>=0.69"

It's not really important. Either way is fine.

xytian
Posts: 70
Posted 07:46 Nov 03, 2013 |

When declaring a row variable in the procedure, can we use "record" type instead of tablename%rowtype? They seem to return the same results.

Last edited by xytian at 07:48 Nov 03, 2013.
cysun
Posts: 2935
Posted 08:21 Nov 03, 2013 |
megtian wrote:

When declaring a row variable in the procedure, can we use "record" type instead of tablename%rowtype? They seem to return the same results.

It's fine, as long as you know how the RECORD type works.