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.
1
vote
1answer
50 views
Game database- many to many relationship
I am designing a simple relational database about a game that can be played by 2 players each
time. I have these tables: Player, Game, PlayerPlaysGame, Payment. I recognize there is a
...
1
vote
2answers
122 views
Multiple SQL Server data files on same SAN disk
I'm currently in the process of creating a new database, and have previously only ever used a single data file and a single log file. I've done some research online regarding the benefits of multiple ...
1
vote
0answers
59 views
Real Time data collection - Help select Database
My Scenario:
I want to collect data from various sensors[for now I have 600 sensors sending data, but this may have to scale up to 3000 more data sensors, all sensors send real time data] Now I have ...
1
vote
2answers
132 views
How do I design a database for a resource scheduling and allocation application?
I have two entities: Resource and Project. A Project runs for a certain amount of time (in calendar days), and I need to allocate several Resources to it (allocation interval - 1 work day, not an ...
1
vote
0answers
57 views
Unable to decompose this relation to BCNF
I have a relation
R = { A, B, C, D, E, F, G, H, I }
And functional dependencies
F ={
ABC -> DE
E -> C
AB -> F
C -> G
F -> H
H -> IJ
F -> B
}
I am able to do simple BCNF ...
1
vote
1answer
75 views
big db for managing user files and settings
Hi im about to start a project that will hopefully eventually hit milion+ users which is some kind of a site managment,
problem is how to set the db in mysql, some people suggest way 1 and others way ...
1
vote
2answers
98 views
Use single table with foreign key or two twin tables for text entries?
I have a table answers that has several columns including the content iself such as
ID | q_id | list_id | user_module_id | content | updated_timestamp
The content column is a varchar since we want ...
1
vote
1answer
112 views
Database design for an E-commerce website
I am new to database design. I am designing a database for an E-commerce website, there are a lot of products to be updated, but while designing for product specification table I do not understand ...
1
vote
0answers
75 views
UML class diagramm for database design?
I used to make database designs using a french method called MERIS that uses mainly two diagrams to create the database (MCD and MLD), then i heard about UML and that is used also for databases and ...
1
vote
2answers
416 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 ...
1
vote
1answer
113 views
Storing metadata of various data types in a MySQL database
I am currently designing a MySQL database that will store a variety of documents in different digital formats (mostly docs, spreadsheets, and pdfs). Each document will have several metadata values ...
1
vote
4answers
111 views
Normalization of DB
I have designed a database using MySQL likewise
My question is what else i can do to normalize the DB, for now i am using InnoDB engine for the table to maintain the relation among different tables.
...
1
vote
0answers
122 views
PeopleSoft or Oracle App Designer Tool Alternative
We are using PeopleSoft app designer tool to manage and create projects, database objects - tables, columns, views etc in Oracle database. This tool has limitation that we cannot create tables/columns ...
1
vote
1answer
188 views
Payment methods conceptual and logical model
I need to create a conceptual and logical (normalized) models of parking house according to the requirements below. It looks to me as a very simple concept that doesn't need all tables to have ...
1
vote
1answer
107 views
Deriving formulas for input/output
I'm currently enrolled in a DBS class and am having problem with an assignment. I've searched around and have been unable to understand what it is I'm meant to be doing with this derivation formula.
...
1
vote
1answer
94 views
Regularly import tab-seperated log file to MySQL
I'm looking to keep arpwatch entries in a MySQL database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
1
vote
2answers
46 views
How to change type from one owner to two different types of owners
I currently have (tables changed):
User
UserID uniqueidentifier,
CompanyID uniqueidentifier, (for future reference)
.. more unrelated fields
(PK: UserID)
UserRating
UserID uniqueidentifier,
...
1
vote
3answers
122 views
Database schema - performance v correctness information
I have a database that stores information about the users of my website (username, password, etc). I also store information about their activity on the site.
For example, I have a large number of ...
1
vote
0answers
71 views
key value database
I have one object and a lot of data associated with that object, you can think of it as something like facebook timeline where we have user and user has a lot of posts.
I cannot store data in JSON ...
1
vote
5answers
284 views
SQL Server - Database per company. How to query across databases?
We are designing a product that, as per the client's request, must utilize a database-per-company design approach with one shared database holding common data.
We are using SQL Server 2012 for the ...
1
vote
0answers
116 views
Improving database design for category based site
I'm working on a site that gets about 30k visits a day and it makes use of a lot of queries which uses UNION's over about 45 different tables, these tables generally range from about 15k rows to about ...
1
vote
1answer
561 views
How do I perform a UNION query on a dynamic list of tables?
My database has an unknown amount of tables, named with the same prefix followed by a random string: _ct_<random_string>.
Each of these tables has the same data structure.
I also have another ...
1
vote
0answers
266 views
Implementing a family database using Access 2010
A while ago I asked this question about using Access 2007 to implement a family tree model. I had all the tables and relationships mapped out in a UML diagram but realised it was getting out of hand ...
1
vote
0answers
199 views
Survey System Database Design [closed]
we are trying to design a survey system and we are kind of stuck at database table design.
We use jsp, oracle and jquery. we managed to make a survey generator that clones an html table with different ...
1
vote
0answers
69 views
User defined content specific permissions with varying conditions. How to design tables?
I'm working on a privacy settings problem, which is proving to be cumbersome to design.
Essentially I have:
User created content
User can define access groups for content.
Access groups vary ...
1
vote
0answers
189 views
How do I auto-fill data in Microsoft Access 2003?
I am creating a Purchase Order Form at work using Microsoft Access 2003 so that it can be saved and archived in a database and reduce paper costs.
These are my current dilemmas:
I am unable to ...
1
vote
0answers
187 views
Entity relationship diagram
What is the difference between ERD 1 and ERD 2?
From what I understand is that ERD 2 has the many to many relationships resolved with a link entity whereas ERD 1 only shows the relationship... is ...
1
vote
0answers
265 views
How to customize Place Order Functionality In Magento? [closed]
In Magento, when any customer buys product from front-end, then at last customer goes through order placing.
According to my need, I have created one CUSTOM TABLE in Magento database. So my ...
1
vote
1answer
91 views
how to handle so much multiple value strings [duplicate]
Possible Duplicate:
Multiple values in lookup fields
i have a table has about 27 fields are just strings
and every one of them have multiple values
for example itemType Field have more ...
1
vote
1answer
63 views
Design for a Testing system
I want to redesign a part of my system. I got the following objects:
Site:
id
Name
Site Version:
id
idSite
Name
Task:
id
idSite
Name
Test:
id
idTask
Name
TestResult:
idTest
idSiteVersion
...
1
vote
1answer
222 views
SQL Schema for XBRL Document storage [closed]
Does anybody know of a relational database schema that can be used to store XBRL data? I am looking to store financial report data (balance sheet, income statement and profit/loss statement data) ...
1
vote
1answer
169 views
How to design relationships for variant data?
Help me define the table relationships for data with multiple structures. I need to track leads. Leads come from multiple sources. Each lead source has its own data structure. I need advice ...
0
votes
3answers
319 views
SQL Server : primary keys advice to my whitepaper needed
I've tired to explain to every new junior developer in our r&d team why he should use Primary Keys and how to do that. So I decided to write small whitepaper, which every new developer should ...
0
votes
3answers
165 views
Is adding rows better then adding columns in case their value is not consistent?
In my project I have a table of customers, each customer has his own special price for each product, It's a small business and there are currently about 5 products. The manager says there might be ...
0
votes
1answer
150 views
Do you feel like DBA/DBD Is a “secure Field” still? [closed]
I noticed recently alot of Database jobs/Development have kind been pushed onto general developers, not to mention with NoSQL Solutions (Which IMO are probably a little easier for Non-DBA's to throw ...
0
votes
3answers
602 views
Will using bigint vs mediumint have a performance impact?
I'm considering using mediumint or bigint for an ID column. I prefer to use bigint, because that way I'm very sure that the huge numbers that the client sometimes uses are stored just fine. However, I ...
0
votes
4answers
34 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?
0
votes
2answers
66 views
what is the best choice from those two tables?
what is the best choice from those tables??
table A : keep DB simple with lower number of tables ... but i will find difficulties if i wanted to extract certain data from column of doses coz it's ...
0
votes
3answers
191 views
Name of the product price, line-item database pattern?
What is the database pattern called where (for example) the current price of a product is stored in one table, and when someone makes a purchase the current price of the product is copied to a line ...
0
votes
2answers
281 views
Database Design Advice for Expert Systems - Rule Based Systems
Expert Systems are a branch of Artificial Intelligence. These systems try to capture knowledge of Experts via set of rules. Most of the rules are stated in natural language. But they need to be ...
0
votes
2answers
56 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 ...
0
votes
1answer
70 views
Foreign Keys with Composite Key
Imagine I have a table with the following dependency:
(Name, BoughtFrom, TimeBought) --> Cost
Where the three attributes in bold form a composite primary key for the table. Now then, I want to ...
0
votes
2answers
58 views
Adding a bool column; tracking untouched vs. false
[backstory] I have a simple database of our current Widget inventory. It averages just dozen columns across five or six tables, but has a huge number of records already.
Some Widgets came with ...
0
votes
1answer
70 views
Looking for a scalable relational database [closed]
I'm looking for a database that achieves the following:
fully ACID.
relational with joins.
has transactions.
allows the administrator to specify sharding rules (for example: users from Europe should ...
0
votes
1answer
117 views
Maintain table with too many insert
I have to create a table. Its size is going to increase very fast.
Is there going to be any issue if many insert queries are fired at the same instant as mentioned here - User autoincrement ID for ...
0
votes
1answer
156 views
How do I correctly design this database?
I am not a database designer by any means. I am a desktop programmer, but I am currently looking at implementing a website idea which will need a (possibly very large) back-end database.
In my site ...
0
votes
1answer
707 views
Entity Relationship Model for linked tables
Certainly a noobish question, but I'll ask it anyway. Perhaps someone else will be thankful. ^^
I am getting warmed up with MySQL and I try to understand the concepts of creating well structured ...
0
votes
1answer
238 views
Many to Many and Weak Entities
I have an entity that cannot exist without being defined by another, and I want this entity to participate in a many to many relationship.
Example: An artist has an album (the album cannot exist ...
0
votes
2answers
62 views
What to have in the main table and what to have in meta_table?
I'm try to figure out the best scheme for the users table for my software. I'm trying to separate the main data and auxiliary data into 2 table called users and user_meta for the sake of extensibility ...
0
votes
1answer
140 views
What are good resources on data modelling for business intelligence? [closed]
We are a SaaS startup offering purchase & procurement solutions. The data model for operational transactions has been created (relational DB). We also want to offer analytics on those transactions ...
