Forum: Database Design Apr 13th, 2009 |
| Replies: 1 Views: 875 It depends!
Why you need to save user searches or you don't intend to?
please tell me more about your scenarios what you need to keep track on and so on; to guide you to good design. |
Forum: Database Design Feb 24th, 2009 |
| Replies: 1 Views: 1,024 Read that http://en.wikipedia.org/wiki/Boyce-Codd_normal_form
And if any part is not understood, tell me to clarify. |
Forum: Database Design Feb 10th, 2009 |
| Replies: 3 Views: 647 It done by +1000 ways, I presented outline, you can ask in web-development forum. |
Forum: Database Design Feb 10th, 2009 |
| Replies: 3 Views: 960 |
Forum: Database Design Feb 8th, 2009 |
| Replies: 1 Views: 598 User table has recursive relationship because SuperAdmin, Admin and user (I think you understand me)
There's column in User table links to Type of user (RoleMst) SuperAdmin, Admin, User, etc... |
Forum: Database Design Feb 7th, 2009 |
| Replies: 3 Views: 647 You merge logic or business of your application and the design of the database, you don't need to modify the design if you correctly did it, rather in application check the new friends list in a... |
Forum: Database Design Feb 7th, 2009 |
| Replies: 4 Views: 857 Database language or Database software?
Database language would be mainly ANSI-SQL and you can use Microsoft Access or Microsoft SQL Server. |
Forum: Database Design Feb 6th, 2009 |
| Replies: 4 Views: 857 You can connect from JavaScript to database, and validate user credentials, if has permission you can from JavaScript redirect him to the Flash page! |
Forum: Database Design Feb 6th, 2009 |
| Replies: 3 Views: 567 - Please use check spelling feature in MS Word or any software provides this feature before posting any question.
- Where's your effort? Ancient Dragon, he may use SQL Server Express edition it's... |
Forum: Database Design Feb 6th, 2009 |
| Replies: 1 Views: 684 Your design isn't correct! sorry for that but the description would be attribute in Instruments table and would be nullable because there're some instruments haven't description! |
Forum: Database Design Feb 6th, 2009 |
| Replies: 1 Views: 597 We don't solve assignments.
Show us your approaches to solve this problem! |
Forum: Database Design Jan 31st, 2009 |
| Replies: 3 Views: 960 Dataset in Microsoft .NET framework. |
Forum: Database Design Jan 25th, 2009 |
| Replies: 2 Views: 761 separate Exhibition and Art tables, I think the relation should be many-to-many so you need to use bridge table |
Forum: Database Design Jan 25th, 2009 |
| Replies: 9 Views: 1,783 I am very thankful to your words, really you prove for me, there still long way I should cut to become really skilled DBA\BI\Software Engineer.
Your words is more valuable than any reply I got in my... |
Forum: Database Design Jan 25th, 2009 |
| Replies: 9 Views: 1,783 So, what do you think about my design? |
Forum: Database Design Jan 25th, 2009 |
| Replies: 3 Views: 638 You didn't normalize you DB design, you need to have table for Crane, Manager, Country, Region and Site. |
Forum: Database Design Jan 25th, 2009 |
| Replies: 3 Views: 699 I think your ERD fulfills your requirements but it's not clear, if you work with team to develop this application try to brainstorm the design of ERD |
Forum: Database Design Jan 21st, 2009 |
| Replies: 9 Views: 1,783 You really really really need it, tell me why because if you don't attach it and make the three columns primary key you enforced just 2 employees can work 2 or 4 times with each other? how come and... |
Forum: Database Design Jan 21st, 2009 |
| Replies: 9 Views: 1,783 You should have table called tbl_work (ID_EMP1 #, ID_EMP2 #) that's if you need to restrict 2 employees work together more than 4 times. Actually I don't understand you well but I'll give solution to... |
Forum: Database Design Jan 21st, 2009 |
| Replies: 3 Views: 699 So, show us your ERD I am bit lost in the description. |
Forum: Database Design Jan 11th, 2009 |
| Replies: 2 Views: 852 I've attached my draft...if anything not clear reply... |
Forum: Database Design Jan 7th, 2009 |
| Replies: 2 Views: 612 1- Rename your entites may we can expect the relation and imagine the design....
2- Attach yours to let us help you better. |
Forum: Database Design Jan 7th, 2009 |
| Replies: 1 Views: 731 Send me your ideas, any draft you did, show me your effort to show you my help. |
Forum: Database Design Jan 7th, 2009 |
| Replies: 2 Views: 2,471 Look I am not involved with this topic so much, and I see you're not someone come to ask and take an answer rather you want to discuss, so let's start
I see EER: is pretty used in complex database... |
Forum: Database Design Jan 5th, 2009 |
| Replies: 2 Views: 3,639 Dear, if you've time to read I can send you a book about Data warehouse.
About your questions
Say we've business man who has super market with a lot of branches...
The business man interested to... |
Forum: Database Design Jan 4th, 2009 |
| Replies: 6 Views: 895 So, relation is One-To-Many
One Question has many Answers and Answer has many Comments
So...
Question(QID, QSubject, QText,....)
Answer(AID, QID, AText,......)
Comment(CID, AID, CText,.....)
... |
Forum: Database Design Jan 4th, 2009 |
| Replies: 1 Views: 532 It's not the place friend :) go to VB forum and ask there. |
Forum: Database Design Jan 1st, 2009 |
| Replies: 1 Views: 1,440 Break the many-to-many relationship into one-to-many and many-to-one
Which means?
create a bridge table Employee_Company (EmployeeID int #, CompanyID int #, Salary float, .....)
Bridge table... |
Forum: Database Design Dec 30th, 2008 |
| Replies: 4 Views: 1,357 [User] table still the same
[Rating] table has (Voter_Member int #, Voted_Member int #, Rating int)
- Composed primary keys (to maintain user can't de\vote user two times)
- Rating int (if you... |
Forum: Database Design Dec 30th, 2008 |
| Replies: 4 Views: 1,357 User is Member?! or each another entity!! |
Forum: Database Design Sep 13th, 2007 |
| Replies: 3 Views: 2,396 why many-to-many, when some subContactor leaves the team, update it with the new one (ID) -- One-to-many.
if you want to keep track on the subContactors you should use many-to-many but keep in you... |
Forum: Database Design Sep 13th, 2007 |
| Replies: 7 Views: 2,689 Grant select, insert to [username] --for all tables
Grant select, insert on [table name] to [username] -- for specific table
Grant Create database, table to [username] -- give some permission to... |