sql question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

Other Topics

sql question

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-11-08 : 07:49:04

bismark writes "The university bookshop would like to provide an on-line store for staff and students to buy and review books using the campus intranet. A simple prototype with the following functionalities was anticipated:
1. Users should be able to browse through a catalogue and check availability.
2. Staff should use the facility to recommend text books for specific courses.
3. The system should be able to store reviews on books. An underlying relational database is to b produce which can support the above. In addition to the above a submission report consisting of
1.The design specification to support the database.
2. Five unique queries associated sql code plus results and answers.
3.The associated sql code and reults for the list of queries below
A. Find out how many copies of a named book of your choice are in stock.
B.List the title of all recommended books which are not available C. Show the title, price and number of copies of the recommended books for two courses"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-11-08 : 07:52:50

<Robert Duvall> You smell that? DO YOU SMELL THAT? (what?) Homework son, nothing else in the world smells like that. </Robert Duvall>

I'm gonna try and keep an eye out for a good homework icon, if anyone else finds one please post a link to it here or in the Yak Corral.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-11-08 : 08:09:09

I like the way he just pasted the assignment directly. Not even a question, explanation, or some kind of pretense that it was something he was working on.

CODO ERGO SUM

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-08 : 08:12:13

First Create an application that you are supposed to create and if you have any specific doubt on SQL queries ask us

Madhivanan

Failing to plan is Planning to fail

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-11-08 : 08:17:15

http://sns.internetschools.org/~ischools/software/design/icons/
search "homework"

Go with the flow & have fun! Else fight the flow

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-11-08 : 10:13:32

this one's funny

http://www.phil.vt.edu/Valerie/GIFs/homework.GIF

Go with the flow & have fun! Else fight the flow

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-09 : 01:19:03

Thats really funny

Madhivanan

Failing to plan is Planning to fail

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-11-09 : 07:41:36

OK, I've got a few I found online, wondering if we should have an official SQL Team "Homework" icon/pic. Let me know what you think:

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-11-09 : 08:04:06

i vote for 6!

Go with the flow & have fun! Else fight the flow

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-09 : 08:09:43

All are good ones

Madhivanan

Failing to plan is Planning to fail

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-11-13 : 22:20:51

5 & 6 are good candidates...

--------------------
keeping it simple...

angelesronald
Starting Member

4 Posts

Posted - 2005-11-14 : 01:41:51

I go for #6. It is simple. :)

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-11-14 : 03:33:22

No 6 is funny but I also like this one [url]http://www.cccs.k12.in.us/Marengo%20Web%20Page/Classroom%20and%20Staff/Classrooms/LWatts/Kid%20Sites/homework%20icon.jpg[/url]

steve

-----------

Facts are meaningless. You could use facts to prove anything that's even remotely true!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources