Database design is the process of specifying the logical and/or physical parts of a database. The goal of database design is to make a representation of some "universe of discourse" - the types of facts, business rules and other requirements that the database is intended to model.
0
votes
0answers
4 views
How to design assets table for CMS (two-to-many relationship?..)
I'm working on a database for a simple CMS like web-app. Basically it consists of bits of content that are part of a contentgroup. Like pieces of text that are part of a page. For that I was thinking ...
0
votes
1answer
40 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
0answers
10 views
Model a binary decision tree database in mySQL
How would i model a binary tree help desk solution in a mySQL database?
Problem ---> Questions -----> Solution
RootNode---> Decision Nodes ----> Leaf Node
thanx
1
vote
1answer
12 views
Checking if a set participants already exists in a Threaded Database schema
I am creating a threaded messaging system for a web application, much like in Facebook's messaging system. I followed the other database schemes for threaded messages here in StackOverflow, but I ...
2
votes
1answer
35 views
Calculate candidate keys given functional dependencies
I have a relation with the following functional dependencies :
A -> B
AC -> D
EF -> AG
AG -> H
the couple (EG) is unique.
I want to calculate the candidate keys, should i add a ...
0
votes
2answers
48 views
Create a table with a dynamic number of columns in SQL Server
What is the best way to implement a table with a variable number of columns and different types?
(The number of columns is unknown)
We use a column of type XML. What do you think?
0
votes
0answers
11 views
Is it advisable to have all tables have a reference to the top level table?
We have the following data structure, expressed in classes, as we use the Entity Framework Code First approach:
Public Class TopLevel
Publc Overridable LevelOnes As ICollection(Of LevelOne)
End ...
1
vote
1answer
44 views
Table design for Payment Schedule
We are developing a database that handles payments to people. The area I am focusing on at the moment, is the scheduled payment options. Basically, the system sends payments to people once every ...
1
vote
2answers
24 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 ...
1
vote
2answers
56 views
Database subtyping/supertyping
I have tables "Crop", "Corn", "Soybean", and "Grain". One entry in Crop corresponds to a single entry in one of the other tables. The problem here is that Crop should be one-to-one with only one of ...
-1
votes
0answers
30 views
Database Structure for data packets [closed]
I'm very new to database design and like some help in structuring my data.
The data is formatted as packets that can be one of three types dependent on the Message number in the packet. The packets ...
0
votes
2answers
41 views
A better database model for holding postage prices
I wanted to create a Postage_costs table to hold postages costs, each postage_cost has a name, e.g Large Item, which has different costs(standard price and express postage price) depending on ...
0
votes
0answers
14 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 ...
0
votes
3answers
24 views
Securely store data for multiple party's in a single table
I'm certainly no DBA and only a beginner when it comes to software development, so any help is appreciated. What is the most secure structure for storing the data from multiple parties in one ...
0
votes
0answers
19 views
Database schema for images uploaded through WYSIWYG editor
To describe the problem, consider this simple scenario of an on-line exam with questions and answers. Suppose that the question and answer can contain rich text data and thus images. For this, I am ...
0
votes
1answer
20 views
Bidirectional mapping by one of two possible columns
How would you define a bidirectional mapping between the following entities:
@Entity
class Host {
@Id
String id;
HaGroup haGroup; // needs mapping
}
@Entity
class HaGroup {
@Id
...
0
votes
2answers
34 views
Admins, Users, permissions and roles [closed]
Look at the attached graphic.
I'm trying to keep this as simple as possible.
Basically I want to have multiple admins(or superusers) who own regular users who own sites.
Admins can give regular ...
2
votes
2answers
41 views
MySql retrieve products and prices
I would like to retrieve a list of all the products, with their associated prices for a given period.
The Product table:
Id
Name
Description
The Price table:
Id
Product_id
Name
Amount
Start
End
...
1
vote
3answers
38 views
Code-First generated database different from DbContext Model
I've successfully setup a simple MVC4 internet app that stores model data onto a LocalDb v11.0 SQL server. I generated the database using a code-first approach, however, the Table fields in the ...
1
vote
3answers
32 views
What is a good way to edit a record in a database and preserve the former record
I'm developing an application that doesn't allow delete. It allows edit, but the old records must be preserved. I'm not sure the best method to implement this, but here are my thoughts.
I intend to ...
0
votes
1answer
53 views
Laravel relationship with multiple foreign keys
What is the standard way to set up your tables and models with table that have multiple foreign keys.
Example one foreign key relationships typicall look like
database tables:
clients
id
...
0
votes
2answers
19 views
localizing existing database
We have a small mySQL database with about 20 tables (All in english).
Would it be possible to localize this database now that it has already been designed and has multiple thousands of records?
What ...
1
vote
1answer
38 views
Customers, Suppliers and their Employees
I'm designing a marketplace where customer can order products from suppliers. I need help in defining the database scheme.
I have two types of companies: Customers and Suppliers. Suppliers can have ...
0
votes
1answer
33 views
Front end solution for a growing business
I work for a workers comp insurance provider. About 10 years ago, the company probably had 20-30 employees. Around that time, they built a bunch of databases using ms access because it was quick and ...
-1
votes
1answer
14 views
What is a code page and what is it's purpose?
I was reading up on database optimization and the differences between certain data types and came along some discussion about code pages. I couldn't find an easy to grasp explanation. What is a code ...
0
votes
0answers
17 views
Shard tags table strategy
I have a simple table in mysql called "tag" which has the columns: tag_id (PK), tag_name (unique), creation_time, I also have another table called tag_article which has article_id and tag_id.
the ...
1
vote
1answer
51 views
How to insert many entries in one database field
I have a Java webproject with servlets, jsp, java and so on. There I have many projects inside, which I can choose in a combobox like this:
Project [Combobox]
Priority[Combobox] ...
0
votes
1answer
28 views
Most efficient design for item's price based on day of week and time
Here is the scenario:
I'm trying to create a website that will allow a store to enter a product and price. I want them to be able to set different prices based on different days of the week and time ...
1
vote
2answers
29 views
SQL structure to count size of a queue through changes over time
How can I design an SQL data structure that will let me query how large a queue was (how many records) over time (so I can graph it), when the items constantly move from queue to queue.
Tables:
...
1
vote
2answers
33 views
Storing an array of type string[] inside a database
I'm building a table of procedures, and I need to figure out a way so a 'logged in user' only has access to that procedure.
My initial thought is to store this information in a Certified column ...
