1
vote
1answer
22 views
Table in Database, where the combination of two is unique but either of them isn't
I am just learning programming and I am not really good at databases. I am trying to make a University Management Website.
So I have to make a table with columns - teacher, class, period, day. If ...
1
vote
2answers
27 views
DB Schema for Dynamic Categories
Added Update #1. Please check at the end of the question. Thanks.
Friends,
I am designing a Product Listing with categories and filters tied to the categories. I currently have a database schema ...
5
votes
6answers
202 views
+250
Is it ever a good idea to have a record in a reference table in your database that represent “all other records”?
I have an asp.net-mvc website with a SQL Server backend. I am simplifying my situation to highlight and isolate the issue. I have 3 tables in the DB
Article table (id, name, content)
Location table ...
0
votes
2answers
12 views
Ecommerce, storing ordered products with product options
I'm trying to settle on the best way to store an order within the database.
Each product can be configured, and not all options are the same. For example:
Product A
Size: small, medium, large
...
-3
votes
1answer
15 views
How should I go about database architecture for my website
I am trying to make a website for my families antique store (for showings and appraisals). The website is for booking appointments. I understand that there is software out there for this, but I want ...
0
votes
2answers
23 views
Database schema for multiple choice Trivia game
I'm trying to determine the most efficient db schema for a multiple choice trivia game. I have the questions and answers in a spreadsheet with the columns, 'question_id', 'level', 'question', ...
0
votes
0answers
23 views
What are the efficient ways of storing a lot of time series in a database?
I need to store a bunch of time series in a database but I'm concerned about both the size and the processing time.
To reduce size I've already used, in another project, zipped/JSON to store a whole ...
0
votes
1answer
12 views
ActiveRecord Association for Grades App
A bit hard to explain with a title.
I am making a test grades app with Ruby on Rails, and can't figure out the best ActiveRecord Association setup.
Ideally: there are many Users, and there are ...
0
votes
3answers
70 views
Storing many to many relationship objects in a column on database
I have an object called listings, and a listing can have a number of amenities (compare this to post, tags model). It's a sort of has/doesn't have relationship.
So I have an amenities table which ...
0
votes
2answers
23 views
what is different between database clustering and database partitioning
I would like to know what is different between database clustering and database partitioning?
As i know there are two types called attributes or record clustering sometimes called partitioning ...
6
votes
2answers
298 views
Ways to get past the Inner-platform effect while still building highly customized web apps?
Feel free to answer the question in the title as generally as I posed it, I offer some more details and specifics below.
Currently I develop and maintain a somewhat legacy business app (ASP/SQL) that ...
0
votes
2answers
172 views
Database schema design for records of nested JSON
I have a list of profile records, which each of the record is like the below:
{
"name": "Peter Pan",
"contacts": [
{
"key": "mobile",
"value": "1234-5678"
}
],
...
0
votes
0answers
23 views
Database layout for forum
I'm trying to layout the tables for a forum that will be structured as follows:
EXAMPLE.ORG
- Announcements
> News, updates, events and tutorials
COMMUNITY
- Technical Discussion
> ...
1
vote
1answer
21 views
Entity Arrangement in ERD
While studying database systems, I ran into a hypothetical relational database comprised of the entities: STUDENT, PROFESSOR, COURSE, CLASS and ROOM.
The book's author specifies their relationships ...
1
vote
2answers
28 views
What normal form are the this relation in? Am I right?
-
R(a, b, c, d)
Functional dependencies: None
I think it is 0NF, because there are no functional dependencies.
R(a, b, c, d)
Functional dependencies: b->d AND a,b->c
This should be ...
