Database schema: describes the structure of the information within a database system. The schema is formalized using integrity constraints, which may be expressed as a series of sentences to describe the data, structure of the database and properties of the database.

learn more… | top users | synonyms

0
votes
0answers
10 views

Database revision needed for sports events database [migrated]

This is not a code review but more of a database schema review. I have a sports events website that I am doing in my spare time. I need assistance with the database design. I am about 80% completed. ...
0
votes
0answers
19 views

composite keys in table-creation script [closed]

I have a database which has customers reviewing products. My sql code for the db regarding the tables is below: ...
10
votes
2answers
62 views

Revision 1 - Step 1: PsychoProductions management tool project

I started a project to build my own invoicing and management system to take the place of prohibitively expensive QuickBooks software. This will be broken down in 5 steps, with the current step in bold ...
1
vote
1answer
118 views

Database schema suggestions for a Minecraft logging plugin

This is my attempt at creating a database schema for a Minecraft logging plugin. I'm by no means a SQL expert, so suggestions would be greatly appreciated. ...
5
votes
1answer
565 views

Logfile parser for Team Fortress Classic video game

I'm currently working on a logfile parser for a pretty old videogame called Team Fortress Classic, which can be compared to Counter-Strike 1.6 and is available on Valve's Steam platform. I started ...
2
votes
1answer
265 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
0answers
70 views

Python MongoDB Schema feedback

I would dearly love some feedback on the model below. Its a basic commenting structure where Users can comment on a variety of objects in the model. I have denormalised to make querying simpler, but ...
1
vote
2answers
365 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 ...
3
votes
2answers
316 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: ...
5
votes
4answers
427 views

Database schema for Service Order Management project

I'm a student and I've created this MySQL database schema for my Service Order Management academic project. I want to know if I need to improve it and, if so, how I could do that. ...
1
vote
2answers
994 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
423 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: ...