View Forum Topic

Forums
CS122
HW 2 wording issue/How do we get in touch with Tarik?

Author	Message
aaleman11 Posts: 42	Posted 20:51 Jan 16, 2015 \| So I'm having an issue understanding Question 3 on Part Two on the new homework assignment Tarik posted. 3)Write a CASE Statement for Titles. If a title is "alternative" , "metal", "r&b" or "rap" display "Loud". For "Classical", "jazz" or "pop" display "Easy". Put this info in a column named "Listening" When you look under the Titles database, only a few of those genres are listed because only six tracks appear. But if you look under the Genre database, all those genres are there. So the confusing part of this is: do we make a case statement for Titles as the question asks or were we supposed to make a case statement for Genres? Also, I wanted to ask Tarik himself but he has no contact info. How do we get a hold of him when I have questions like this? It's Friday night and if I'm not having fun, he shouldn't be having fun either! (Just kidding. But seriously, where he at?!?!)
tbooker Posts: 20	Posted 22:16 Jan 16, 2015 \| Follow the instructions as the question requires. Show all info in the titles table with the appropriate CASE statement. Add those cases even if they're not in the existing table. Post questions to the forum in the future. I'll add my contact info to the syllabus. -Tarik Booker

Author

Message

aaleman11

Posts: 42

Posted 20:51 Jan 16, 2015 |

So I'm having an issue understanding Question 3 on Part Two on the new homework assignment Tarik posted.

3)Write a CASE Statement for Titles.
If a title is "alternative" , "metal", "r&b" or "rap" display "Loud". For "Classical", "jazz" or "pop" display "Easy".

Put this info in a column named "Listening"

When you look under the Titles database, only a few of those genres are listed because only six tracks appear. But if you look under the Genre database, all those genres are there. So the confusing part of this is: do we make a case statement for Titles as the question asks or were we supposed to make a case statement for Genres?

Also, I wanted to ask Tarik himself but he has no contact info. How do we get a hold of him when I have questions like this? It's Friday night and if I'm not having fun, he shouldn't be having fun either! (Just kidding. But seriously, where he at?!?!)

tbooker

Posts: 20

Posted 22:16 Jan 16, 2015 |

Follow the instructions as the question requires. Show all info in the titles table with the appropriate CASE statement.

Add those cases even if they're not in the existing table.

Post questions to the forum in the future. I'll add my contact info to the syllabus.

-Tarik Booker