Search Results

Showing results 1 to 34 of 34
Search took 0.01 seconds.
Search: Posts Made By: Ramy Mahrous ; Forum: Database Design and child forums
Forum: Database Design Apr 13th, 2009
Replies: 1
Views: 875
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
Go to Java forum!!
Forum: Database Design Feb 8th, 2009
Replies: 1
Views: 598
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
- 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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
We don't solve assignments.
Show us your approaches to solve this problem!
Forum: Database Design Jan 31st, 2009
Replies: 3
Views: 960
Posted By Ramy Mahrous
Dataset in Microsoft .NET framework.
Forum: Database Design Jan 25th, 2009
Replies: 2
Views: 761
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
Forum: Database Design Jan 25th, 2009
Replies: 3
Views: 638
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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 23rd, 2009
Replies: 9
Views: 1,783
Posted By Ramy Mahrous
Forum: Database Design Jan 21st, 2009
Replies: 9
Views: 1,783
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
So, show us your ERD I am bit lost in the description.
Forum: Database Design Jan 11th, 2009
Replies: 2
Views: 852
Posted By Ramy Mahrous
I've attached my draft...if anything not clear reply...
Forum: Database Design Jan 7th, 2009
Replies: 2
Views: 612
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
Forum: Database Design Jan 4th, 2009
Replies: 6
Views: 895
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
It's not the place friend :) go to VB forum and ask there.
Forum: Database Design Jan 1st, 2009
Replies: 1
Views: 1,440
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
[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
Posted By Ramy Mahrous
User is Member?! or each another entity!!
Forum: Database Design Sep 13th, 2007
Replies: 3
Views: 2,396
Posted By Ramy Mahrous
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
Posted By Ramy Mahrous
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...
Showing results 1 to 34 of 34

 


About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC