Tagged Questions

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.

I am planning on creating a database to track teams and players in a soccer league. The stats I wish to track are as follows...
goals scored/conceded(gk), assists, minutes played, cards received and ...

I'm just thinking out loud. I'm wondering if there's any database technology where it's structure does not need to define upfront?
For example it may start off with just one column or roll and user ...

I have a column in utf8_unicode_ci collation for text type in MySQL.
The content is in Unicode, I have used tags like {br}, {v}, {t}, {h} etc.., throught the database. I am now thinking of changing ...

I have the following table. The PK is model_ID.
Assuming that the modelName field is unique(that is, no two brands can have an identical modelName), there is a transitive dependency between modelName ...

I'm looking for a specific "best practice" or "pattern" concerning entities that are shared between different entities, having a relation to one of many.
For example, one may have the generic entity ...

Someone mentioned this in a presentation but didn't provide any examples. This stuck with me and I am trying to figure out what kind of data couldn't be stored economically in datbases ever since.
It ...

I am new in the database design and I'm facing this problem, I hope somebody can help me.
In my domain we have 3 roles, Non-Supervisor, Supervisor, Manager.
I created a Person table and a role table ...

Building an app that will manage lessons, students, courses. Each lesson belongs to a certain course. A student can subscribe to a single lesson or to a whole course.
So it seems straightforward that ...

the main idea is that i can post an article , link or an attachment and i can receive comments on each of these types of posts (the structure of the comment is the same) , the problem here is that i ...

I need to design a database that has multiple users, with multiple roles. For instance, a user can be an admin, company, employee, or customer. Each user can have any number of these roles. Right now ...

I have multiple views with union like this:
select column1, column2 from mytable
union
select cast(extcol as nvarchar2(15)), cast(extcol2 as nvarchar2(10)) from exttable
But later I change the size ...

Below is information about a database and I want to come up with the ER Model. (Im not sure if this is the right place to post this. Im new to this page)
professors have an SSN, and a name
projects ...

My app has a requirement wherin we need to capture attendance details of a class. A class typically has 50-60 students and there will be records with attendance/absense status of each student for a ...

We are running some performance tuning on our database in SQL Server. The database in itself is pretty small with around 13 tables. But there are multi-level relationships between tables.
When I try ...

I'm currently dabbling in ER modeling and wondering if it is possible to create a chain of is-a relationships. Example:
Here I'm basically trying to model specific in-stock items available for rent ...

What is the most optimal way to store lots (up to 300) of properties about an object? All properties determinate presence of a factor. Like, "has dog", "has cat", "has garden", "has N".
Initially I ...

Suppose I have a table Friends with columns Friend1ID, Friend2ID. I chose to represent each friendship with two records, say (John, Jeff) and (Jeff, John). Thus, each pair of friends should show up ...

I'm doing a personal project where I have a quiz with a number of boolean questions. Each question will have a two answer choices "true" and "false". Based on the selected answer, a new question will ...

I am just curious as to what the best practices are for storing the data from objects built using decorator design. I have a base class and can decorate it with A, B, and/or C, with A B and C having ...