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
0answers
5 views

designing a database with type and sub type

I am trying to build a publications database, and i want to develop a genre relation that has various (maybe look up tables) sub-genres attached. as an example, in the genre relation there would be a ...
0
votes
1answer
24 views

How to store a version sequence per product

I need to create a table like the following one: +----+---------+---------+ | Id | Product | Version | +----+---------+---------+ | 1 | 1 | 1 | | 2 | 1 | 2 | | 3 | 2 ...
0
votes
0answers
9 views

When to use tags vs binary fields in a constituent management system?

I have a table of Constituents and I want to track yes or no qualities like: are they a teacher? are they an elected official? are they philanthropists? There will be less than a dozen of these ...
-1
votes
0answers
20 views

Sequential file reading warning in datastage

When I try to load data from sequence file to oracle database, delimiter is '|', ETL Tool is IBM datastage 9.1, Compile was correctly, Load process finalize without any error,my issue is some rows ...
0
votes
1answer
132 views

How to model when you could have many (thousands of) attributes to a table (product)?

We have a main table, let's say, Product. It has several general attributes like 'Product Name', Manufacturer ID, etc. As of now, all these attributes are implemented in the data model as columns to ...
0
votes
1answer
34 views

PizzaShop - DB - Normalized Schema

I am trying to make a simple DB in Access for a theoretical pizza shop(the db is for an assignment). What I am trying to do is link one type of pizza to one or more types of toppings. I just wanted a ...
1
vote
1answer
105 views

Recipe Health risk Database ERD structure

I have these tables: First table(Recipe table), Recipe recipeid(PK,AI) recipename ingredients Second table(Ingredients table), Ingredients ingredientid(PK,AI) ...
2
votes
1answer
649 views

How to normalize my db schema for a quiz application?

I am putting together a quiz application. (I'm calling each quiz a "challenge") I have a "challenge" table and a "challenge_question" table which is pretty straightforward. challenge table: id ...
0
votes
0answers
16 views

Ideas for Database schema for Automotive web app

For the last couple of days I have been searching all over Google for database schema for my automotive web application[like a marketplace of sort](in Laravel 5 PHP). I have tried many models some I ...
0
votes
0answers
41 views

MySql Innodb Database Slow INSERT Query to Remote Server

I have searched thoroughly on how to improve general performance of my database which is hosted on Hostgator. I have mostly come across performance tuning strategies which are catered to only local or ...
3
votes
2answers
76 views

Split database to fit on SSDs

I have a database that's about 3TB in size and want to upgrade to SSDs. The SSDs I found that are reasonably priced are only 512GB so I'll need to purchase multiple drives. What are some ways to ...
0
votes
0answers
13 views

Database design question for sorta rookies [on hold]

Are there any books or Github examples of how to design a database for use with an android app. Specifically the user will be logging into the app via mobile device or Web browser. I imagine aside ...
-1
votes
2answers
29 views

Double entry bookkeeping database design

I'm doing an accounting software and I need to enforce double entry bookkeeping system and I have the classical problem of 1 row per transaction versus 2 rows. Lets take an example and see how it ...
1
vote
2answers
117 views

about giving same column name in every table of database

I have a database with 5 tables. In every table there is a column for checking status. If i give the name to that column which is same in all the 5 tables; What will happen? Is it correct according ...
2
votes
1answer
284 views

Database design for a table with both bulk insert and single row insert

I have to design a table where records will be inserted in two ways. Bulk insert from a batch process from a delimited text file between 2 - 3 million rows in a short burst. Later the same records ...
0
votes
0answers
14 views

Post categories model for a user submission wedbsite

I'm building an user submission site where users can make posts to content_types: Blog, Movies, Photos, Forums. Since these content types only have slight variances I would like to keep them in one ...
0
votes
0answers
14 views

Working on a blog creation website; should I be creating a new table for each blog, or keep everything on the same table?

So I'm working on this blog creation website as a side project. I don't actually expect it to become anything, but I want to make it as efficient as possible, even if just for practice. The idea is ...
2
votes
1answer
180 views

Handling a chat room in a database

I have been searching all day to find a better answer to my question but those I found was useful but do not critically analyse my question. I am building a chat room using php, mysql, jquery and ...
0
votes
2answers
49 views

how to store mp3 files in mysql database by using phpmyadmin?

first of all i am new to database, but i want a database for my site to store mp3 files in it so later i play them on my site by using jplayer. little though i know about database they said there are ...
2
votes
2answers
39 views

Do valid to/from columns on a fact table make sense?

I recently came across "valid from" and "valid to" columns on a fact table. Obviously this is common for dimensions but I've not seen them on fact tables before and can't find any info suggesting ...
1
vote
1answer
250 views

Design advice regarding a users/groups/tasks database scheme

Here are my requirements: one user can have many tasks one group can have many task one group can have many users only invited user by a user can be added into a group Does this db design appear ...
-2
votes
0answers
46 views

Looking for 3NF conversion of an unnormalized table [closed]

I have the following unnormalized table: CREATE TABLE unnormalized ( project_id int(11) No project_name varchar(100) No category_id ...
2
votes
1answer
212 views

Help with a scenario of music groups and members in ERD design

Can someone please show me how to construct this ER diagram with the following scenario? I’m confused with the ‘or’ part of it. Description An Artist has a Name, and must be either a Group or a ...
0
votes
0answers
31 views

Is below table is in 3NF, what can we do to make it in 3NF? [closed]

buyer_id int(11) No fb_id varchar(250) No gmail_id varchar(250) No buyer_name varchar(50) No buyer_email varchar(50) No buyer_password varchar(100) ...
0
votes
2answers
179 views

Idea for manking tables for a pharmacy

OK I'm not into Database management, but I got this problem, also not sure if I'm posting it at the right place or not. So, my Dad works in a pharmacy and all the work there is on paper and is done ...
2
votes
1answer
69 views

How to write a query, with multiple foreign key in mysql

I am working on a simple PHP and MySQL college level clinic management system. There 4 main table which relation with foreign key. I'm little bit confusing multiple foreign key in table .. what would ...
1
vote
0answers
19 views

Calculate Num_Index_Pages for sizing design

I don't understand Step2 #8 Calculate the number of number of non-leaf pages in the index. I am not sure I understand the "Level". I have Num_Leaf_Pages=508 & Index_Rows_Per_Page=476 I don't ...
3
votes
2answers
55 views

Why is vertical scaling expensive?

As you can find here Best Practices For Horizontal Application Scaling, vertical scaling is much more expensive than horizontal scaling: vertical scaling cost increase exponentially whereas with ...
0
votes
0answers
4 views

IBM Data stage compiler error

I have installed InfoSphere Datastage 9.1.2 on Windows Server 2008 R2, and also installed C++, but when I try to compile a job show error in transform stage.
15
votes
4answers
4k views

Plural vs Singular Table Name

How should I name my Tables when creating a new database? Singular: Client or Plural: Clients?
0
votes
0answers
27 views

Mysql - too many Deletion - Insertion

I'm creating crons for my OLAP sysetm, I have a cron that deletes the records from the summery table first and then insert the records in it again, Say Deleting 1 month records, and ...
1
vote
1answer
205 views

NoSQL approach: design table “scheme”

We need to store simple log data in a database, but we also need to get and filter data in realtime, based on 'user', simple 'tag' (ie. redis, memcache, php, mysql, etc.) and timestamp. We need to ...
0
votes
3answers
84 views

Which of these database designs is normalized?

I have two possible database designs. A) a many-to-many relationship between Branches and FiscalYears via a dedicated join table FiscalYearsBranches B) two (or more) many-to-many relationships ...
0
votes
0answers
26 views

Facing Failed to read stream error - mysql_native_password error

I have been facing the following error intermittently on MySQL. Authentication to host '127.0.0.1' for user 'root' using method 'mysql_native_password' failed with message: Reading from the ...
0
votes
2answers
178 views

Daily snapshot fact table

I have a list of products per costumer. Costumers can delete or add products to their list. I want to know in each day what is the list of products (and count) by costumer. My first approach is to ...
7
votes
1answer
452 views

Designing Simple Schema for Disaggregation of Demand Forecast

I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case: I have a parent-child hierarchy of products (example, Raw ...
1
vote
1answer
50 views

Make 3 separate tables, or 1 combined table for similar data?

When designing a database's structure, if we have multiple tables with similar data, should these tables be combined, with an added ENUM field to denote the table type; or should 3 separate tables be ...
0
votes
0answers
36 views

ERD diagram for online ticket reservation system [closed]

Simply, the problem is about to create sale and reservation system for bus transport company. The biggest challenge is to design database that it will be prepared to situation like this: The bus ...
1
vote
0answers
17 views

When to include and exclude products from a webshop database? [closed]

I'm working for a company that runs a webshop and integrates around 15-20 different merchants. In the database schema for the actual website/webshop (Rails with postgres SQL), products are only ...
32
votes
6answers
17k views

Best practices on common person fields (Name, email, address, gender etc…)

What are the most common best practices on length and data type on common fields like: First Name Last Name Address Email Sex State City Country Phone Number etc....
0
votes
0answers
19 views

Design Payment System - Best way to track different payment types and reasons

I am designing a system to track incoming payments from external entities. Payments will be stored on tblPayment and take place in different ways, to mention some: 1) cash 2) cheque 3) credit ...
0
votes
1answer
20 views

Modeling Optional Foreign Key from Composite Primary Key field (Oracle Data Modeler)

I am trying to add an optional foreign key in Oracle SQL Developer Data Modeler v4.1.0.873(Build 873), as per diagram below: The issue is that I can only make such a relationship if it is mandatory ...
1
vote
2answers
969 views

How do I normalize a database with lots of many-to-many relationships?

I am building a database that is based around a business project, in this case called a "Program." Each Program will have multiple Reports, Clients, and Partners. My first thought was to place each ...
1
vote
1answer
31 views

Database table data with different set of values

I am trying to create a database table for my project but I stuck in this type of data. The purpose is the admin can add, modify or insert types of questions and choices example: Do you like ...
-1
votes
0answers
26 views

SQL Broadband Market Dilemma [closed]

edit -- Hi I see this post has been closed. Not sure what that means, but I'm guessing I wont be getting an answer. Any idea on where I can go on the internet to get an answer. I've been on-line for ...
0
votes
2answers
53 views

Database Design - Cardinality

I am currently studying for my MTA Database Fundamentals cert, and I came across this question during my studies. However, the answer doesn't make any sense to me. Here is the question/answer: It ...
2
votes
1answer
39 views

10000 tenants and Muti-Tenant Data Architecture performance?

We are trying to decide on a database design for a new web application. We expect to have close to 10,000 tenants and would like to keep their data in separate databases if it makes sense to do so. ...
0
votes
0answers
10 views

Model Development Tips [closed]

Using MySQL I am trying to develop a database structure to store 'Religious Texts' for accessibility through the WordPress user interface. My goal is to provide 'scripture-level' query capabilities ...
2
votes
1answer
256 views

Building a branched versioning model for relational databases

I am database designer and at my current project I'm implementing versioning capabilities required to concurrently edit rows of data in RDBMS. The project requirements says, that data editing sessions ...
1
vote
1answer
25 views

What is the best way to represent an Team and player relationship in ERD

I am working on designing an ER diagram for a football system, i stopped in the relationship between the player and team, as we know the player plays for only one team and team have many players, so ...