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.
0
votes
0answers
7 views
what is the best way to update 2 tables via data entry form in access 2007 database?
I have a database with more than 500.000 records, I use Table_a to Accession the files by the ID number,and Name, Date, Address, Tel, .....
And then i use Table_b to archive files and get the position ...
0
votes
2answers
39 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
1answer
37 views
Changing primary key from varchar to int
I am having user table where i am using varchar as primary key.
Now from different place I got the performance of int is better over varchar for priary key.
So i would like to change my primary key ...
0
votes
2answers
65 views
How do you store tabular data in an RDBMS?
First: I really haven't got any idea how to google for this. If you got one, leave a comment.
If I want to store arbitrarily large tables in a database, how should I set up my database tables?
...
2
votes
0answers
60 views
+50
Relation to original tables or to existing linking table
In my database I have a table with different settings for my app. Each setting is in relation to a guest (table guests) and an event (table events). So basically each guest has specific settings for ...
1
vote
2answers
14 views
Database model: doubly linked list
I am not sure if I get this right. I'm designing a database model for use in an application, and I'm stuck at a doubly linked list (model first; there is no code yet).
There's an order. An order has ...
1
vote
1answer
48 views
Record versioning and promotion
Let's say we have this hierarchy:
-World
--USA
---WA
----Seattle
-----Downtown
------1st Ave
-------945 1st ave
------3rd Ave
...
-1
votes
0answers
62 views
Effects of good and bad database designs [closed]
I want to know what effects good and bad database designs have. Any ideas which can be added to the list below will be very helpful:
Effects of a good database design:
Little or no data redundancy ...
-1
votes
1answer
27 views
The network path was not found error after deploy application [closed]
i have been deploying and publishing my application for quite a bit now and everytime it worked fine. Now i published it again (no error, warnings,..) and updated my sql database tables like i do ...
6
votes
4answers
233 views
How can a database be normalized when an optional field causes denormalization?
Suppose you have a warehouse full of widgets. Each widget in the warehouse is stored in a specific identifiable location within the warehouse. You might have a schema which looks like this:
A ...
0
votes
1answer
23 views
dimension table with “like” condition
In an effort to scale some existing code, we are removing logic from CASE statements and putting it in dimension/lookup tables. Thus instead of CASE WHEN 'F' THEN 'Female' WHEN 'M' THEN 'Male' is now ...
0
votes
2answers
36 views
Usage of foreign key when the referenced table data will not change
I have to design a table where user has 10 fields and 6 are dropdown. Some are single selections and some multiple. Dropdown data is supposed to change very rarely.
For e.g., the user is presented ...
0
votes
2answers
43 views
Is there a good reason to store big text data outside database?
I was analyzing my MySQL database performance and found that tables containing text fields are just huge, larger than 1Gb.
This data is only used when loading single record (like article or blog ...
1
vote
1answer
22 views
MySQL Workbench connect to MS Access
I have a .mdb file on my computer that I would like to convert into a MySQL Schema and I have found that there is a migration tool within Workbench. However it doesn't seem to allow you to connect to ...
0
votes
1answer
27 views
3nf but waste more storage space
I have a table which has three columns: account, idNumber, and position. The account and idNumber are unique.
Here is my thought to analyze and I don't know whether it is right or not.
account is ...
1
vote
1answer
61 views
Database design: Two 1 to many relationships to the same table
I have to model a situation where I have a table Chequing_Account (which contains budget, iban number and other details of the account) which has to be related to two different tables Person and ...
0
votes
0answers
42 views
When to split a large table
I run the SQL Anywhere DBMS, and we have a table of about 10 columns(normal text, timestamps etc).
However, in my use-case, every single day, the table gets 2160000 new rows.
It's also crucial that ...
0
votes
1answer
15 views
Table Design for user-specific and user-agnostic criteria
I want to design a table that is general enough to accommodate an increasing number of achievements as I come up with new accomplishments to reward. Initially, I thought to design the table as ...
0
votes
2answers
41 views
Time series data for ad platform
I am trying to figure out how to store time series data for an ad platform I am working on.
Basically I want to know some strategies/solutions for storing billions of rows of data so that I can ...
3
votes
0answers
93 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 ...
2
votes
2answers
80 views
Recommendation for mySQL table structure (no code)
I need some advice on how to layout the tables for a mySQL database.
I will first describe what I am trying to do:
I have a table for users. (This covers basic info for now)
A user will select a ...
0
votes
1answer
51 views
When is it worth it to use Triggers and stored procedures/functions? [closed]
As an example, lets say I have a forum application and for every topic that is created, I have a trigger that fires a database function creating a post.(lets assume we have a topics table and a post ...
0
votes
4answers
32 views
Are all matching indexes (indices) searched for a query?
If I have multiple indexes that include a common attribute - will each index be searched upon a query involving this attribute? Or is only one index searched?
1
vote
0answers
56 views
Database Design: separating reusable & instance data
I'm developing an app which is basically a collection of checklists that have to be processed. I obviously need a database in which the information has to be stored. I just can't wrap my head around ...
3
votes
0answers
104 views
Where and how to store my weird datamart
I could really use some help here.
Here's my situation.
I'm building a datamart in SQL Server 2005, which will furnish a single report (for now). We have 26 clients (medical organizations) that ...
-1
votes
1answer
48 views
DB Design - Which of the two is best-Normalized or Not [closed]
Please see the analysis below and let me know the best db design (InnoDB) out of the two.
Requirement- Faster Write and Read for users not having to wait when many concurrent DB connections exists, ...
3
votes
1answer
46 views
How to share resources among accounts?
Using google doc, I am able to share my documents with others. I wonder how they implement it underlying in terms of DB design?
The simplest way I imagine is to use a joining table which keeps a ...
2
votes
1answer
38 views
One database or multiple referencing one?
Database design: one database or multiple databases, which is best?
We have a database which has about a 100 or so tables, accessed by about five different applications. Five different applications ...
1
vote
1answer
36 views
Multi-variance products
My current system houses different variants of Products in different tables;
Productgroups
Productcolors
Productsizes
Productmodels
Products can reside under 1 Productgroup and can have ...
1
vote
1answer
31 views
How to “swap” out production tables
I have a MySQL table that holds a few thousand records which go out of date very quickly. A few times a day we run a slow process which needs to pull data from multiple sources and re-populate the ...
0
votes
2answers
39 views
Using a keywords table with multiple other tables
Using MySQL
I need help determining how to model a Keywords table to three different tables (Products, Certifications, and Exams) - I have included my model which is using what I refer to as ...
0
votes
1answer
52 views
How should I set up my social network database design?
I am designing a db for a Social Network type website where users enter lot of information varying from family member details, education, employment, personal favorite such as TV, movie, music, food, ...
0
votes
2answers
50 views
Can a surrogate key and a primary key be in the same table?
For example we have:
Surrogate key: ABC123
Primary key: 1
Name: James
Is this legit in a Data Warehouse table?
2
votes
2answers
46 views
notes / description string in another table in a relational database
I'm primarily a non-database developer, however I am familiar with normalization techniques.
A coworker was suggesting that it is correct for a table to store 'description' and 'notes' as a foreign ...
0
votes
0answers
8 views
Fine grained (milliseconds) temporal indexes in neo4j
What are the best practices for modeling fine grained timelines in neo4j? If I were to use milliseconds as the grain in the pattern described here and here would it prove somehow problematic and ...
-2
votes
0answers
33 views
Database Design [closed]
I have a requirement like creation of database design for examination of school student.
There we have different types of exams like quarterly exam, half yearly exam and the final exam. For each class ...
3
votes
2answers
44 views
Table design when one data is dependant of another and the second one has repeated values
I have a products, and subproducts.
Like:
Product Identifier - Product Name - Subproduct Identifier - SubProduct Name
1 ProA 1 SubProA1
...
1
vote
0answers
28 views
Need help to design model with multiple rights
For a website, I have multiple elements that need to be moderated by many different users.
Until now, I have always used Role-Based Access Control (RBAC) model but I want a more flexible model. I ...
0
votes
1answer
33 views
How to link several tables?
I'm a newbie at Database Designing. What I want to do is perform several actions at once.
I have a main users table which holds all the data for a user at a website. Then I have a primary key as the ...
1
vote
1answer
67 views
What is the meaning of this anomaly warning message?
I have run an analysis with SchemaSpy.
The tool gave me a warning message for two tables. The warning message is:
Tables with incrementing column names, potentially indicating denormalization
...
-1
votes
0answers
30 views
Do you know any data model archive website like this one? [closed]
I found this website with many data models... It's not bad actually, but just for curiosity, do you know any others site like this?
http://www.databaseanswers.org/data_models/index.htm
Thanks
3
votes
3answers
68 views
pros/cons of different ways to store whether a record is one of two options?
I am trying to store whether an address is a Work address or a Home address. There will never be another type of address.
I'm wondering what the pros/cons are of the different ways to store this, ...
3
votes
1answer
28 views
How should permissions for anonymous users be modelled?
I'm designing a web application. There will be users who log into the site, but also anonymous, non-authenticated users, i.e. any member of the public who accesses the site. Users will be assigned to ...
0
votes
1answer
68 views
Index optimization
I'm building a 'tag' system for my blog posts. Currently my tags table has columns tagid - MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY and tag VARCHAR(30) NOT NULL UNIQUE.
And I have another table ...
8
votes
2answers
226 views
How to design this database to avoid cyclic dependency?
There are two tables:
User
Address
User contains a reference to Address.
Address contains the columns CreatedBy and ModifiedBy, which is reference to User.
How do I design this database to avoid ...
1
vote
0answers
23 views
What does the size of a SQL table depend on? [closed]
I mean SQL here can be any SQL like database such as SQL server, My SQL, SQLite, even MS Access. I want to know what the size of a table depends on, it depends on the actual rows in the table with a ...
1
vote
4answers
140 views
Database design - People and Organisations
Databases are not my primary skill and I am finding I need some assistance please.
The software we are building has "Customers".
The Customer could either be a Person or an Organisation.
I really ...
3
votes
1answer
67 views
Many:Many with Shared Relation
I'm modelling data with multiplicity like this:
Each Composition/Anthology related pair must share a Composer. Also, each Anthology must contain at least one Composition. How would you recommend I ...
0
votes
0answers
16 views
Change URL of Erwin data model HTML export hyperlink of www.ca.com to something different
The website URL of http://www.ca.com appears in every fact group (subject area) of our Erwin file. How can we make a global change to this URL in Erwin, so we don't have to update each subject area ...
2
votes
1answer
49 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 ...
