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
49 views
Enforcing constraints “two tables away”
I ran into some trouble modeling an electrical schematic in SQL.
The structure I'd like to capture is
part ←────────── pin
↑ ↑
part_inst ←───── pin_inst
where "inst" is short ...
0
votes
1answer
34 views
How to structure a database to show data for each USA State and Canada Territory on a Per user basis?
I need to build a PHP/MySQL application. I am a bit confused on how to do the database for a project like I am about to explain though.
The end result will be a Map of the USA and Canada. Each ...
0
votes
1answer
14 views
Digital content eCommerce schema advice?
I don't have much experience designing databases, I'm looking for some advice on my design from more seasoned designers/developers. I'm developing a digital content eCommerce store which will be ...
0
votes
1answer
33 views
Does this medical database look correct?
I'm pretty new to databases and I'm trying to create some schemas.
I've been working away at this one for a while, but I can't help feeling that it doesn't look right.
Essentially I have the ...
0
votes
1answer
63 views
What is a bucket in database? [on hold]
I was implementing a code that involves a database and buckets. Just wanted to ask what is bucket and can someone describe it with an example?
Thanks!
0
votes
0answers
17 views
Impact of additional int field as primary key
Directly to the point, at one time I have a table like this:
create table item(
item_id varchar(50),
constraint pk_item1 primary key (item_id)
}
However from my discussion one day, there is ...
0
votes
0answers
13 views
install and setup pgpool2 with streaming replication [on hold]
I have already installed 2 servers and is using the streaming replication (postgresql9.1) on ubuntu 12.04 server, now I want to install and setup pgpool2 on different server so that I can do ...
0
votes
0answers
43 views
Understanding different methods for database indexing [on hold]
I am learning databases. In my class I was introduced to database indexing. I know what indexing is & there are 4 ways in which you can index
B-trees
Hash Tables
R-trees
bitmap
I understand ...
2
votes
1answer
32 views
Denormalize Design Modification
Our DBA is on medical leave, I am just a developer trying to do my part. Initially, the bean counters were going to use quickbooks. However, after seeing how much time they could save with custom ...
2
votes
1answer
47 views
Best way to store an unordered list? [on hold]
I apologize if this question has (undoubtedly) been asked before, however I've been hearing conflicting advice from colleagues and the internet.
I have a table of "groups" and each group has a list ...
0
votes
2answers
58 views
mysql forbidden database names
I was wondering whether there were a list of forbidden (reserved) database names in mysql.
For instance, mysql is obviously one. But is there a determinated list? I don't want to cover 99% in my ...
2
votes
1answer
31 views
What Happens when Cartesian Product is applied to Relations with same attribute name
I understand that the Cartesian product(X) operation on two databases does not need to be UNION compatible.So,if there is a same attribute called name in the two relations R and S where name in R is ...
3
votes
3answers
44 views
Why does data get corrupted in “large” text files - Reasons to use database
I am just starting to learn about databases and using mysql. I read that databases are more reliable than having large ascii text files and that ascii text files are more prone to corruption as they ...
0
votes
1answer
17 views
design DB review and check constraint for postalcode help?
Hi. I created this database to just to sharpen my skill. I have one Question - when I create I make the FOREIGN KEY personID in Addresses table but I changed it to be AddressID in Persons table ...
0
votes
1answer
33 views
Should I place my Quartz Scheduler tables in a separate database?
I am designing a web application that uses Quartz Scheduler to scheduler jobs.
I have Quartz configured to use a JDBCJobStore, so it automatically stores each created job in its tables.
I am ...
