All Questions
32 questions
0
votes
1
answer
41
views
Could a Tool Like ChartDB Work for MongoDB Schema Visualization?
I’m one of the developers behind ChartDB, an open-source tool for database schema visualization, particularly useful for relational databases (RDBMS). Our tool helps users generate ER diagrams to map ...
- 11
0
votes
1
answer
46
views
Recommended way to build database to contain users and chatgpt data
I am looking to create a Rails application to interface between users and Azure ChatGPT. I will include my ERD diagram showing a couple of options in building the database tables and table ...
- 101
3
votes
3
answers
1k
views
Is it ok to have repeated values in some of the columns and similar columns in two separate tables?
I'm trying to create database in which I could store thousands of job postings. I put here 3 sample records of these job postings so that you could better understand how everything looks like:
Every ...
- 65
1
vote
0
answers
926
views
Can a foreign key be a primary key?
I want to know the relationship takes, teaches, advisors tables underlined attributes are foreign key or primary key? or both?
- 11
0
votes
1
answer
125
views
Is my database ERD well designed
I'm creating a PostgreSQL database for datasets, which should store historical and future data of weather forecasts and train timetables. I'm wondering if my ERD is good enough for a database which ...
- 1
0
votes
0
answers
690
views
Is my ER Diagram correct according this business rules?
Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s last name, first name, date of birth, and date of ...
-1
votes
1
answer
215
views
What is the correct way to organize tables for a SQL view?
I'm new to data modeling. Currently working at creating a personal contact manager but I need some help with modeling the table relationships for a given view.
The final view columns I'm shooting for ...
- 111
1
vote
2
answers
455
views
Anonymous and Public User Table Design in twitter like application
I have schema design problem which I am not 100% sure if my assumptions are correct.
So the requirements are:
I need to have 2 different type of user, anonymous and public.
A user can have both ...
- 113
1
vote
1
answer
355
views
Weak entity having n instances as the 'one'
I'm struggling with a question, I'm just trying to figure is it even valid , if not where does it violates the rules of a weak entity relationship, I think it's not valid because how can a weak entity ...
- 11
1
vote
0
answers
59
views
How to structure SQL data model to maintain data integrity
Background
I'm building a Private Chef booking service where you can book a Chef to cook you a custom Menu. I'm having trouble creating a SQL db schema that accurately represents the domain while ...
- 111
0
votes
0
answers
125
views
Need an ERD of the schema mentioned
Need the erd of the schema for doctor, patient and appointment database. scenario is given as under:
Clinic Management Entity-Relationship Model
-Doctor has a unique id, name, address, qualification ...
user203653
2
votes
1
answer
61
views
ERD - Multiple FKs with only one of them being filled for each record
I'm designing a database schema for a music platform.
Some of the entities as follows:
track
album
band
artist
A "track" can have an "artist". It can also have a "band" which makes the artist ...
- 123
0
votes
0
answers
2k
views
Creating a Database for Multiple Calendars Support
I am trying to create a calendar application that can support multiple calendars, for instance Indian, Nepali, Russian etc. Users can enable or disable the calendars according to their needs.
I have ...
0
votes
1
answer
2k
views
EER Diagram - subclasses which are neither disjoint nor fully overlapping
Suppose we are writing an enhanced entity-relationship diagram (EERD) for a company's database. This company offers two services A and B. If the two services were disjoint, then this might look ...
- 103
1
vote
0
answers
2k
views
Gaming shop database schema
I'm trying to design schema for my personal project that would be an online gaming shop. I would like to ask you guys for any suggestions/tips on how could I maybe improve my current draft.
Concerns:
...
- 29
1
vote
1
answer
3k
views
Extended Entity-Relationship Diagram: Do the sub classes have foreign keys or primary keys?
Consider this example (they are disjoint, by the way):
There are two scenarios which I am guessing:
While translating it to relational tables,
the rows in PROGRAMMER are unique which do not exist ...
- 143
1
vote
0
answers
446
views
How to create entity-relationship diagram for tables that can potentially be united by an "IS A" relationship?
I have this schema:
create table hall(
building-id int,
hall-id int,
capacity int,
primary key(building-id, hall-id)
);
create table semester(
sem-id char(5),
start-date date,
eend-...
- 195
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
1
vote
1
answer
107
views
How to make Event (like a Party) Sources mutually exclusive?
I'm designing an entity-relationship diagram (ERD) for a marketplace of events. An event can be created by a user, in which case the Event table must have owner_id or we pull it from an API in which ...
- 11
3
votes
1
answer
8k
views
Orders and Quotes Tables - Database Design
Below is the ERD of my current db schema for the orders part of an e-commerce site. The site is based on oscommerce, but has been modified, also I have removed quite a few of the fields from the ...
- 133
0
votes
1
answer
349
views
How do I model the following requirement in ER-Diagram?
I'm making a story-composer application which allows users to write stories and other users can contribute to it. A story can have multiple storylines and multiple levels(think like a tree or thread ...
- 1
-1
votes
1
answer
123
views
Mapping Large Databases [closed]
I have the task of mapping a pretty large database schema (~250 tables). I can have Visio reverse engineer the database in pieces, but there are just too many tables to have it map the entire database....
- 1
2
votes
3
answers
2k
views
Should I define a FOREIGN KEY column as NULLable?
I've been developing some database structure to cover the following business rules:
An invoice has many invoice_items.
An invoice may have many refunds
A refund has many invoice_items.
All items ...
- 135
5
votes
2
answers
1k
views
How can I represent the entity types depicted in an ERD as relations with attribute names?
I have created the entity-relationship diagram (ERD) shown below (for brevity, each individual bubble-shaped box portrays multiple attributes):
Considering such an ERD, I have to convert each entity ...
- 253
2
votes
0
answers
1k
views
Handling Strong and Weak entity types in a one-to-one relationship
I am modelling a database for a term project and I have come across something I do not have a definite answer to.
Diagram
I was supplied with the following Entity-Relationship diagram:
Description
So,...
- 21
5
votes
1
answer
3k
views
ERD for a web development company
I am working on an ERD which represents the relationships between entities in a Web development company behavioral model.
There I have entities like:
Customer
Service ----------- (like: web ...
- 157
5
votes
1
answer
30k
views
ER vs database schema diagrams
When I search the web for "ER diagram" and "database schema", these 3 diagram types are found, but all of them are referred to as "ER diagrams". I want to know:
What is ...
0
votes
1
answer
4k
views
Is an ER diagram an example of a conceptual, logical or physical schema?
I have been reading databases, and I clearly understand the difference between a conceptual, logical and physical schema. An ER diagram is an example of which of these schema's?
- 137
5
votes
3
answers
6k
views
Database design for bookmark system
I am creating a bookmark system where people can save their bookmarks. Each user has its own personal page with bookmarks. A bookmark should have atleast one tag and max five. Each user can create ...
user31574
6
votes
5
answers
20k
views
Automatically create ER diagram from database schema
I have a database with 193 tables and I need to create an entity-relationship diagram from them. There are no formal relationships between the tables with respect to FKs. The relationships are mapped ...
- 163
5
votes
3
answers
2k
views
Are there any tools to go from ERD to DB design and vice versa? [closed]
I'm learning DB design and looking for some tools, preferably open source software, that could help go from an ERD to a DATABASE and vice versa.
For the record, the database i'm using is MySQL.
- 364
2
votes
1
answer
3k
views
How do I persist recurring events?
I've been tasked with designing a system to recur events. Events may recur daily, hourly, monthly or yearly. Users should be able to schedule events "every 3rd Wednesday of the month" or &...
- 3,934