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.
| Author |
Topic |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-01-18 : 09:54:23
|
| Hi EveryonePlease have look of my questions and give me answers soon.At home, I have a collection of CDs on which I stored movies that I ripped from my neighbor’s video rental shop. My friends are very envious of my collection and they regularly ask me to borrow them a movie for a few days. My problem is that I fear to lose titles of my precious collection. I know that my friend, as nice as they may be, will conveniently forget to return my CDs. So I have decided that I need a database to manage my CDs.1. how to Design this database.2. i want an SQL query to will return the names of all my friends who ever borrowed the movie “Titanic”.2. i want SQL query that will list the names of my friends who are current borrowing one or more CDs and the number of days since the borrowed it..Reply soon, its kind of urgentWaiting for reply.Warmest regards,ASIF |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-01-18 : 15:08:17
|
| That is called Video Piracy and is a punishable offense. I wouldn't broadcast the fact that you are intentionally breaking the law. I love the idea that making it easier to break the law is "urgent" and that you not only wish to violate the anti Piracy laws and "steal" videos, you want to steal our time instead of just doing the simple legwork necessary to learn some basic SQL commands. I'm sure your friend with the video shop loves the idea that you are also robbing him by then passing on your copies to your other friends instead of recommending that they go to his rental shop. Don't tell me let me guess .... "you are going to steal your companies computer resources to store all of this personal information on." And the topper is you are trying to do all of this tracking to ensure that none of your friends "keeps"/"steals" one of your CD's. Because if it is taken from you that is "stealing" but when you are robbing others it is just "saving you some money" ... right? |
 |
|
|
|
|
|
design database and sql query