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 map one column to several tables in Hibernate?
For supporting several international languages in our system, we want to store string's real content of all tables to another table 't_vocabulary', yes, this is one-to-many case in hibernate ORM, and ...
0
votes
2answers
15 views
2 unique field combination vice versa
Hello is it possible to have a combination of 2 fields vice versa ?
Example:
ID catID
1 58
So that we couldnt store another row as 58-1. Currently I have primary key on both fields, but it ...
0
votes
1answer
17 views
Best practice in Domain Object / Data Model to hold an order/application request and its end-product(License)
I am designing a Domain Object model for an application. Need a suggestion on a scenario.
Use case Assumption : Say the user can submit an 'Application Form' requesting a permit or license for a set ...
1
vote
5answers
59 views
How do I properly design a database schema for this scenario
Suppose I owned a business that sold cars and motorcycles. I want to track data on each. My company provides a free warranty for every car, but we do not even offer warranties on motorcycles. ...
0
votes
1answer
23 views
Normalizing a Data Dictionary
I'm creating a data dictionary for an organization which pulls together fields found in many different sources and defines them. I have all the data in another Access database, but it is a relational ...
0
votes
0answers
20 views
Table aready exists when creating MySQL trigger
I get a Table 'fundingsource' already exists when attempting to create MySQL trigger:
-- Trigger DDL Statements
DELIMITER $$
USE `remis_sandbox`$$
DROP TRIGGER IF EXISTS tr_archive_fundingsource$$
...
0
votes
2answers
20 views
Data-centric application: separate database tables for separate organizations a good idea?
I am building an application where several organizations can register
themselves and manipulate a set of enterprise tables such as list of
clients, sellers, items, sale orders etc... I was wondering ...
0
votes
0answers
55 views
How should I define this Laravel Eloquent relationship?
I'm using Laravel 3.
I have a scenario where a user can create any number of 'LibraryCases'. Each LibraryCase can have zero or more tags. Here's my (simplified) database schema:
cases:
id ...
0
votes
1answer
28 views
store the incoming messages in sorted order(as per the incoming numbers)
I am designing an app in that i am storing the incoming messages in my own created database and from this database i am displaying these messages in my application.
for this i am using this code,
To ...
android
1
vote
2answers
51 views
Storing dynamic data in NoSQL
I have scenario where I need to store unstructured data but the rest of my data is structured and relational. An example of the type of unstructured data is as explained below:
User Type 1:
How do ...
-1
votes
1answer
26 views
Best way to store large demographic datasets
I need to store a lot of demographic data that I am collecting for my research in database. I am trying to find out what would be a good solution to store data such as this:
...
0
votes
2answers
41 views
Getting database information in Laravel Blade Template with Inner Join
This question has to do with Laravel, but also general database design as well since I am new to both.
I have made a database that is like this:
people
id
firstname
lastname
address
yadayada
...
2
votes
1answer
49 views
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
1answer
26 views
Am I wrong in table design or wrong in selected index when made the table?
I've build web application as a tool to eliminate unnecessary data in peoples table, this application mainly to filter all data of peoples who valid to get an election rights. At first, it wasn't a ...
0
votes
1answer
24 views
Optimize multiple self-JOINs or redesign DB?
I'm looking for advice on either optimizing multiple self-joins, or a better table/DB design.
One of the tables looks as follows (relevant cols only):
CREATE TABLE IF NOT EXISTS CountryData (
...
