x

database design

Hi All My freind please answer this question...

{

Exercise 2.2

A university database contains information about professors (identified by so-
cial security number, or SSN) and courses (identified by courseid). Professors teach courses;

each of the following situations concerns the Teaches relationship set. For each situation,
draw an ER diagram that describes it (assuming that no further constraints hold).

1. Professors can teach the same course in several semesters, and each offering must be
recorded.

2. Professors can teach the same course in several semesters, and only the most recent
such offering needs to be recorded. (Assume this condition applies in all subsequent
questions.)

3. Every professor must teach some course.

4. Every professor teaches exactly one course (no more, no less).

5. Every professor teaches exactly one course (no more, no less), and every course must be
taught by some professor.

6. Now suppose that certain courses can be taught by a team of professors jointly, but it
is possible that no one professor in a team can teach the course. Model this situation,
introducing additional entity sets and relationship sets if necessary.

}

Thank you for answer me....

more ▼

asked Dec 15, 2009 at 03:42 AM in Default

mariwan gravatar image

mariwan
13 4 4 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

See the answer I gave to the question you asked yesterday:

http://ask.sqlteam.com/questions/1306/design-online-shop

more ▼

answered Dec 15, 2009 at 04:48 AM

Kristen gravatar image

Kristen ♦
2.2k 6 7 10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x238
x107
x74

asked: Dec 15, 2009 at 03:42 AM

Seen: 1338 times

Last Updated: Dec 15, 2009 at 04:47 AM