The database-schema tag has no wiki summary.
2
votes
2answers
77 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
65 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
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 ...
3
votes
1answer
212 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 ...
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:
...
0
votes
1answer
61 views
SQL table normalization upto what extent
I have an asp.net form which contains like 5 tabs and each tab has at least 15 fields in it. They all belong to one record so for the sake of simplicity lets call the PK as RecordId. Now i have 2 ...
2
votes
1answer
167 views
Database Design Review
I'm trying to design a database structure that could be used to store information on any topic. I know that a wiki does this but I'm looking for a more structured way to store the information so I ...
2
votes
2answers
223 views
How could I improve my database schema?
I'm a student and I've created this MySQL database schema for my Service Order Management academic project and I want to know if I need to improve it and, if so, how I could do that.
Thanks for your ...
2
votes
2answers
435 views
review ERD for website
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
168 views
Creating contact tables
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 ...
2
votes
2answers
898 views
Database schema for a school.
Here is the database query needed to create the database:
create table Area
(
AreaId int primary key identity(1,1),
Name nvarchar(64) not null
)
create table Level
(
LevelId int primary key ...