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.
5
votes
2answers
182 views
Strategy to create audit trails for a SQL database
I wish to create audit trails for specific tables and columns in my database, and document who made the change, when it was made, and what the change was.
To do so, I will create the following ...
1
vote
1answer
56 views
Keeping track of people's relationships in MySQL using a people relation table?
I am trying to track relationships among people. I came up with my own solution, but wondering if there might be another way or better way of doing this. To keep it simplified, I'll post just the bare ...
1
vote
1answer
56 views
SQL vs MongoDB (TCG collection managment)
I'm designing a web application to help some friends and I manage our card collection. A relational database makes sense to me, so that was my first instinct.
The basic schema would like something ...
1
vote
1answer
78 views
Designing price calculation methods model (needs review)
I'm building an application for a bonded-warehouse. They have services calculated by Unit price like "Container surveillance duty = containers number x storage days x unit price" and they have ...
0
votes
1answer
45 views
SQL Avoiding dynamic tables
I have following problem: I have program, that connects to IRC server, join several channels and for each user on it, count amount of messages. I have to put all this into MySql.
So, naive solution ...
2
votes
2answers
121 views
Database design improvement
I am doing a database design I want to create a database with information of employees, their jobs, salaries and projects
I want to keep information of the cost of a project (real value of project ...
2
votes
2answers
146 views
My database schema
I'm not sure if this would be okay to put here since it doesn't have code to look at, but this is my database I'm trying to create for an online firearm store. I'm new to database design and ...
3
votes
1answer
123 views
Is my ERD design for “Adding Friends Capability” is good enough? [closed]
I have a school project to create a simple networking site, And I want to know if my database design is good. I'm open for any suggestions to improve my design thanks!
9
votes
3answers
124 views
Object database schema, should i split my tables?
I have a database schema for a game to hold save files where some tables have a one-to-one relationship to Classes. And i was wondering if i should split up some tables.
Example troop_class table. It ...
4
votes
1answer
120 views
My first implementation of mongoDB
I'm new to Code Review, my assumption is that it is a place I can get feedback on working code that I've built, I hope that is right.
This is my first implementation of mongoDB, much much more to ...
2
votes
3answers
107 views
Referential MySql Design
How does this look? It has been over a year since my database concepts class and I have never worked with MySql. I have chosen InnoDB as my engine because of foreign key support using UTF-8 based on ...
1
vote
1answer
96 views
MySQL database with foreign key support
A modified review request has been made here.
Can I please have someone review this simple database design below and tell me if this is the correct way to achieve what I want to do?
What I am ...
1
vote
2answers
193 views
Is this the right db design for the most flexible and modular CMS with user management in CakePHP?
I would like to ask you guys if you could review my database design:
I think it is quite self-explanatory, but to be absolutely clear:
My goal is to make an application which has a super flexible ...
3
votes
1answer
363 views
Schema for Google Docs-like Sharing
I want to allow users to share documents (and other stuff) in a database-driven application.
I have designed the following schema to allow for this (postgresql). Some of the tables like Party are ...
0
votes
1answer
156 views
Is it proper TPT Inheritance
I have following model and database created using Entity Framework. Is it proper TPT Inheritance?
Is it possible to make the base class as abstract?
Model
Database
CODE
namespace LijosEF
{
...
