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
1answer
7 views
kendo grid with more than one datasource
I'm having 3 radio buttons.I have 3 different stored procedures that is called for 3 different radio buttons.
Example:
I have a kendo grid. I want the results to be displayed in the same grid for all ...
0
votes
1answer
16 views
how to make multi_friends relationship
I have database contains those tables:
user, post, like and comment.
I was able to make diagram to show relationship between them.
one user has many posts, many likes and many comments.
one post or ...
0
votes
0answers
10 views
Cassandra: How to model column family to perform intersect-like queries
Basically I have three attributes: partId, measurementDef and value.
Each part (partId) consists of multiple measures (value) of a certain type (measurementDef).
Formatted as a tree it would look ...
0
votes
1answer
19 views
How to design table for dynamic number of columns?
Requirement: We have to capture the data for a day in particular time intervals(time interval is constant for a set of data). The time interval can range from 5 minutes to 2 hours . So the number of ...
1
vote
1answer
36 views
How should I partition this table?
i have plan to create a analytic's table. Monthly 1 million records approx can be insert to the table. help me better way of optimizing and also fetch records fast way.
Alternatively i have planned ...
0
votes
1answer
18 views
Database modelling of prizes table that allows customization per contest
I have the following problem modelling some database tables:
Let's say I have some contests (in a contests table, with a unique id for each one), and on each contest they give some prizes to the ...
-2
votes
0answers
19 views
Database type tables [on hold]
I am working on a database design which references type tables(Converting the data from one format to another). Type table is to be maintained separately. How do I show this in an ER diagram ...
0
votes
2answers
22 views
In iOS how do I output my sqlite3 database table structure?
I am adding columns to my sqlite3 database table and I need to verify that they are being added. Is there a way to output the table structure nicely somewhere, like a NSLog or something?
0
votes
1answer
28 views
Database Design for spay/neuter clinic
I am working on setting up a database for a spay/neuter clinic. I think I got everything covered, but would like to get a second opinion in terms of my database. We are assuming having 100,000+ ...
0
votes
1answer
26 views
Probably database relationship cycle
My issue is related to a cycle relationship, where I need to solve the database schema in order to do the best practice, it will be used on a tracking vehicles system
My problem description:
A ...
0
votes
1answer
28 views
Database design from a json file
I have a json file like this
[
{
"topic": "Example1",
"ref": {
"1": "Example Topic",
"2": "Topic"
},
"contact": [
{
...
1
vote
0answers
8 views
One Form with Fields from two Tables
I am very new to Access 2007 and am trying to create one form which has multiple tabs on it. Four of the tabs represent information from one table and two of the tabs represent information from a ...
0
votes
0answers
30 views
Database implementation of formatting
I have database like this:
text_id | sentence_id | word_id | word | meaning
4 2 124 I Ja
4 2 124 like lubię
4 2 ...
0
votes
1answer
13 views
EF Modelling Help: User with multiple Roles and Locations at a Company (Model First)
I am kind of stuck in an easy modelling / design process. How would you design the following model? I'm working with Entity Framework 5 / Model First.
I have Users working in Companies.
Each User ...
0
votes
1answer
11 views
what are pre-aggregated tables in vertica
what are pre-aggregated tables in vertica ? How to implement the pre-aggregated table in vertica ?
i found this term mentioned for performance optimization in vertica database, but couldn't find any ...
