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.
2
votes
1answer
9 views
What are the risks for logging across databases via a trigger?
I've searched for this online and had mixed or unclear responses, and after posting on superuser, was directed over here.
On SQL Server 2005, we currently log certain table changes via triggers using ...
0
votes
0answers
10 views
Database Design Confusion
I am making a Phonegap based ERP solution for school in which every school can configure their own school individually and can manage the whole school from that single application, in which a main ...
-1
votes
0answers
23 views
Types of databases [closed]
I'm curious about these databases, and I've never heard of them before. What is the answer to this question?
You store all of your photographs on a web site that uses a database to store the photos ...
0
votes
0answers
10 views
How to handle “many columns” in OLAP RDBMS
I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store this in to a column-oriented DB and perform cube analysis on it.
I tried to design a star ...
1
vote
1answer
50 views
Oracle database created whats next? Create Schema or Create Tablespace?
I'm a programmer that's being thrown to the DBA/Sysadmin island all by myself with a volleyball that I named Wilson. I'm trying to survive here.
I'm supposed to create a database for an application. ...
1
vote
1answer
78 views
Separating tables vs having one table
At the moment I have a table setup that looks somewhat like this:
create table tbl_locationcollections
(
id int(11) PRIMARY KEY IDENTITY, --(Primary Key),
name varchar(100) not null,
...
2
votes
2answers
87 views
Is it ever a good idea to denormalize for integrity?
I'm using Postgres 9.2 to develop a quiz app, in which I present the user with a series of problems and record their answers.
These problems can take a variety of forms - they might be multiple ...
1
vote
1answer
40 views
Table for optional parent/child relationship
Assuming we have the following table: Item, Parent, Child and Parent is the parent of child.
The item can either belong to a parent or child and not both.
I have other tables that are similar to ...
0
votes
1answer
83 views
What is the correct model for related tables with millions of rows?
I need to create a question and answer tables that will have millions (maybe billions) of rows.
The current model is:
Question Table
id_question (PK, auto increment)
id_user
question_content
...
-1
votes
2answers
59 views
checking number of occupied occupied neighbours [closed]
Assuming a pixel grid with x and y of the size 1000 over 1000. In each iteration\run, using a random number generator, certain cells will be marked as occupied. Those cells will be written in a SQLite ...
1
vote
2answers
228 views
Multiple parents and multiple children in product categories
I am making a ecommerce site. In this site I want to categorise the items into three different layers
primary category sub category sub category
>>electronic ...
0
votes
1answer
70 views
Database setup/design for multiple services
I am working on a new MySQL database that will store orders/customer information for around 15 different services. 7 of the services are similar in regards to the information that is stored with a few ...
0
votes
1answer
24 views
Database for opening times of locations
I'm designing a database for opening times and created this solution.
The specifications of the database which will be a MySQL are, that a location have standard opening times in a week and can ...
0
votes
1answer
33 views
Defining system scope and boundary
I have been given a homework task where I am to create an ER model of a database from a set of client requirements. Another part of this task is to create a diagram that shows the scope and boundary ...
0
votes
0answers
28 views
Database with history journaling [closed]
In the database I need to store a data about vehicles (about 240 objects), their locations, working job, etc. In my table this info stored in one table. User should not input everyday this info. It ...
