EXTENDED E-R DIAGRAM FOR SPORTS CLUB (S5 CS2 ROLL NO 34)

TOPIC: collect one E-R diagram with extended ER features and explanations

QUESTION:

Create an E-R diagram of a sports club conducted by school.

a) A school is decided to setup a sports club outside the school.

b) Sports club can be categorized based on the type: cricket club, football club.

c) A student can join in any one of the sports club.

d) Each sports club has a coach who trains the students.

e) Each student can be identified using id no.

f) Salary, experience, name of the coach can also be included.

ANSWER:

     asha                                                    

STEP 3: IDENTIFY THE KEY ATTRIBUTES

Sports club: clubname

Student: Sid

Cricket: Cplayerid

Football: Fplayerid

Coach: Cid

STEP4: IDENTIFY OTHER RELEVANT ATTRIBUTE

Sports:

Location

Contactno

Student:

Sname

Address

Phone

Cricket:

Cname

Cclass

Football:

Fname

Fclass

Coach:

Name

Experience

Caddress

Salary

asha1

Advertisements