Football team entity relationship diagram

Question

My teacher tested this structure by testing it within access and creating a form which queried the database. It came back as erroneous, i don't mind if it can't be fixed but i need to know what it wrong with it. Thanks

why don't you ask your teacher? – tung Dec 16 '18 at 15:04 — tung, Dec 16 '18 at 15:04
He didn't know ffs *laughing emoji – ProgrammingNinja Dec 16 '18 at 15:37 — ProgrammingNinja, Dec 16 '18 at 15:37

score 1 · Accepted Answer · answered Dec 16 '18 at 16:26

1

I didn't test it but I think you should be able to create a database from your model.

However, there are some logical errors I detected:

the cardinality between team and position seems wrong as you modeled it a team only has one position and a position can belong to several teams
also, your tables position and manager contain no information in your current model and are therefore unnecessary

Heres how I would probably model it set the attributes and cardinalities according to your requirements:

answered Dec 16 '18 at 16:26

tung

719
2
14
30

Thanks that really helpful! – ProgrammingNinja Dec 16 '18 at 19:16
@ProgrammingNinja glad it helped – tung Dec 17 '18 at 11:04

Football team entity relationship diagram

1 Answers1