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

BEST RELATIONAL DATABASES APPROACH FOR DELETE: use DELETE or use a valid/non-valid COLUMN?

When it comes to databases, which is the best technical approach to use when a user want's to delete his profile/delete some of his products from a shopping card: Actually delete the rows from the ...
0
votes
1answer
12 views

Query parent table and get child tables columns

I have two tables, one inherits the other: CREATE TABLE parent ( col1 INTEGER ); CREATE TABLE child ( col2 INTEGER ) INHERITS( parent ); Is there any way to query the parent table, such ...
0
votes
3answers
544 views

Two nullable columns one required to have value

No-Explanation Question: Is there anyway to have a constrain of 2 null values that always requires 1 to have value ? For example two date columns both null but having at least 1 that requires to have ...
0
votes
0answers
16 views

Database Design Question? Relationships and Form Data

I am working on a project that requires to store evaluation form data. Essentially, the a reviewer will fill out a form based on the performance of the person being evaluated. Now there is well over ...
3
votes
2answers
125 views

Is EAV an appropriate design for a collection of coexisting metadata-rich “fact estimates” on objects?

I'm attempting to architect a system that will collect estimates on various quantities (10+) on each of many (300K+) objects, and make decisions from the historical record of these estimates. For ...
0
votes
1answer
34 views

Does my database design work? Newbie!

I've uploaded an image of my database design below. This is the first database I have designed and I was hoping that I could get some input into whether or not it is set up correctly or if I just have ...
0
votes
1answer
18 views

Database design for a group-buying site

What is the best way to approach the database design for a group-buying site? If you are not familiar with group buying, people purchase a deal, and when "n" amount of people purchase the deal, the ...
0
votes
0answers
32 views

A transition table, is it a good idea?

I'm writing an application that stores a project's C++ API representation. For example, I have tables like Class, Function, FunctionParameter, DerivedClass, BaseClass, and so on. Every once in a ...
2
votes
1answer
32 views

BLObs – Should I Store In Database Or in Directory Structure?

BLObs – Should I Store In Database Or in Directory Structure I have been developing a database to replace an ageing data structure that contains 1000's of files within a directory structure. The ...
-5
votes
0answers
33 views

PHP problem using database [migrated]

$DB_HOST = "localhost"; $DB_USER = "root"; $DB_PASSWORD = ""; $DB_NAME = "practice"; $conn = new mysqli($DB_HOST,$DB_USER,$DB_PASSWORD,$DB_NAME); if ($conn->connect_errno) { printf("Connect ...
0
votes
1answer
28 views

Using the same table for entities that are almost alike when it breaks foreign key integrity?

I'm designing a website with a database that should support events that a user can sign up for, fx. a concert. Users can sign up using our internal registration system, or using an external website ...
0
votes
0answers
8 views

Store 100 GB of N-gram and fast access the N-gram [on hold]

I have a scenario where I want to store 100GB of N-gram like ngram = "who is" count = "1233432" where ngram and count are the field names. Just like this, I have billions of records whose approx. ...
0
votes
0answers
44 views

What is the name for a table that keeps track of operations that have been performed on the database?

It's name is Trans_Log It has the following fields: TL_User (database user logged in) TL_WinUser (name of windows user logged in) TL_Date (date of operation?) TL_Type (type of operation / function ...
0
votes
3answers
30 views

Prepopulate database with empty / null values [mysql]

What would be the best way to pre-populate a database with 100 empty fields and then begin the Auto_Increment? What I mean to say, I want to reserve the first 100 userfields (ie UIDs which are ...
0
votes
1answer
26 views

How to save the design of an Access database — not the content — as text?

How can I save the entire design or specifications of an Access 2007 database -- not the data content -- as text, and reload after making edits to the text version of the design? I have fallen foul ...
0
votes
0answers
32 views

How to reference a table mapping that is not initially known in another table

I have four tables: ExternalName, InternalName, ExternalInternalNameMap, and Transaction. ExternalName and InternalName have a many to many relationship. ExternalInternalNameMap is the junction table ...
0
votes
0answers
13 views

Primary keys: composite and singular

In general when I design tables I always include a single unique field, even if it there is already a unique combination of columns available to create a primary key. This field is usually either a ...
1
vote
2answers
54 views

SQL Server 2012: set a column to only use a single case?

Is there a way to tell SQL Server 2012 to store both A and a as A (or both A and a as a) for some given column such that every insert statement does not need to have UPPER() in it?
0
votes
0answers
14 views

How to create and select entities in MongoDB?

I'm a newbie in MongoDB and I'm trying to understand how to create objects there and how to select them in comparison with relational databases. So I need an example how to perform these things. ...
0
votes
2answers
46 views

Excel spreadsheet into a MySQL database tables

I am relatively new at database design and would like to get this right from the start. I have had differing advice on how to do this and believe that the common suggestion of importing all the data ...
2
votes
1answer
243 views

SQL table architecture

I'm looking for a SQL architecture solution for the following problem. The idea is that I have a validation form that contains the client's data. Each client can log in to his account and edit his ...
3
votes
1answer
379 views

Removing “duplicates” within a time range

I have a table that contains number plate data with a date and time stamp, collected by a plate-reading CCTV camera at a site entrance. Vehicles stopping at the site entrance will create multiple ...
5
votes
1answer
915 views

Designing a database for a site that stores content from multiple services?

I'm building a site that implements David Allen's Getting Things Done that pulls in your email, Facebook newsfeed, tweets from those you follow on Twitter, and more services are planned. The problem ...
4
votes
1answer
628 views

Database table design question

Firstly, database novice here. I'm trying to create a system for processing Sales Orders into Purchase Orders and then split the Purchase Order into Shipping Containers. The systems needs to be able ...
1
vote
0answers
10 views

What is the difference between 2 phase locking and strict 2 phase locking?

2 phase locking is used to ensure isolation of database transactions (by ensuring serializability). But there is another term called Strict 2 phase locking. I find it hard to understand the ...
2
votes
1answer
729 views

Designing a reservation system schema

I am not sure if this has been asked before, however I am tasked with designing a new reservation system for my organization We have an older system which simply stored the booking in a table, and it ...
0
votes
2answers
121 views

Make DB tables customizable from an Admin

I want to build an commercial product promotional mobile application in which the administrator of the app will be able to customize some texts / pictures or whatever from the database that ...
0
votes
0answers
13 views

Lab result table for database [closed]

I am designing a demo database for class project. I got some sample data from a clinic and I am looking for an efficient way to design a table for lab results. I found similar question on the forum ...
0
votes
3answers
461 views

Rent weekly cost database design

I have a database which contains a table BUILDING with in each row details about some building, another table BUILDING_UNIT contains rows with details about a single building unit which refers with a ...
1
vote
1answer
41 views

Use a set database schema or EAV design? [duplicate]

I have already created a database design with a set schema. The database schema is for a web quotation form. PS it is not a simple quotation form and hence need to customise the form, form builders ...
1
vote
2answers
99 views

Dimension or Degenerate Dimension?

I am taking a course on data warehousing. Currently, I am reading through Ralph Kimball's Data Warehouse Toolkit. I understand that a degenerate dimension is a dimension key that is stored in a fact ...
3
votes
2answers
56 views

Calulating savings between two schemes

I've normalized a single table to reduce the number of nullable columns from 3 down to 0. The idea was to save a little drive space but I'm seeing a 45% decrease in space needed to store the same ...
0
votes
1answer
97 views

Complicated data

I have a requirement i got from my father. He gave me a table and wanted me to digitalis it. So that he can the system can do all the dirty jobs for him ( that's why there are developers in the world, ...
0
votes
0answers
34 views

Why to separate DDL from DML? [closed]

I have a very basic question about DMS I want to ask why we separate DDL and DML into different languages and in general why Database creation tools is different from data manipulation and control ...
1
vote
1answer
225 views

Designing a High Score/Leaderboard table

I'm looking for input on how to design a highscore table for a game I'm creating. The database I'm using is postgres. That's not really something I can or want to change (unless there's very good ...
1
vote
0answers
17 views

What are my options in creating this Location table?

Say I have an Items table. Each item has a location associated to it. This location can either be a city, a state or a country. I believe this could normally be solved with a column Type in the ...
0
votes
2answers
48 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 ...
0
votes
1answer
89 views

Fetch data from database from multiple tables matching condition

I want to fetch data from the database. I have three tables in my database like listing_master_residential and listing_master_condo and listing_master_commercial. There are three tables and there is ...
1
vote
1answer
872 views

How do you structure a database that allows for groups to be formed/added by users and also be a part of like facebook?

I'm new to databases and web development so a laymen explanation is best for the time being. I'm only in the data modeling phase so no need for specific code. I'm just trying to wrap my head around ...
1
vote
3answers
111 views

Text Storage and Database Design Optimization in a SQL Server Database

Given a database with a number of columns (c), where some of these columns contain text that is one of multiple values due to a set CONSTRAINT on the columns, what is the most efficient way to ...
0
votes
1answer
42 views

Database Design Issue or data issue? [closed]

I have been working on a database with some friends for out media collection. The purpose of the database is to be an inventory of what we have and a way to help us find something to listen ...
0
votes
1answer
42 views

Normalising Customers and Employers with a people table

At what normalisation stage is it recommend to split say Customers and Employees into a people table and then link to the unique attributes of Customers and Employees. I cant seem to find the ...
-1
votes
0answers
22 views

DBMS Project (SRS to ERD mapper) [closed]

suppose you a are a IT profession & you have a final year project a specific format provided in which user put requirement in the form of paragraph & click generate button to ER diagram. My ...
0
votes
1answer
17 views

Which one is best solution for future database structure?

I'm working on a big web application. so i need to create user_preference_table it has the marks for every users for each attributes. here attributes are games so in the user_preference_table i need ...
2
votes
1answer
512 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
1answer
19 views

Help me define the tables in this scenario

We have 2 tables setup like this: WEB_GK_STATE PRG_CODE Varchar2(5) STATE Varchar2(2) WEB GK PRG_CODE Varchar2(5) TEXT Varchar2(4000) Here is some sample data: ...
2
votes
1answer
231 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
2answers
24 views

Can we determine FDs if we are given some tuples?

I am taking a databases course and i'm learning about functional dependencies. I have searched around and did not find any information on this. My questions is if we are given a table with some ...
0
votes
0answers
22 views

Uber-wide tables: Time to switch to Mongo?

As a web developer, I've typically only worked with nice, normalized tables in SQL-based RDBMS, but I'm doing some data consolidation for a researcher who will be analyzing correlations between all ...
0
votes
0answers
18 views

Advice for a friendship table

For my little project I would like to create a very simple friendship system. And I would like someone to give me some advice/criticise the current design I have. Here is an example of my friend ...