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
3 views
Database Design - Custom attributes table - Table that “relate” entities
I'm designing a database (for use in mysql) that permits new user-defined attributes to an entity called nodes.
To accomplish this I have created 2 other tables. One customvars table that holds all ...
0
votes
0answers
20 views
History table and getting the latest status
I have a requirement to store the history of a Task in my database. We can't use CCD.
So, my task table:
CREATE TABLE Task
(
Id INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
Notes VARCHAR(200) NOT ...
0
votes
1answer
25 views
One blog post in multiple categories
I'm having difficulties with the following database schema:
I know that, for some reason, this model allows me to add a blog post that doesn't belong to any category. Could someone please tell me ...
1
vote
1answer
34 views
Redis storing and querying complex structures
I want to store a complex structure as JSON object in a Redis Sorted Set.
ZADD "mysetkey" 100 [ {"A":"100"}, {"B":"50"}, {"C":"180"}, {"D":"200"} ]
ZADD "mysetkey" 101 [ {"A":"10"}, {"B":"50"}, ...
0
votes
2answers
16 views
How to enforce foreign key constraint from unrelated tables in Mysql?
this is my DB structure.
this is the script I used to create the tables
use for_stkoverflow;
CREATE TABLE UserGroup (
groupid MEDIUMINT NOT NULL AUTO_INCREMENT,
groupname VARCHAR(100),
...
1
vote
1answer
16 views
Mysql can't update rows when my trigger is called
My trigger fails when i try to insert a new row in my table because Mysql doesn't support updating rows in the same table the trigger is assigned to. Does anyone have suggestions on a good ...
1
vote
0answers
33 views
what is the best way to store a field that supports markdown in my database when i need to render both HTML and “simple text” views?
I have a database and i have a website front end. I have a field in my front end that is text now but i want it to support markdown. I am trying to figure out the right was to store in my database ...
0
votes
1answer
18 views
Is SAp Bo Universe similar to SSRS DAta Source views
I just wondering whether the Business object universe is a concept similar to SSRS DAta source view?
Can anybody compare the difference /similarity between these 2 tools?
1
vote
1answer
20 views
Database design for the Lectures Scheduling for a Single Course
I want to store the Lectures Timing information in the 3rd Normalized Database.
The ER Diagram of the Lecture Info is as follows:
Since the Lecture_Day is multiple value attribute so i have ...
3
votes
3answers
74 views
Database Design Issue due to Volume
I have a really generic database question. I have created a table in my database that tracks clicks throughout my website. My table structure is as follows:
(PK) - ID,
(FK) - PageID,
(FK) - ...
1
vote
1answer
16 views
Does Longtext slow down queries on other fields?
I have a website. Users in this website have profiles which has Longtext field. I'm in a dilemma. If I combine user and profile table, does it slow down my queries? I have intensive number of queries ...
0
votes
2answers
47 views
How should a Facebook-Timeline system look on the database?
How would I store Users "Posts"? So that I can efficiently get them from the db and then process them to display chronologically when a specific users page is requested?
Do I store all Posts from All ...
1
vote
4answers
64 views
If EAV is evil, what to use for dynamic values?
I need to create database where Accountgroup table will have dynamic fields so that Accounts can enter those dynamic field values when needed. It's probably not important but I'm using C# with EF and ...
1
vote
2answers
34 views
Plant table, many types of plant, each plant has many attributes, some attributes have multiple values
I have a model that represents a plant. Each plant has a type (flower, tree, shrub, etc.). Each plant type then has differing requirements for a set of attributes, some of which a plant can have ...
0
votes
2answers
34 views
Is it worth breaking out address information into a separate database table?
I have a person table with the following columns
Id
FirstName
LastName
DateOfBirth
City
State
Country
Should things like City, or State be broken up into their own table and then this table have ...
