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.

learn more… | top users | synonyms (2)

0
votes
2answers
11 views

Structure database(s) dealing with different time points

I have few data sets that give a score for a specific account at a specific point in time. So, account A might have a different score each quarter going back 5 years so. There aren't a ton of data ...
1
vote
1answer
24 views

What should we do when same column fields occurring multiple time in many tables?

I have more than 20 tables in my database. There are some columns which occur in almost all of the tables. In that case what should I do? Do I put all those columns in every table or is there a better ...
1
vote
1answer
27 views

Advantage of exposing data model to customers using our product

We have a product through which we provide a standard definition to customer's asset data. The problem currently lies in importing customer's data from different types of data sources to our data ...
0
votes
1answer
11 views

Strategy for regularly updating datasets from excel files

I have ~10 excel files which are produced by a third party and updated each night. I've have a script that downloads them to my local machine. They contain ~ 10 fields (all short text / dates) and ...
1
vote
0answers
24 views

Can I populate a table in mysql without ending up with duplicated entries [migrated]

I have a database. However whenever I am trying to add products to the cart table from a shopping page, I realize that the same item is added multiple times to the table if the add button for that ...
1
vote
0answers
32 views

Which method would be more secure and feasible in the long term?

The concern here is a confusion between two alternative methods for storing data. Our product migrates records from any service A to any service B. These services define their own records and the ...
0
votes
2answers
40 views

Schema review for system to advertise cars

Ok, so I am carrying out a rather simple task as part of a job requiretement. Here is the task in a nutshell: Design a form for creating ad for selling car Form has 2 have: 2 drop downs: Car make ...
-1
votes
1answer
22 views

Users' physical characteristics - design

I have to build a database for an employment agency. For each user will be stored physical characteristics like height, weight, hair color...(9 fields in total). I thought I could just build a ...
0
votes
1answer
44 views

Does my ERD look well designed?

I am making a database at no cost for a local dance school. I'm still very new this would like to be sure that I designed it appropriately. From the front end, the parent will: fill out their ...
0
votes
3answers
50 views

Time sheet, rates, date dependent

I am trying to figure out the best database design for the following; I have individuals (stored in Agents table) that enter their billing or time worked each day for different projects. Now we have ...
0
votes
2answers
34 views

Does an empty entity make any sense in an entity-relationship diagram?

I have an entity that has nothing else than a surrogate key as a primary key. I use it as an element made of a group of other elements For example : TABLE SchoolClass (classNumber INTEGER ...
1
vote
1answer
33 views

Do data types go into a Relational Data Model (RDM)?

I have recently been asked to draw a Relational Data Model for a flight information database. I came up with the design in the picture below, but I was told that the drawing is not correct because ...
1
vote
2answers
36 views

Database design for multiple user attributes

I am building an app with Laravel, and I have users which also have a profile. I am unsure about the best way to set up the database for the user attributes. For example: user_ud | name | ...
0
votes
0answers
38 views

Opinion on Database Design for Task [closed]

Would like to know if this is a good database design. Once you see the picture it is pretty much self explanatory. But anyways I will keep it brief. Basically users signup to create a bet, users ...
1
vote
1answer
24 views

Is this a good structure for a table?

Each user/person could know one or more languages. All I can think is a table like +----------+------+-----+------------+-----+-----+-----+-------+ | PersonID | Java | PHP | Javascript | C++ | C | ...
0
votes
1answer
38 views

create table from another table

I have master categories table like this category_id category_name parent_name parent_id 1 animals & pet supplies null 0 2 ...
0
votes
1answer
21 views

best way to store tags

I'm a university student building a web application for a project with three collegues , I took the database portion. Our site is basically a link sharing site and supports tags, what is an efficient ...
0
votes
1answer
44 views

Decompose table into third normal form

Tables X and Y are given as below : X (A, B, D, E, F, G, H, J) with A and B as primary key Y (K, L, M, N, O, P, Q, R) with K and L as primary key Now we need to decompose these tables into tables ...
1
vote
0answers
24 views

Best practices to segment people and attributes for advertising database

we have a database where we store people some attributes per person in the following tables: people (id, name, email, phone) people_attributes (id, person_id, attribute_name, attribute_value) ...
2
votes
4answers
89 views

Running Total: To store or compute

Say I have a product table with the following columns: product -------- product_id name And I have another table to record the transaction (IN/OUT) for each product product_transaction ...
0
votes
3answers
36 views

Unknown database file format .DAT

I am trying to find out the database name of this file. I opened it via hex editor: http://gyazo.com/5b579bd2ef9620aa833bf0743a480230 Any help is appreciated. Client sent me this file. It is very ...
0
votes
0answers
15 views

Nicely managed lookup tables [migrated]

We have a people table, each person has a gender defined by a gender_id to a genders table, | people | |-----------| | id | | name | | gender_id | | genders | |---------| | id | ...
1
vote
1answer
45 views

Which terms are used to refer a row in database?

I am creating a Java application, in which I want to create a class that will relate to a row in database. I decided to use Entity while naming the class with a prefix/suffix. But, This page says: ...
0
votes
1answer
63 views

Enhanced ER Model Supertype / Subtype modeling issue with inheritance and recursion

Before posting, I have looked for a good solution on internet and I have coined this post for 3 days in row and trying to think through it prior this post. So if I have missed something or got it ...
-2
votes
2answers
51 views

Databases Fundamentals [closed]

I have tried to learn about SQl Server databases but most tutorials are general or SQL-focused. I'd like to have a solid understanding of the fundamentals of databases so I can build successful web ...
0
votes
2answers
26 views

How to build a table for a private messaging system that supports replies?

I'm writing a private messaging web application in PHP, the application allows replies such that when you view a message, you also get to see to what was that a reply to, and to what was that a reply ...
0
votes
1answer
24 views

How to segment account info and profile info?

I am putting a rough SQL database design together and have gotten stuck on how to segment information about the users. (Note before I get into anything, stored passwords are salted and hashed, I just ...
1
vote
0answers
18 views

Is the table in 3NF?

I am creating a relational database - a library management system. I want to show an example where I normalize the data from 2NF to 3NF. My example of 2NF looks like The definition of third normal ...
0
votes
0answers
14 views

Multilingual Article/ Category database design

I wasn't getting any answers over at Programmers and was advised to go over here instead... I wanted to make a design for a multilingual database and after having drawn it up have arrived at 5 ...
0
votes
1answer
21 views

Which table(s) design option is better for users and clients? [closed]

Is it better to have CLIENT (an individual who purchased something) and USER (an individual with a login account) as: 1. single CLIENT table; 2. separate CLIENT and USER tables. Thank you for your ...
1
vote
1answer
30 views

design database with 2 simillar tables

I have a database which has product_sell and product_buy tables, these two tables are different in a few fields and each one has own comment table product_sell >---< product_sell_cmt ...
0
votes
0answers
28 views

Data-Duplication Vs Data Normalization. Better DB model?

I've 2 tables as follow:- Table UserProfile:- id name age gender phone city state country fb email and UserPoints Table having the following fields user_id activity_date app_point redeem_point ...
1
vote
1answer
47 views

Name for intermediate aggregated data [closed]

We have raw data and aggregated data as well as sometimes multiple levels of aggregation between. Is there a name for the data in that intermediate "state" of aggregation? Just like how we have Real ...
1
vote
1answer
43 views

Elegant Database Design

I'm trying to make "online Judge Environment"(like SPOJ). In which users have facility to see their past submissions for each question, their best code performance(like running time, if they succeed ...
0
votes
0answers
34 views

Forcing FK constraint to validated in system catalog

I have a big table (~60gigs, 35mill+ rows) that I need to add a FK to. Adding a FK directly to the table causes a validation which runs for about 30secs that I want avoid as it's a 30sec access ...
-2
votes
2answers
38 views

UPDATE() Function (Insert and Update Triggers)

Is there a way to have the column name dynamic in this function? For example, passing a parameter to a variable named @FldName = 'Name'. e.g. UPDATE(@FldName). Basically, what I want to do is to have ...
1
vote
1answer
26 views

Alternative approaches to “primary” record in child table

I have a database with a Customers table, and two child tables Addresses and Contacts, as customers often have multiple locations and contacts. However we also need a "primary address" and a "primary ...
2
votes
2answers
55 views

unusual relation, binary aspect

I have question very unusual for databases. I’m not a good English speaker, but good English reader :) so for explanation I’ll give you examples. Part1 In MySQL, I have two tables with relations ...
-1
votes
2answers
18 views

How can I create Data Base on phpMyAdmin?

I have a serious problem here. I am not able to create data bases as the option is not to be found on my phpMyAdmin, but it only shows 'No Privilege' in red font. I even tried to create data base ...
0
votes
0answers
3 views

SSMA not moving partition info from MySQL to MSSQL

I am trying to convert my existing database from MySQL5.x to MSSQL 2014. While all the table schemas gets ported from MySQL into MSSQL, table partition info are not being carried over. ...
0
votes
1answer
34 views

Ternary Relationship in ERD , What would the cardinalities look like in this situation?

I have 4 entities USER , COURSE , MODULE , TOPIC The Constraints go something like this. A Course contains one or more Modules and each Module contains one or more Topics Now, a User can study ...
0
votes
0answers
14 views

Data model for Object Versioning with Life Cycle Stages

I am looking for probable logical data model which will have the Object versioning capability like Version 1, Version 2 etc. and as well as Life cycle stages of each and every object. Please note that ...
1
vote
1answer
41 views

Database design import massive csv files is there a more efficient way?

I need to let users import huge csv files varied between 200k - 1.5m lines. For this I use LOAD DATA INFILE which is the fastest way to import those files. Thing is however that I can't check the user ...
0
votes
1answer
29 views

Big lists in a relational DB

I need to store a list of items and that list belongs to a single user. The lists are going to be huge, so this has to be done as efficiently as possible. The lists also have to be modifiable to a ...
0
votes
0answers
8 views

Dummy Objects vs. NULLs: optionality for three-way relationship

In a nutshell, I'm trying to model a relationship and can't decide whether to allow NULLs or to require values and use dummy objects (in place of NULL). Here are the details. I have three classes: ...
2
votes
0answers
12 views

Filegroup design for Document Table for BLOB Storage

I have a table for storing documents as VARBINARY types in my database (I'm not using filestream). My database is setup with only one data file, but I am wondering if there is a benefit to creating a ...
0
votes
3answers
100 views

What is the term for a “wide”, non-normalized view/query?

A well-designed relational DB schema tends to have a relatively large count of relatively small, normalized tables — a cluster of snowflakes, I think, describes the situation. In order to ...
1
vote
1answer
66 views

How to manage many-to-many relationships when there is also a hierarchy among the many?

I have these entities – employee, task, phase, project – and these relationships: project 1:m phase phase 1:m task employee m:m task, phase, project The first two relationships form a ...
2
votes
1answer
51 views

Scalable Relational Database Design

I'm designing a web application (using Django) for a client that will need a fairly large database behind it. I've never worked with databases that handle large amounts of data before so I'm hoping to ...
2
votes
1answer
18 views

Attribute-Attribute Dependency

So as part of our college project, I'm working on CENSUS Database. I stumbled upon a problem wherein if an individual is below the age of 18, his/her marital status should only allow 'NA' and anyone ...