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
7 views

DB Design for Mobile App Clients

Hello I am new to designing DB for Mobile App where speed is the Key. My Mobile App will request to WebAPI and WebAPI will get data from MySQL. I have designed my tables in MySQL as per relational ...
1
vote
2answers
26 views

Should a table have a foreign key to another table if it already has a foreign key to another table that has that foreign key?

That was a hard title to digest even for me so I'll break it down. I'm very new to SQL, and I just designed my first database. I also am not very good at JOINS which might be the answer to my ...
0
votes
0answers
10 views

Creating many-to-many relation on demand?

Users can join projects. Projects can have many tasks. Each user completes the task at their own time, they can also have some other user specific settings on the task like the priority in their ...
1
vote
0answers
9 views

Is this a good way to model course assignments?

I'm having trouble designing a data model that allows for the following: Courses can have many assignments. Assignments can be defined recursively. e.g. "There is reading homework every tuesday". ...
0
votes
0answers
16 views

Entity ID field that can refer to multiple tables?

In designing both audit tables and notification tables, I've run into an issue where I need a row to refer to an entity in another table, but which table that entity is isn't always the same. For ...
0
votes
0answers
9 views

Merging Multiple SQLite DB's While Retaining Duplicate Data?

I have 8 SQLite databases that i need to merge. The problem is, they all share the same unique ids (but different data for these ids). Table 1 is for accounts and each account is assigned a unique ...
0
votes
0answers
11 views

Requirements for Setting up mysql cluster [on hold]

I am very new to MySQL cluster, have been reading a lot online but could not find answers to my questions. I am setting up a MySQL cluster for an application that may scale in months to come. ...
0
votes
0answers
18 views

Creating a flexible table containing prices and periodes

I'm creating a system of availability for rooms and with a calendar according to the days, with every day have it's own price. Room Type | 01 | 02 | 03 | 04 | 05 | ... | 31 | ...
0
votes
0answers
17 views

table design approach for a rental application with several one to many relationships

I'm trying to go about designing a database/tables for the following situation I'm being presented. I'm developing a rental web application with MySQL as db engine. It is for a nonprofit organizations ...
0
votes
2answers
37 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
41 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 ...
0
votes
1answer
35 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
26 views

Sequential file reading warning in datastage [on hold]

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
20 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
54 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
22 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
15 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
78 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
51 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
20 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
6 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
28 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
47 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
38 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
85 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
71 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
20 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
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
2answers
54 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
63 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
24 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
30 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
33 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
43 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
21 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 ...