| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|
12-24-11, 12:40
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
db
|
|
Design a database for developing the following system.
1. The details of various resource persons contacted for various events at institute are to be stored at a central database by the respective coordinators from their respective places.
2. There should be facility to change the details if required.
3. A facility to view the resource persons details in some order (like technical experts, management experts, communication skills experts, etc).
4. A facility to view the details in different orders (gender wise, year wise, events wise, etc).
5. Sending e-cards to the resource person on their birthdays, new year, etc.
could any one one help me out??
plzzzz
|
|
12-24-11, 13:07
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,538
|
|
Quote:
Originally Posted by raiyeee
could any one one help me out??
plzzzz
|
of course
what was your question?
|
|
12-24-11, 13:13
|
|
Jaded Developer
|
|
Join Date: Nov 2004
Location: out on a limb
Posts: 9,263
|
|
|
|
certainly
try:
Google
I'm sure one of these could meet your requirements
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton 
|
|
12-25-11, 08:36
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
database design
Design a database for developing the following system.
1. The details of various resource persons contacted for various events at institute are to be stored at a central database by the respective coordinators from their respective places.
2. There should be facility to change the details if required.
3. A facility to view the resource persons details in some order (like technical experts, management experts, communication skills experts, etc).
4. A facility to view the details in different orders (gender wise, year wise, events wise, etc).
5. Sending e-cards to the resource person on their birthdays, new year, etc.
|
|
12-25-11, 08:39
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,538
|
|
Quote:
Originally Posted by raiyeee
Design a database for developing the following system.
|
this looks exactly like post #1 in this thread
reposting the homework assignment is ~not~ going to induce anyone to do the work for you
how about you try to do it yourself, post what you come up with, and then ask if you have a specific question
|
|
12-25-11, 08:46
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
db
hi...
i want to design the database...
in order to design the database
1.we need to gather the information
2.draw the E-R diagrams
3.convert E-R diagrams to relational model..
and finally this must be in a normalized form...
is it correct??
or is there any extra information to follow in order to design a database??
|
Last edited by raiyeee; 12-25-11 at 08:57.
|
12-25-11, 09:36
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,538
|
|
yes, that's correct
"gather the information" seems to be complete, i.e. it's the assignment as you posted it, right?
okay, so you're on step 2, draw the ER diagram
|
|
12-25-11, 13:03
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
db
|
12-25-11, 13:11
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,538
|
|
|
|
12-26-11, 13:11
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
db
hi..
i hv a doubt...can anyone plz tel me??
what is the use of associative entity...??
whn to use this??
and
can an entity hv 2 relationships??
and those two relationships can relates single entity??
|
|
12-26-11, 14:39
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,538
|
|
what is the use of associative entity...??
to associate other entities in a complex relationship
whn to use this??
whenever you want to associate entities in a complex relationship
can an entity hv 2 relationships??
yes
and those two relationships can relates single entity??
yes
aren't you glad we cleared that up, eh 
|
|
12-27-11, 06:52
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
db
sry..iam not cleared with that answer....
can u plz gv me the example ..whn and where to use associative entity??
is associative entity itself relation and entity??
|
Last edited by raiyeee; 12-27-11 at 07:00.
|
12-27-11, 09:22
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
hi
Hi Everybody,
Today, Some one asked me this question. I just made myself to say him back. But i was not satisfied with my answer. Now i am asking the same question here. I hope i will get proper response for this question. India has a large number of engineers and scientists graduating every year. There is a concern of lack of exposure to local problems and technological innovation to solve them. What would you say to solve this issue? What role can the corporate sector play to help drive solve local technological problems? What is your opinion about?
|
|
12-27-11, 10:38
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,538
|
|
Quote:
Originally Posted by raiyeee
can u plz gv me the example ..whn and where to use associative entity??
|
Code:
CREATE TABLE one_entity
( id INTEGER NOT NULL PRIMARY KEY
, foo VARCHAR(9) NOT NULL
);
CREATE TABLE two_entity
( id INTEGER NOT NULL PRIMARY KEY
, bar VARCHAR(37) NOT NULL
);
CREATE TABLE one_two_associative_entity
( one_id INTEGER NOT NULL
, two_id INTEGER NOT NULL
, FOREIGN KEY ( one_id ) REFERENCES one_entity ( id )
, FOREIGN KEY ( two_id ) REFERENCES two_entity ( id )
, PRIMARY KEY ( one_id, two_id )
, INDEX buckle_my_shoe ( two_id, one_id )
, startdate DATETIME NOT NULL
);
|
|
12-27-11, 11:14
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 8
|
|
|
db
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
db
