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
21 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
7 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 ...
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
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
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
39 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 ...
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 ...
0
votes
0answers
12 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 ...
3
votes
2answers
75 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
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
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 ...
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.
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 ...
-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 ...
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 ...
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 ...
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 ...
2
votes
1answer
68 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 ...
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 ...
-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 ...
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 ...
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 ...
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 ...
0
votes
1answer
62 views

Can I have more than one relationship between two tables? [closed]

I want to make database for report maintenance. I have 3 tables: employees header_maintenance_report detail_maintenance_report employees table I have employee_id and then in the ...
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 ...
0
votes
0answers
26 views

Career Database Design

I am new in cakephp, I want to develop a simple career website, I have design the database, but I would like to show it to professionals and know if the structure is ok Jobs - id - job_title - ...
0
votes
1answer
27 views

DB Recommendation While Minimizing Size

I apologize if this question is too specific, if it is, please let me know! I have searched around both on here and the web on selecting the best project-specific engine to fit your needs, and have ...
0
votes
1answer
23 views

Load & traffic balance best practices

I am about to design an enterprise solution for a large scale application in which a windows service, MVC, and many other projects will use a database, so I am thinking about load balancing and best ...
0
votes
0answers
30 views

How to interact with a foreign key in database [migrated]

I have been working on a database for sometime now and i got stocked a particular section. I am trying to write a code to control the foreign key column in a database. mysql is the back-end and Java ...
0
votes
0answers
29 views

What is wrong with my ERD?

I am trying to create a reservation/booking ERD. Is their anything wrong with my current ERD? It must show a supertype and subtype, and it must identify attributes for regular, weak, and associative ...
2
votes
2answers
30 views

Table design question for a `Check all that apply` survey

I'm looking for advice on a design for a portion of a table. Background We're collecting survey data for multiple sites, and one question is a check all that apply. Currently, there are from 2-5 ...
0
votes
1answer
16 views

How is time stored in the FireFox sqlite database “places.sqlite”?

How is time stored in the FireFox sqlite database "places.sqlite" ? Looking to modify the stored visit time on a few entries but I can't seem to figure out how to, is it encrypted?
0
votes
1answer
31 views

Social file sharing database schema

I have a project called social media file sharing. I have this database schema and I need your opinion about what I should remove or add or edit on my database schema. Every user can upload media ...
0
votes
0answers
36 views

Find the Minimal Basis

Suppose we have relation R ( A ,B ,C ,D ,E ) , with some set of functional dependencies, and we wish to project those functional dependencies onto relation S(A, B, C). Given the functional ...
0
votes
0answers
22 views

Promo Codes - should I create a separate table or add a code column to a join table for Students and Courses

I'm creating a promo code and invitation system and I want to understand the best way to structure the database to include the Promo Codes. This is what I have currently: User: has_many Courses ...
0
votes
0answers
42 views

Is there a way to check which views have data? Oracle 11g

I'm undergoing a cleanup process for a data mart design. However, I want to get rid of any views (in the design) which result in having 1 or less rows of data. Instead of manually going through ...
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
1answer
25 views

(MySQL) user table and profile separate, or same table?

I'm creating a blogging site that anyone can sign up and be an author for. I want each author to have their own public profile. My main question is; would it be better practice to have a separate ...
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
0answers
12 views

App with ETL like operations - pull back small sets or one large set?

The problem Have an application that needs to provide back a result set from a normalized database into a single result sheet that is highly normalized for processing changes in excel. Must be ...
0
votes
0answers
57 views

Advice designing a stock management database

I am developing a webapp for my business, a mobile phone repair shop. The problem I have is I don't know how exactly to implement a way to manage the parts inventory. Here what i have now: ...
-3
votes
1answer
33 views

how many tables do i need to create in MYSQL [closed]

can anyone tell me or help me with this please how many tables would i need to create in MYSQL?
0
votes
1answer
30 views

No suitable driver found Orientdb jdbc driver

I have some problems with Orientdb driver for jdbc. i´m using Netbeans, i have include the library JDBC+OrientDB libraries (orientdb-jdbc-2.0.8-all.jar) in the directory and in netbeans, i have also ...
0
votes
1answer
43 views

Having four different tables or having one table with one more field?

I have a website with 4 translation (That is Arabic with 4 different Persian translation), and I had exported each of these translations to different tables. Which one of these ways are faster and ...
0
votes
1answer
31 views

How to design a main list and sublists schema

I am finding it difficult to design a database schema for a list feature. there would be a master list which then can be subsectioned into further lists. each user is able to mark a candidate as a ...