Tagged Questions

A schema of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of data to create a blueprint of how a database will be constructed (divided into database tables).

I'm not really a database novice but I'm not an expert either.
Problem:
I'm having this difficulty on designing my Post, Category and Tags relationship.
I've read Normalization many times but could ...

In a project I'm working on, every change to the rows in some tables of the database must be tracked for further audit or rollback. It must be easy to find who modified the row, from which IP address ...

Overview of the Application
I am building a Ruby on Rails application to organize medications, using MySQL. The goal of this application is to provide dosage specific treatment recommendations, and ...

I'm not a dba but a php programmer, so that I'm not an SQL pro. Now, I have searched in both programmers and dba stackexchange sites but the answers are too specific or not conclusive.
My question is ...

I am looking to create a set of fields on my webpage identical to what eBay uses on their category selection page when you are selling something. For my purposes I am doing motorcycles, power sports, ...

I would like to have a good tool for designing the Database Schema with all the tables, columns, data types and relations. Today I mostly do this with pen and paper but I would like to do it in a good ...

I need to delete a schema in my PostgreSQL database. I would like to make sure that the schema is not used in another schema (for instance : this schema is used for a view in another one). Is there a ...

I have customer table in public schema. And I have a schema named after each customer. Each customer schema contains different tables like portals, plugin, ... When I want to select portals used by ...

Is it harmful in some way to have multiple schemas with the same name in a database cluster, specifically Redshift?
I want to create multiple databases, and then create a schema "tables" or "data" or ...

In context of Platform as a Service (PaaS),
we would like to offer our clients a private platform.
A platform includes a website and a database.
A platform is not 100% separated. Users could "travel" ...

I'm wanting to implement something that's basically an ACL in SQL Server (2008, we'll be moving to 2012). We're working with farm production information. We will have users who need to be authorized ...

I am working on designing a schema to support the development of a miniature railway reservation system, using oracle 11g XE.
This is for a project purpose, I am need to be sure about the correctness ...

I have already created a database design with a set schema.
The database schema is for a web quotation form. PS it is not a simple quotation form and hence need to customise the form, form builders ...

I am building an app which allows users to do some "tasks" to earn points. The "tasks" are part of a "campaign" which themselves are a part of "brands". I am confused about the schema for storing the ...

Given a table with a PRIMARY KEY definition (acting as the clustered index), I want to efficiently change the definition of the PRIMARY KEY (or at a minimum, just the clustered index) online.
I would ...

I am facing database error Incorrect string value: '\xC5\xABt\xC4\x97'. I did a lot search and tries a few ways, include move from utf8 to utf8mb4. But still not able to solve it.
Following are the ...

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 ...

I have an instance with 15 databases on SQL Server 2012. I will set up to backup system which will work every night. I want to backup only the schema because several databases are very big. I haven't ...

I would like to know, which is best in fast retrieval and reporting as numbers of records will increase with time. So lower the record better would be the performance.
Priority would be fast response ...

I am really curious about the infrastructure of Amazon. When I create a new instance of RDS, it gives me a host, username, password.. Everything. Behind the curtains, how do they do this? It´s some ...

On the percona-5.6 and MariaDB-10.0 servers, the NOT NULL declared on table field are being ignored. I am able to leave fields declared as NOT NULL empty when inserting data and the servers are not ...