Tagged Questions

5
votes
2answers
210 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
69 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
59 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 ...
2
votes
2answers
124 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 ...
7
votes
5answers
7k 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 ...
2
votes
2answers
168 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
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
98 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 ...
2
votes
1answer
104 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! ...
2
votes
0answers
316 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 ...
2
votes
2answers
874 views

Need advice for my simple shopping cart's database structure

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. products table ...
2
votes
1answer
87 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 know is the blog has comments or not. SELECT EXISTS (SELECT true FROM ...
3
votes
3answers
107 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
1answer
161 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` ( ...
1
vote
1answer
241 views

Please review my 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 ...