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 |
|
hari_81
Starting Member
3 Posts |
 Posted - 2007-12-27 : 10:14:20
|
| Hii, I am harish here..I want to develop Library management systemusing windows forms in C# and i want to design that database tables for that.How can i go about that..? I also want to develop stored procedures through sql queries for any specific scenario.Can u just tell me any scenario for which i can build the query.harish. Harish.R |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2007-12-27 : 10:42:29
|
| Hi Harish! Listen, the answer to your question could fill an entire 4 year college ciriculum. You need to be waaay more specific in your question to get a meaninfull answer in a forum.Have any requirements been written for this project yet? You will first need a detailed understanding of all the things this system will do. Until you have that it doesn't make sense to start creating objects and writing code. Since we don't know the requirements we can't possible advise you.Be One with the OptimizerTG |
 |
|
|
hari_81
Starting Member
3 Posts |
Posted - 2007-12-30 : 02:09:17
|
Hii TG, I also know that i have asked the question which is verygeneral.I am working as software engineer with C#.I want to develop some application for my self learning purpose with asp.net. So,i thought i can develop Library Management system.This is the GIST:The readership in Bangalore is falling these days. The primary reason of this is due to the fact that the accessibility of such lending libraries where people can get in and borrow books. These days quite a lot of people have easy access to the internet and hook on to the internet in viewing/reading books/articles in their living room rather than going to the libraries. This affects the functioning of such lending libraries to attract people to get in to the library, pick up book for specific period and go through the lending cycle. Vision· To provide the readers an opportunity to have access to all books available always at their convenience at easily affordable cost. · To provide the readers the choice of accessing the books/articles of their interest according to the latest trend· To provide the readers with variety of information by way of books/videos which will help them regain the habit of reading which they are looking for otherwise from other sources like television etc. You should come up with a detailed solution approach, user scenarios, design and then develop the application. How can i go about this....?Apart from this,i have specific question to ask u.I want to improve myself in DataBase Side(Sql queries)what i should do for that.Kindly,help me on this regard.Harish.quote:
Originally posted by TG
Hi Harish! Listen, the answer to your question could fill an entire 4 year college ciriculum. You need to be waaay more specific in your question to get a meaninfull answer in a forum.Have any requirements been written for this project yet? You will first need a detailed understanding of all the things this system will do. Until you have that it doesn't make sense to start creating objects and writing code. Since we don't know the requirements we can't possible advise you.Be One with the OptimizerTG
Harish.R |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2007-12-30 : 10:17:58
|
| >>You should come up with a detailed solution approach, user scenarios, design and then develop the application. >>How can i go about this....?I'm sure there is a documented, step by step approach - but what I usually do is:- Start with writing use cases (specific examples of what a user will do with the system) I believe this step is critical for making sure you have all your bases covered. The use cases can later be used for development, and testing of the system.- next, baesd on the use cases create mock screens for any form or page the user will see.- then you can start to develop a "logical database model". this will basically define all the entities, business rules, and logical keys needed to support your design.- the phisical database model can then be developed.>>I want to improve >>myself in DataBase Side(Sql queries)what i should do for that.Get a book and start reading and going through (actually coding the) sample lessons. Sql Server Books Online is free and has everything you need to not only get started but can support you no matter how far you advance.Keep looking at sqlteam.com questions and try to understand the problems and solutions offered.Be One with the OptimizerTG |
|
|
|
|
|
|
|
|
Database design