Entity Relationship Diagram

learn more… | top users | synonyms

0
votes
2answers
912 views

SQL - Cannot Add Foreign Key Constraint

Can anyone tell me why there are errors such as : Cannot Add Foreign Key Constraint And am i on the right track ? DROP DATABASE technology_university_hospital; CREATE DATABASE ...
1
vote
1answer
41 views

Bicycle Sharing Scheme - ER Diagram

Please compare the directions below to my ER Diagram and tell me if anything is wrong with my ER Diagram Please I think its accurate enough. Oxford City Council is preparing to launch an innovative ...
0
votes
1answer
51 views

Database Design / ER Diagram - Help Needed

Please take a look at this ER Diagram that I started. I just don't know if I've set it up correctly (I have not made any relationships yet). I just want to know if I have the appropriate "Tables" or ...
0
votes
1answer
54 views

How to model IsA in an ERD with crow's foot notation

For an assignment I have to create an ERD. I am doing this in Lucidchart using the crow's foot notation. There is however one thing I cannot figure out, how would you present a IsA hierarchy in crow's ...
0
votes
1answer
34 views

How to define User/Permission relationship as M:M?

The Resource relates to Action as M:M via Permission join table/separate entity. User can have many permissions. The same permission may be assigned to multiple users. How to define User-Permission ...
0
votes
1answer
37 views

Relationship issue

I'm working on a ERD with mysql workbench, and i have a little question. I have a Database with this tables: company_address country state city I want to store the address of the company with all ...
0
votes
1answer
728 views

Which is the redundant relationship in this ER Diagram and why?

Which is the redundant relationship in this ER Diagram and why? A few of my friends and I have been trying to figure it out but keep going in circles. where the attributes of each entity are as ...
2
votes
0answers
653 views

The nature of the relationship between two tables in MySQL

Good day. I'm designing a database for a research project where we're predicting whether or not young female athletes will rupture their ACL(s) based on the nature of a test jump recorded with a ...
1
vote
0answers
360 views

Entity relationship modelling, comment on my ERD

Note: Due to low reputation I can't post images so i have added the links accordingly. I have this assignment I'm working and I am stuck in a recursive relationship, following is part of the case ...
0
votes
0answers
54 views

ER Diagram Issues

I'm currently working on a project and I just can't figure out how to setup the portion in "BOLD" and any help will be greatly appreciated. Oxford City Council is preparing to launch an innovative ...
0
votes
0answers
11 views

Is the use of my lookup table efficient?

I'm trying to find the best way to architect the relationship in the scenario that: A team can have multiple players, a player may also have multiple teams My first thought was to use a lookup ...
0
votes
0answers
33 views

ERD to data structure

I'm new to databases. I converted my ERD to data structure. Althougt I made sure all the 1NF, 2NF and 3NF are handled, I'm skeptic about it. This is the data structure. Port(PortID(pk), Name, ...
0
votes
0answers
9 views

Identification of other entities.

Given the following scenario, what three other entities (and their attributes) would be of importance to this model? SCENARIO: The transport authority in Jamaica has recently added train ...
0
votes
0answers
31 views

Employee permissions in ER model

I'd like to model an approach to permissions which I can visualise in code but am a little blurry about on the ER side of things; Each user will be logged in at this point and bound to a record ...
0
votes
0answers
16 views

How to model mappings at various levels

I'm trying to design the database model for my application and I'm finding it difficult to design the mappings for user access to various entities stored in the database. If access was only ...