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
1answer
20 views

Database Design For Social Network apps

I'm going to build a social network app. Each user will have photos, videos, details, posts etc. My question is when a new user registers, should I generate many new tables for that user or have one ...
0
votes
0answers
13 views

How can I improve this data model for a water billing system? [on hold]

Basically, I would like help to improve this data model. Is this model a good one, or can it be improved?
0
votes
0answers
6 views

Couchbase data modeling

I come from the RDB world, and I'm getting started with NoSQL. So please consider that when answering. I have two Buckets: Apps and Users. A user may be subscribed to N applications, and every app ...
0
votes
0answers
12 views

How to store user defined scoring formulas?

First post, so apologize if I have not chosen the best spot for it: If I had table of values, let's say corresponding to a question number and its corresponding answer, what is the correct way to ...
1
vote
0answers
22 views

Why can't we have multiple cascade paths?

You can see that many questions have being asked about multiple cascade paths. For example: http://stackoverflow.com/questions/851625/foreign-key-constraint-may-cause-cycles-or-multiple-cascade-paths ...
0
votes
1answer
15 views

Handling of Topic Drill Downs in Databases

I have a requirement wherein I have to set up a drill down feature. For example: There is a tab in a shopping website "Men". Now if we click on Men we will get more topics like "Clothing", ...
0
votes
1answer
19 views

1 to N relationship on a product shop database design

imagine this scenario: I want to run a database that keeps track of all the purchases that every customer makes. So i'll have a purchases table along a customers table and a prodcuts table. The thing ...
0
votes
1answer
17 views

Inbound Outbound Shipping Database

should we combine both inbound and outbound shipping into a single table (then create an additional column to identify the direction) or to split them into separate table? What's the pros and cons?
1
vote
1answer
42 views

Understanding a notification system

I have been looking into how to build a notification system on SE and elsewhere and found myself drawn to the solution that is the accepted answer here: ...
1
vote
1answer
30 views

Bicycle Sharing Scheme - ER Diagram

Please compare the directions below to my ER Diagram and tell me if anything is wrong with my ER Diagram Please I think its accurate enough. Oxford City Council is preparing to launch an innovative ...
0
votes
2answers
28 views

Is following way is right Database model for following problem?

I am new to the database design so I have to check my data model is correct way to handle the problem or not. Problem Statement: I am designing the database for student portal which have following ...
0
votes
0answers
12 views

Storing table history - is this a good use case for Postgres's table partitioning / inheritance?

I currently have a products table which stores product information (title, description, tags, manufacturer, etc.) for a website. I would like to store historical information of changes to this table ...
0
votes
0answers
22 views

Most efficient way to store a large, changing number of properties

I have an entity with a large number of boolean properties. It currently has ~100 properties It will periodically get new properties The number of properties will grow to 400+ There will be ...
1
vote
1answer
62 views

best design for my data storage

I am looking for advice on storing rows of data. What I have a bunch of users (id), and data about their activities. Each user can perform a type of activity (type_id). And then about 20 columns ...
0
votes
1answer
14 views

Issue with forming correct relationship between subtype and another table in ERD

The focus is on the Cashier table and the Cash Accountability table. The rule is that only Cashiers have Cash Accountability and a Cashier ideally only cashes out once per day. Before I changed the ER ...
0
votes
0answers
26 views

2PL and Real Application Contest, a 2013 Questions? [on hold]

In 2PL (two phase locking), what advantage(s) does the rigorous model have over the strict model? I) There is no advantage over the strict model. II) In contrast to the strict model, it ...
0
votes
0answers
21 views

database design for address parts (county, city, district)

I am working on a data model for an application that is being developed and I'm not sure how to handle the address parts. Companies have one address. The address is split into county, city, ...
0
votes
1answer
18 views

Lab test database modeling help

I have a database design problem which I need some help with. I am developing a database to store some engineering lab test results. But the main problem I am running into is that each Test is ...
1
vote
2answers
49 views

Many columns vs few tables - performance wise

Yes, I am aware that data normalization should be my priority (as it is). I've got a table with 65 columns storing vehicle data with columns: used_vehicle, color, doors, mileage, price and so forth, ...
2
votes
1answer
28 views

Design for m-to-n relation with unidirectional attribute(s)

Assume I have a Table StackBox that holds items as Item. I allow StackBox to have multiple Item and I allow Item to be in different StackBox. It is obviously an m-to-n relation. Solving this with an ...
1
vote
2answers
62 views

Normalization of library book table with multiple authors

I have a database structure with two tables: The first one is called Author, has two columns (AuthID, AuthName) and its Primary Key is (PK_AuthID). The second one is called Book and has three ...
1
vote
2answers
24 views

professional services (consultants) resource allocation system

I am developing a resource allocation system using PHP and mysql. I have consultants and projects and I need to allocate the consultants on to various projects for various periods of time on various ...
1
vote
2answers
44 views

Organize repeating timestamped values in schema

I am creating models to hold some financial data. The information frequently is split into timestamped values, e.g: Some value, now | as of Jan 1st | as of Jun 1st | as of Sep 1st There are ...
0
votes
1answer
45 views

Database Design / ER Diagram - Help Needed

Please take a look at this ER Diagram that I started. I just don't know if I've set it up correctly (I have not made any relationships yet). I just want to know if I have the appropriate "Tables" or ...
1
vote
1answer
34 views

Rich text: VARCHAR, TEXT or BLOB in MySQL

Question: In my web application (php/MySQL) I will be saving rich text. This may be anything from a couple words to several pages length essay. I’m sure I could get away with using VARCHAR, TEXT or ...
0
votes
1answer
50 views

Database design: Is there a much better way on this current relationships?

I have a facultyand studenttable to store each information, respectively. I made a contacttable to store the contacts of either faculty or student. I would like to use the contact table as a generic ...
1
vote
0answers
19 views

A design pattern for category features [closed]

I work for a system which has these tables: products , categories , features User wants to add some feature like color dynamically. Which of this following ways are true? First one: Product ...
-1
votes
1answer
58 views

Switching from Oracle database to Ubuntu [closed]

I need support please. I am the CEO of a Life Assurance company. We are currently building our own core application under the leadership of my Head of ISD. We are using Oracle for our database and ...
1
vote
1answer
46 views

Database design/structure for address details [closed]

I am trying to design database. I have one problem related to addresses. The will be different types which will have addresses, for example Companies, Persons. I am not sure how to design my database. ...
1
vote
0answers
25 views

Most effective way to manage a growing list of time series data in an MS Access database

I am building a database to store time series data along with some other summary statistics. Since this is a local application I do not have access to more robust database solutions and am confined to ...
0
votes
1answer
27 views

ER Diagram - View Intergration/Centralised approach

Could anyone enlighten me on the difference between a view integration and centralised approach when designing a database, and how the ER diagram can be used to illustrate upon this; can't seem to ...
0
votes
3answers
51 views

Schema Design with “Seasonal” Data

I am developing a SaaS web application for School Management. What I need help is this: The whole application is purposed for the current year that the School is in. However, some data and ...
1
vote
4answers
92 views

T-SQL insert value based on identity column

Is it possible to have a table with PK based on Identity columns? Lets say I have a table of customers, two fields are important for our case Id which is PK nvarchar(20) and SequenceId which is int ...
0
votes
0answers
11 views

Mysql copying from varchar column to a decimal coulmn [migrated]

I have a column in MySQL table (First table) has varchar data type, I used JDBC driver to insert data of numerical data type on the mentioned column . Why I choose varchar data type of this type? ...
0
votes
0answers
50 views

ER Diagram Issues

I'm currently working on a project and I just can't figure out how to setup the portion in "BOLD" and any help will be greatly appreciated. Oxford City Council is preparing to launch an innovative ...
0
votes
2answers
14 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
28 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
32 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
16 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
25 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
33 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
51 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
24 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
52 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
57 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
38 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
40 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 | ...
1
vote
1answer
25 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
42 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 ...