Tagged Questions

6
votes
6answers
366 views

Database design review - tracking of many statuses

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 ...
4
votes
1answer
123 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 ...
3
votes
1answer
125 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!
3
votes
3answers
106 views

Is this DB design acceptable, or is there a better way?

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 ...
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 ...
2
votes
1answer
160 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. CREATE TABLE `buy` ( ...
2
votes
2answers
155 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 ...
1
vote
2answers
557 views

Database design for an autoparts store

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
58 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 ...
0
votes
1answer
553 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 ...