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
 General SQL Server Forums
 New to SQL Server Programming
 Please Help.

Author  Topic 

r0663664
Starting Member

1 Post

Posted - 2009-04-22 : 22:52:03
Hi everyone,

I learnt SQL very long time ago but I have an job interview that required to answer some SQL. Can anyone help me?

V. Case study:
Consider a company with one library and many employees. The library has many titles and each title has many copies. Please come out with Relational Database Management System design to help the librarian tracking which employee borrows which books in certain period of time if one employee can borrow many books at a time.

What are the appropriate SQL scripts to extract the data of which employees borrow which books between January 1st, 2005 and April 1st, 2005?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-23 : 00:13:29
Show us what you have tried so far.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

aprichard
Yak Posting Veteran

62 Posts

Posted - 2009-04-23 : 03:23:22
Try to post table structure with sample data what you have tried till now
Go to Top of Page
   

- Advertisement -