All Questions
18 questions
2
votes
0
answers
56
views
Case Study: Database design help for a small app used to coach tennis players
I have a small SQL server database and VBA program that is used to automate tasks related to tennis students, programs, practices, performances, and student testing.
I'm trying to learn db design and ...
- 21
1
vote
1
answer
146
views
Creating database and two tables linked by foreign key
These commands do what I want, but I'm trying to find out the best approach for this. My main areas of concern are: error handling and disposal of resources. In regards to error handling, I'm catching ...
1
vote
1
answer
446
views
Database schema for discussion forum scraping
I'm scraping posts from various discussion forums and storing those posts, along with some metadata, into a relational database (SQL). My actual use case is a bit more complex, but I think I can give ...
- 13
-1
votes
1
answer
79
views
IF SELECT statement will break SQL ACID Compliance? [closed]
My QA told me that I should not use IF SELECT before doing an UPDATE statement because it will breaks the atomicity of a ...
- 141
2
votes
1
answer
2k
views
Database Model for Feedback Module
I wish to generate an online feedback system. Requirements are
Admin can enter feedback questions
Admin will select these questions and create a feedback session
One Question can be used in many ...
- 129
4
votes
1
answer
1k
views
SQL e-commerce database design
I want as an exercise to create an e-commerce application from bottom up. My main goal here is to gain a lot of knowledge. I have experience in web development, but never have been there from the ...
- 143
5
votes
2
answers
158
views
Combining SQL Tables into One Table in New DB with Similar Fields
I have a SQL Server Database filled with Reports all having the same schema.
What I've done is created a .NET application to automate the process of adding all reports to a new table.
How can the ...
4
votes
2
answers
83
views
Inserting two rows that are almost identical to each other
I'm trying to make test data for an application I'm writing, and some of my test data is very repetitive, involving inserting a row and then inserting another row that is identical except for one ...
- 43
0
votes
1
answer
689
views
Normalizing an apartment rental database [closed]
We are to normalize a database, though it is mostly all theoretical, we aren't actually plugging in the SQL. This is the Data we have normalized to these tables..
and here is our SQL for normalizing ...
- 19
6
votes
1
answer
85
views
Stored procedure to describe the reason that a particular employee is unsuitable for a particular task
I used the following Stack Overflow questions as references for writing this code:
Select columns from result set of stored procedure
What is the equivalent of String.Join on TSQL?
The idea behind my ...
2
votes
1
answer
54
views
Map groups to parent products using nested subqueries
I have the following tables
...
3
votes
1
answer
167
views
Database design for users' postcards
I would like to a review of my database design.
There are 3 tables + ASP.NET Identity tables.
The Users could have many postcards.
Here's my tables without Identity.
I attached also my scripts of ...
- 191
5
votes
1
answer
2k
views
Database trigger to monitor insert/update events and update another table
I am working on a MSSQL Database (for a program called Sage 200). There are many tables in the database, however, I want to be notified of changes (new record inserted or existing record updated) via ...
- 303
5
votes
2
answers
6k
views
University Database
I am building a database for a hypothetical university. This is my SQL definition, with generated data added for my future use, such as demonstrating queries:
...
user34073
15
votes
1
answer
710
views
Example script for teaching DDL and CRUD/DML operations
I have taught some SQL to others before, and I thought of making a script that has these attributes, for the purposes of teaching:
Fully functional to run on local DB instance with no fuss
Easy to ...
- 20.5k