Homework Question
Aug 23, 2007How do I create a database, and what's the best color to choose?
View 14 Replies
ADVERTISEMENT
SQL Homework Question
Feb 7, 2008I'm just going to put this....
I have no idea what SQL is and I'm in my 5th week of my into to Sql course.
My teacher is terrible, and I havent learned a thing.
sooo yah...
answer this question if you like...you'll be doing a good deed for me ;)
Here's the question:
Name 2 examples of digital or electronic databases, one which is a relational database, and one that isn’t.
For each of your examples:
a.
Describe the thing or topics that the database is about.
b.
Give the location of the database e.g. provide the URL for databases available on the Web.
c.
Explain in detail why the database is or isn’t a relational database.
I really don't expect any replies, but hey its worth a try!
Stuck With A Homework Question...
Mar 7, 2007Hey guys, I am stuck on a homework question and I was hoping someone could help point me in the right direction.
the question is:
"find the book code and book title for each book whose price is greater than the book price of every book that has the type HOR"
now, I know how to find the book price of every book that has the type HOR but how do i minimize the results to show all books that have greater prices that the HOR books?
Hey I've Got A Homework Problem I'm Working On And Am Stumped.
Aug 10, 2006It goes like the following:Use AdventureWorks database and HumanResources.Department table.Create a stored procedure called spDepartmentAddUpdate. This procedureaccepts two parameters: Name, and GroupName. The data types areVarChar(50), and VarChar(50) respectively. Define logic in thisprocedure to check for an existing Department record with the same Name.If the department record exists, update the GroupName and ModifiedDate.Otherwise, insert a new department record.A.Execute your stored procedure to show that the insert logic works.B.Execute your stored procedure to show that the update logic works.Any hints from the wizards out there would be greatly appreciated!*** Sent via Developersdex http://www.developersdex.com ***
View 6 Replies View Related