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.
2
votes
2answers
71 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 ...
2
votes
1answer
64 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!
0
votes
0answers
32 views
How to handle specificity and exception in a huge program [closed]
'm trying to think about a method for handling specificity and exception. What I am trying to do is just a small part for the huge program, it is a big system. BTW, the system is build based on C++.
...
3
votes
0answers
66 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 ...
2
votes
0answers
59 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
79 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
77 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
1answer
60 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
207 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
81 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
{
...
0
votes
1answer
133 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 ...
2
votes
1answer
71 views
Can't Spot the error? mySQL create table [closed]
Caution - noob alert. Gotta start somewhere...
1) 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! ...
4
votes
1answer
193 views
Database table with a single row - bad idea?
I have a "virtual scratchpad" Rails app that has pages (analogous to a piece of scratch paper), and each page has_many :notes (analogous to the notes that you'd write on that paper).
I want to count ...
3
votes
2answers
77 views
A database schema for articles and their revisions
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:
...
2
votes
0answers
276 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 ...
