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
5 views
Transforming Relational Database (OLTP) to Data Warehousing Model
This my first project around BI, i will create a Data Warehouse, based on existing relational database. I have a data base with 6 tables with many relations(One-To-Many)
I would like to give you an ...
0
votes
0answers
9 views
Which is the redundant relationship in this ER Diagram and why?
Which is the redundant relationship in this ER Diagram and why? A few of my friends and I have been trying to figure it out but keep going in circles.
Image - http://imgur.com/irtJCKP
where the ...
2
votes
1answer
19 views
Designing MySql tables for syncing notifications
I am trying to design a notifications architecture where each notification has a UID and needs to be delivered to multiple users. Each user device has a local cache of the latest notifications. When ...
0
votes
2answers
12 views
Sending notification emails based on each db record timestamp
I have a db of "event" (a conference, birthday party etc.) records, and each event has an endTime field. After an event ends, I'd like to send out 2-3 emails for each past event.
Right now, I run an ...
0
votes
1answer
27 views
Database Table structure for search engine for my website
I am trying to make a search engine for my website. How should I design the table which keeps the list of indexed words.
Earlier I thought something like this:
Table: tbl_indexedwords has 2 columns ...
0
votes
1answer
13 views
Inheritance and special types in Database design
So I'm currently building an application that manages items which are closely related - sort of like an inventory for a store, e.g. hammer, nails, saw, etc. I have a table named lets say, items, that ...
-1
votes
0answers
15 views
What language should I use to build a robust and scalable cloud based database and mobile platform?
I am a newbie when it comes to programming. As a learning experience I am planning on taking up the task to build a database that can implement SQL commands with a GUI. Currently what we have is based ...
0
votes
0answers
18 views
database table access from two difference parts
We have an in house standalone application which will not connect to the internet and not a client-server type. We have no plan to use any application server for now.
There are two components, one ...
0
votes
2answers
33 views
How to use Entity Framework with an existing Database and Poco Structure
Over the last few days I've been restructuring and existing application of mine written in C# to use Entity Framework instead of the custom data access layer I made. All was going well until I ran ...
1
vote
1answer
33 views
Storing changes on entities: Is MySQL the proper solution?
i want to store changes that i do on my "entity" table. This should be like a log. Currently it is implemented with this table in MySQL:
CREATE TABLE `entitychange` (
`id` int(11) unsigned NOT NULL ...
0
votes
2answers
31 views
Storing a summed value in a field vs. sum() on table (MYSQL)
I'm wondering about the pros and cons of storing summed values in a field vs. performing a sum() operation on a separate table. An example would be retrieving a list of items along with the number of ...
0
votes
0answers
26 views
Database design, better redundant data or empty entities?
If I am modeling data in my database as so,
sample -> (optionally goes to) prepration_stage -> library
So every library must have a relationship to a sample, but the intermediate ...
0
votes
0answers
17 views
Two-way relation in entity framework
I have a model where a company can predefine some errands for all employees, and each employee can expand with their own errands. The table looks like this:
Errand
-Id (int, PK)
-Name (nvarchar)
...
1
vote
2answers
44 views
Table in Database, where the combination of two is unique but either of them isn't
I am just learning programming and I am not really good at databases. I am trying to make a University Management Website.
So I have to make a table with columns - teacher, class, period, day. If ...
1
vote
0answers
20 views
modeling an “apply” object a to object b to create object c relationship
I'm trying to come up with a data model/class diagram and I'm having trouble correctly representing this type of relationship in any meaningful way. Essentially it is as follows:
Actor Z "applies" ...