May 14, 2010 at 12:17 am
Please help me to desgin table structure for tracking data
I have centralized library project in which I have following hierarchy
Tables:- User(EMployee), Region,Library,Book Type,Books,BookFields
Users are assigned regions
Region can have branches of library
Library has books and arranges according to Book Types
Library needs to maintain and generate performance report for users(employees). Which user has brouht which book at what date, purchase bill no, how many books of that name.
A Library in particular Region is allowed to keep particular type of Book Type; According to book type we will have books in that library. We need to keep track of which User has brought which book in particular library of region. More that one user could bring book and can mak entry in project. Along with Received date other attributes also need to track like Purchase date etc. But Attributes number is dependent on Book Type. For some Book Type we need its retailer name from which it is purchased for other it may not needed. So the list of attributes to be tracked is not fixed for book type. Some attributes may get added later for which we need to keep provision and which will not affect current design. We also need to track which user has brought how many books.
and generate his performance report.
May 14, 2010 at 6:09 am
Either this is school homework or you got into a consulting project you have no clue how to deliver.
In the first case you should make some effort and we will be glad in pointing your nose in the right direction.
In the second case better to hire a DBA with data modeling experience and use this project as a learning experience.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 17, 2010 at 10:25 pm
Thanks for your reply.
Sorry for the late reply.
I am working on this project as consultant(.NET web developer). I do not have an option of taking services from DBA. I have to design the db on my own. I have designed the database in two ways on horizontally and one vertically. But as client needs in short time. I am not left with much time for R & D. So I need someone who has already done this kind of stuff and help me develope db which will have less maintenance in future.
Thanks again for quick reply.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply