All Questions
11 questions
1
vote
0
answers
61
views
Table for an Appointment App
experts,
I am building out an appointment scheduler application. I am seeking advice on how best to tackle this issue.
I am building out my ERD and I am the point where I will be creating a ...
1
vote
3
answers
2k
views
What can be best database schema for multiple project and one database? [closed]
I am working on multiple projects but the back-end will remain the same. I have a different server for auth, data, etc. and one database to store all the details.
If one projects are creating any ...
- 119
3
votes
1
answer
1k
views
Ternary Relationship or (n-ary)
I'm trying to find the difference in terms of modeling a ternary relationship v/s a binary relationship in the following case. Any piece of advise would help me a lot.
Company has editors who are ...
0
votes
1
answer
476
views
Should a TeamMembers table have a relationship with the Student Table or the Enrolment Table?
I'll keep it nice and short and simply link to the ERD:
Users can be assigned a role, one of those is student.
So for the sake of this, Students are the same as Users!
A Student can be enrolled in ...
9
votes
4
answers
20k
views
In a one-to-one relationship, where should the foreign key be placed?
I am currently designing an ERD for a project management system. I am unable to choose between two workable solutions as the best solution as I wish to embrace the best standards.
The two entities ...
- 249
1
vote
0
answers
2k
views
Quotation and invoice mysql table
I am trying to develop a small business web application for my friends business. I do have some php,html experience so I have done the interface and all. Now I am trying to work on the database. The ...
- 11
1
vote
1
answer
5k
views
How can I represent a one-to-many relationship with three tables?
I just started using MySQL Workbench drawing an entity-relationship diagram that I previously designed in paper.
I want to represent a conceptual one-to-many relationship by means of three tables. ...
- 11
1
vote
1
answer
221
views
Implementing a simple ERD in MySQL: is the implementation below 100% compliant with the ERD?
ERD
Consider the following ERD:
Tables
From it, I derived the following tables:
Company
------------------
c_id c_name
------------------
CompanyEmail
------------------
c_id e_id
--...
- 265
1
vote
1
answer
3k
views
How much the decision to use ternary or binary relationship influences the accuracy of the model with regards to a given business model?
The question title is very long, so here's a little bit of context to (try to) make it clear.
I asked a question regarding ternary relationship. The question was Ternary relationship: what's the ...
- 265
8
votes
1
answer
21k
views
Ternary relationship: what's the difference between having single table and having multiple tables?
Consider the following ternary relationship:
Suppose that all entities have only two attributes (PK and Name).
Here are the tables I derived (5 tables):
Sector
-------------------------
ID_Sector ...
- 265
2
votes
1
answer
883
views
Conversion of simple ERD to Table: is the solution below any good?
Consider the following ERD:
Suppose that all entities only have two attributes: a PK plus a name/number.
I want to convert that ERD to tables.
Is it needed 4 tables (1 for each relationship plus ...
- 265