All Questions
Tagged with erd sql-server
16 questions
2
votes
2
answers
1k
views
Primary keys due to inheritance
I am trying to design a database for postgrad office and we have a parent class "User" that has a username as a primary key for authentication and we have corresponding subclasses "...
0
votes
0
answers
1k
views
ERD for a simple bank system
I tried creating a simple erd for a banking system, I was wondering what can I improve, and where I did wrong. I'll also have to transfer this erd to sql and then try some queries on it. Thanks in ...
0
votes
1
answer
366
views
Survey Database Structure
I am building a database to feed into a PowerBI dashboard.
The data is extracted as CSV (SurveyResults) from Survey Monkey which will be loading into the MSSQL database.
The outcome i am after is the ...
- 137
-1
votes
1
answer
262
views
Database design for 'pay at table' product (integrating with restaurant APIs)
I am doing a database project for Uni and am trying to figure out how a 'Pay at Table' app would work for restaurants. I Have found this example company that does this https://readytopay.com/ but i ...
- 1
2
votes
2
answers
1k
views
Which table gets the FK? Is there a clear Parent-Child relationship here?
I have the following tables:
Each ProductLine will encompass many Parts. For this reason, it initially seemed to me that the Part table is a child of the ProductLine table. However, a part is not ...
- 179
1
vote
1
answer
65
views
Setting up a many-to-many relationship based off of two other many-to-many relationships
I have 3 main top level entities:
Project (PK: Id)
Owner (PK: Id)
Product (PK: Id)
Here are the rules:
A Project can have many Owners. An Owner can have many Projects.
A Project can have many ...
- 113
6
votes
2
answers
18k
views
How to generate Entity Relationship (ER) Diagram of a on-premises database using Azure Data Studio (macOS)?
I found a similar question for SQL Server Management Studio. But I use latest Azure Data Studio on macOS. We use on-premises SQL Server (not Azure cloud).
How can I use Azure Data Studio to generate ...
- 2,558
2
votes
2
answers
58
views
Is my schema right?
Is my schema correct? I tried this because my design plan is supposed to have repeating entries of offenses.
Something like this:
StudName | OffDesc
-----------+-------------
John | ...
- 25
1
vote
0
answers
1k
views
Creating a Relational Products / Package Database
To prefix this, I am stuck using Microsoft Access, or at least relating to it, so my capabilities are a bit limited. I also do not want to use an EAV model. I could put the new tables into SQL Server, ...
- 169
0
votes
1
answer
51
views
Statistical Database Optimization
My friends and I are building a database for statistical research.
So we have a user that answers 10 questions in a row.
The questions are face-images, one is mirrored and the other one is the ...
2
votes
2
answers
112
views
How To Add Days And Time For Instructor Schedule [closed]
Problem
I need to make a database design (ERD) to display a schedule for every instructor, including the following:
day of course (e.g. Saturday or Monday)
time it will give course (period from 12 ...
- 21
2
votes
0
answers
137
views
ERD to SQL Server
I am working on an assignment and am having one heck of a time getting my head wrapped around these questions. I need to be able to write in SQL Server 2014 certain select statements based solely off ...
- 21
6
votes
1
answer
5k
views
Visualizing Database Schema [closed]
I am not a DBA, but an end user that mashes together data from various databases within my company to generate insights.
When I first encounter a new (to me) database, I spend time scrolling ...
- 161
0
votes
2
answers
115
views
What is the most efficient way to make a Locality Entity (Town, City, Village etc) with a Country Entity?
I am new to Database.
I have a database with a UserProfile Entity. I need to add a Country and Locality(City, Town, Village) to the UserProfile.
What is the most efficient way of doing so?
This is ...
11
votes
2
answers
3k
views
Conceptual ERD Multi-table many to many, or possibly recursive?
I'm creating a conceptual diagram [yes, I know I've included attributes and keys - but this is just for me to consolidate what I'm doing whilst learning] -- so please treat it as Conceptual with the ...
- 213
3
votes
1
answer
2k
views
Exporting from SQL Server 2005 for import into ER Studio 9.0
I am new to ER Studio and need to create an ERD for a remote system. That system can only be accessed by LogMeIn remote control and by FTP. The remote system is running SQL Server 2005. The local ...
- 51