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.

learn more… | top users | synonyms

0
votes
1answer
35 views

Managing several payment means in my Rails 3.2 app

I'm trying to manage several means of payment in my Rails 3.2 application. Let's say I have 2 means : Credit Cards & Bank Transfers (BIC), working with 2 different payment providers. Those means ...
2
votes
0answers
37 views

Tracking sports statistics

I am designing a new application to track sports statistics. I am using code first migration. I have the bare minimum POCO setup. The problem is I am not happy with the design specifically how the ...
0
votes
2answers
87 views

Build a local cache of all streams from Twitch.TV API

I am trying to cache the entirety of streams from Twitch.TV public API with the following code. It is successful but takes almost a full minute to execute so I am wondering if it's my code or just the ...
2
votes
2answers
104 views

A query on Hibernate database design

I am writing a simple web application where I have a User entity and set of pre-defined questions to be answered by the User. The answers provided by the users for these questions would need to be ...
2
votes
1answer
66 views

Normalization: is it done well? [closed]

I am creating game review database. I am new at this, but I am trying my best. Little bit about database: The system is simple, the user will fill out a form, where they will insert their name, email ...
2
votes
3answers
322 views

choice of tables for a project to handle attendance

I'm working on my project in php [handling students attendance system]. I have a list of students along with their id[jntuno] and I need to create a database in mysql for storing the daily attendance ...
4
votes
1answer
106 views

Critique my Stack Overflow schema

I'm learning DB design. How would you change the following schema which tries to replicate Stack Overflow's functionality: ...
1
vote
1answer
200 views

Review database schema [closed]

The database is for a website showcasing advertising agencies. "Premium" paid accounts will have a profile page detailing the agency, a client page, and a creative portfolio with their work. Basic ...
3
votes
2answers
88 views

How to design DAOs that handle composite objects?

Suppose I have following elementary DTOs, each DTO corresponding to a database table: class Event { String name } class Player { String name } DAOs for ...
5
votes
2answers
2k 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 ...
2
votes
1answer
222 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
91 views

SQL vs MongoDB (TCG collection managment) [closed]

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
95 views

Designing price calculation methods model [closed]

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 ...
2
votes
2answers
155 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 ...
1
vote
2answers
333 views

My database schema [closed]

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 ...
10
votes
3answers
153 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
160 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
125 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
120 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
472 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
606 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 ...
1
vote
1answer
274 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 ...
0
votes
1answer
2k views

Data Structure for Categories and SubCategories

I have this relationship: Many Objects to One Category One Category to Many SubCategories I am looking for the best way to store this in my Relational Database? Here were some of the ways I was ...
1
vote
1answer
169 views

Can't Spot the error? mySQL create table [closed]

Currently following a couple tutorials and simply can't locate the error preventing the creation of the table. I've even done this before. So simple! Yes, I could manually add the table but I'd ...
5
votes
2answers
682 views

Database table with a single row - bad idea? [closed]

I have a "virtual scratchpad" Rails app that has pages (analogous to a piece of scratch paper), and each page has_many :notes ...
3
votes
2answers
278 views

A database schema for articles and their revisions [closed]

I'm designing a super simple web application for creating articles. All articles on this site can be edited by different people and each edit is a revision. Using an RDBMS, this is my schema: ...
3
votes
1answer
373 views

Please review my database design for an online organization tool

The problem I'm trying to solve. I'm a big fan of David Allen's Getting Things Done, but the myriad software tools and sites I've tried haven't impressed me that much. That's why I've decided to ...
0
votes
1answer
118 views

Package Manager in Python

I've written a package manager for OS X in order to improve my Python skills. This is the second programming project I've ever worked on, so I do not expect it to be great, or anything, but I would ...
6
votes
6answers
448 views

Database design review - tracking of many statuses [closed]

I have designed the following database for a small project. Please review and leave feedback. The main problem I'm having is to keep tracking of many statuses. The user wants to know the status of ...
2
votes
2answers
2k views

Need advice for my simple shopping cart's database structure [closed]

I’m trying to make a simple shopping cart application in PHP and am unsure of how to structure the database. I believe there are three tables that I need (but I could be wrong!): 1. ...
2
votes
1answer
93 views

MySQL query: blog entry has comments or not

How expensive is this query? Lets say for example if I don't have a field called total_comments in my blog table. All I want to ...
3
votes
3answers
121 views

Is this DB design normalized? [closed]

Is this normalized properly? Is there a more efficient way to design this DB? A Profile can have unlimited albums, any user can create an album from anyone's videos. An album may contain many videos, ...
2
votes
1answer
251 views

Database Design Review (Part III) [closed]

I've been thinking a bit more on my database design sense database-design-review database-design-review-part-ii I think I've settled on a database design based on the 2 reviews so I shouldn't be ...
0
votes
1answer
132 views

Database Design Review (Part II) [closed]

I've been thinking a bit more on my database design sense this post. The general idea is I'de like to create a generic database that can store information on any number of subject, similar to a wiki, ...
2
votes
2answers
885 views

Relationship design for auto parts store database

I'm creating a design database for an autoparts store (this is a project school). For the moment, I'm not sure if the relationship model especially in MODEL, MAKE, BRAND is correct (I really have no ...
1
vote
1answer
108 views

feedback wanted on Elixir db model

I have designed this model which is very flexible. For example, you can create asset types, assets and combinations of them infinitely. It is the front end to a Python Pyramid website, so all the ...
2
votes
1answer
187 views

Review my database structure and tell me your suggestions on it

I would like your thoughts on my database structure. I am kind of a rookie but I am trying. All of your suggestions, alternatives, ideas, additions are welcome. Thank you. ...
1
vote
2answers
934 views

review ERD for website [closed]

I am a noob and would like some help with the erd for a website I am building. There are roles for the users that participate in the board. I'm not sure I have that down correctly. I realize that I ...
3
votes
2answers
382 views

Creating contact tables [closed]

I have a module in my college project for managing Contacts. I'm confused on how to design the contact table. One contact can have multiple email, mobile, website addresses. So I have created two ...
4
votes
5answers
2k views

Database schema for a school

Here is the database query needed to create the database: ...
3
votes
2answers
274 views

database design for an online learning application

It is an online learning application with different types of learnable items, that different users learn. The users learn by spaced repetition (once right, wait a couple days, ask again), success is ...
7
votes
5answers
10k views

Database class using PDO

The point of this question What about this piece of code? I'm actually using it while developing a simple application and it seems to cover all my needs. Also it uses PDO so that we don't really have ...
21
votes
6answers
2k views

Can you peer review my database design for a school system?

This system has to manage students, teachers, staff and grading. This is for production and is not a school assignment. As such, please let me know if I can improve on any aspect. :) My main concern ...