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

learn more… | top users | synonyms (1)

3
votes
1answer
46 views

Seeking feedback on table relationships, general schema design

I'm designing a database for a business that sells tickets to a variety of events worldwide. The app will be built with Rails using PostgreSQL. Here's what I have so far, link to full size image ...
1
vote
1answer
219 views

Schema design for products with multiple variants/attributes?

I'm using MySQL. The idea is similar to shopify with a different concept, so users are going to add their own products with multiple types of variants and attributes. From all the research I've done ...
0
votes
0answers
52 views

Database schema for storing edits in the content [duplicate]

I want to store all the edits of a specific table. Multiple fields can be modified and for different users. I want to store all changes, taking in count that the number of fields that can be edited ...
1
vote
1answer
32 views

SQL Server 2008 running schema query without identifiable cause

I am analyzing the performance on login to an application and in particular making sure the database response is acceptable. In running just the simple Activity Monitor I can see that there are two ...
0
votes
1answer
28 views

Can I create a unique constraint across schema in Postgres?

I have a task that I am trying to accomplish where the email address is unique. The email address is stored in the a3.user table as user_name. CREATE UNIQUE INDEX ix_user_user_name ON a3."user" ...
1
vote
0answers
18 views

UML database schema based on the creteria

I have the following requirements to design a database schema (brief): A Graphic Designer (we will call them designer) gets a call from a client with a new job to design a logo. The designer ...
0
votes
1answer
20 views

How to find functional dependancies from a relational schema?

If only given a schema (table header, with primary key indicated), how do i find functional dependancies? My problem is that would not functional dependancies depend on the data stored int he table, ...
1
vote
2answers
60 views

Why not have Persons for every person in schema?

I noticed that a lot of database schemas often show like, "students" or "teachers" or "employees" or "passengers" or something to that affect. Why not have a schema where every individual is a ...
0
votes
1answer
32 views

MongoDB storage of multi-dimensional arrays

Using MongoDB 3.0.7 as the primary datastore. I connect to it using ReactiveMongo 0.11 on a JVM-based language. My question is: how well does Mongo store multi-dimensional arrays? For image analysis, ...
3
votes
2answers
1k views

Schema Migration: SQL Server Data Tools vs Liquibase and Flyway

This might seem like a stupid question, but I've been looking into open source solutions for schema migration, namely Liquibase and Flyway. However, my boss told me that SQL Server Data Tools (SSDT) ...
0
votes
0answers
66 views

Hard dba case [schema to store delivery prices for shops]

I want to make a database scheme which would allow me to fetch the delivery price for the different Shops basing on the delivery destination (Address/Region) and order value (price). Here is the ...
1
vote
1answer
43 views

Active Directory group as a schema in SQL Server

In SQL Server 2008 R2 we have a database that is being maintained by a team of developers. Each of them should have permissions to perform DDL operations such as adding a column or creating a table. ...
1
vote
1answer
65 views

SQL Schema Change; Modification of Existing Table vs Creation of New

We are planning the data schema for our project. Currently we have a table with classifications, but there is the possibility of a new classification in the future which would require a new field to ...
0
votes
1answer
103 views

How would you design a table for approval system between User and Sports Club

I am currently learning database modelling and struggling to model the following requirement. I have a user and sports_club table. User can only join a sports_club if three existing users of the club ...
0
votes
1answer
49 views

Compare order of columns between two databases

I have two postgres databases which should have an equal db-schema, but have not. I want to see the difference in the column order. Columns of table1 in Dev: id, foo, bar Columns of table1 in ...
0
votes
1answer
61 views

Single-Table vs. Multi-Table design

I'm trying to come up with a database schema which is going to be used for a social network similar to that of Facebook. Now for posts I have two schemas in mind which are as follows: Single-Table ...
0
votes
1answer
38 views

Default schema is ignored on SELECT

According to my understanding, a default schema should apply when issuing SQL statements on tables using unqualified table names. My problem is that the following statement fails, because the table ...
1
vote
0answers
24 views

DATE - Normalization, a multiple ranged query, multiple inserts and multiple update

I have a booking system, airbnb style. TABLES -> prices, house, available_date A house has available days and not available days, but sometimes the days have different prices. A weekend is more ...
0
votes
0answers
74 views

How can I layout a schema that will track monthly installments?

I'm pretty new to database design and have a beginner's understanding of SQL, mostly simple SELECT statements. I find myself in a situation where I have to create a system that will track monthly ...
0
votes
0answers
21 views

How can I organize this data?

I have been working in a system but don't know how to represent some of the data and its relations. There are three warehouses and a four shops working with the system and until this moment we can ...
0
votes
0answers
76 views

Finding the closure and super keys of a schema?

I am working on a problem in which I have to look at the relation R with schema R(w, x, y, z), and the three functional dependencies: w -> z ; x,y -> w ;z -> y For every non-empty subset X of ...
0
votes
1answer
47 views

How do I host and separate multiple projects on one Oracle Database?

From Difference between database vs user vs schema I'm trying to understand the concepts of the schema, user and database. My current understanding is you cannot create a schema separately. You can ...
3
votes
1answer
447 views

ER vs database schema diagrams

when i search the web for er diagram and database schema these 3 diagram types found but all are named under er diagram.i want to know what is database schema diagram and what is er diagram why all ...
1
vote
0answers
58 views

SQLite reference table question

I'm using SQLite and Python for making a sensor network database. I have a table holding the nodes: NODE, another 2 tables for sensor specification: SENSOR_TYPE ("Temperature, Humidity...) and ...
0
votes
0answers
61 views

How to design relationship for racing team trades?

I'm working on a fantasy racing team project. I'm having trouble laying out the schema when it comes to the team table and the trades. I think I have the race, driver, and result tables laid out okay: ...
1
vote
1answer
66 views

Permission in schema for user

I created a default database and created some schemas within this database. Created users for each schema, now I want to give full permission for each user in your schema only, how should I do?
0
votes
0answers
16 views

custom field related to usergroup and products

We need to create dynamically custom fields and store values related to each user or product in database we have product table related to category table and also user table related to usergroup and ...
1
vote
0answers
26 views

Possible to have duplicate fully qualified schema names with separate data in DB2 for z/OS?

We have several application teams that are looking to do a re-write of large legacy applications. This is mostly COBOL going against DB2 for z/OS (v11). The COBOL code was generated using a tool, so ...
0
votes
0answers
20 views

Variable Dimensional Data in Table

My application needs the ability to store data of variable dimensions. For example, it might have some three dimensional data, with values addressed by the vector [age, region, type], together with ...
0
votes
0answers
38 views

design of schema in mongoDB

I'm using mongoDB as my database. i have an record of 100 hospitals. To store all the information i'm designing schema of my database for that i've three solutions: i can create collection for each ...
1
vote
1answer
43 views

MongoDB schema for a news service

I would like to create a mongoDB database that would be very similar to how various news services store and display their data. The database would be queried by an android phone. Lets have a look at ...
2
votes
2answers
56 views

Asking SQL schema by FOIA

I've sent FOIA requests to various public institutions in my area. I'm only asking for the schema of the SQL databases their financial services might be using (column name for every table for every ...
0
votes
0answers
100 views

Comparison of MySQL Workbench model schema with existing database?

I need to compare the schema of a MySQL Workbench model with the schema of an existing database. My initial approach was to use the 'Forward Engineer SQL Create Script' option and compare its output ...
0
votes
1answer
108 views

Documenting SQL Server Database [duplicate]

I wrote the following (Quick and Dirty) script to document a database schema: Note - The relationships part came from another guys site (I just can't remember where). Does anyone know how to ...
7
votes
1answer
101 views

Functional dependencies applies to whole database or to a particular relation?

I am new to dbms. I saw a lecture video about functional dependencies. But I am confused a bit that whether functional dependency is a constraint put on whole database or on a particular schema?
0
votes
1answer
81 views

Store parameters of various types

I am a (poor, young) scientist working to develop a database to allow a project to scale up. I am experimenting with MySQL and have had very encouraging experiences so far, but I am still novice and ...
0
votes
0answers
38 views

PostgresSQL ignoring search_path when using input file

I have a SQL file generated using pg_dumpall, and I'm attempting to use it to restore a database with the -f option for psql (eg: psql -h 127.0.0.1 -p 8888 -U owner -f ~/restore_file.sql). My SQL dump ...
2
votes
1answer
98 views

Howto use typeperf to store performance monitor values in a custom schema?

I have setup a performance monitoring of my SQL server system using typeperf.exe to store the values directly to SQL Server. I went through the following article, that explains howto use typperf.exe ...
0
votes
2answers
546 views

Export pump all schemas except Sytem related schemas

I have around 111 schemas in one database instance and have to export all the schemas except the system related schemas to a new instance. Is there any way as to exclude system related schemas while ...
3
votes
0answers
196 views

Form builder schema for SQL database?

There are many ways one can envision the solution, from the top of my head: Two table approach: Field table with (name, field_name, type, description, meta) attributes Form table with (name, ...
4
votes
1answer
145 views

UPDATED: Relational (or NoSQL) Database Design

(Updated this question with more specifics. Decided on a Relational Database, and would love some comments on its design) This database holds assembly instructions data for shipbuilding, later use in ...
0
votes
1answer
50 views

Is it good to save Keywords stored by users in a new DB schema?

My question is more from the schema design and of further performance of the DB. I'm designing a DB schema which will store primarily strings. Actually, users work on these string, as normal mortals, ...
1
vote
1answer
42 views

Is this the correct way to model a relationship between an object which may or may not have another object?

I'm creating a database for a department store and the database has two tables: Items and Coupons. An item, like a TV, can only ever have one coupon. Some items don't have a coupon at a given time. ...
2
votes
0answers
27 views

Getting error 1064 in automatically-generated code from MySQL workbench [duplicate]

I have started using mySQL workbench (Version 6.3.4.0) and I have used the EER Diagram tool to design a schema. So far, so good. However, when I try and run the Forward Engineering, I get the error ...
1
vote
0answers
50 views

How to make a query from a database with schemas to a database without schemas, and vice versa, with DBLINK in postgres

I have a DB (DB1) in postgres 9.4 who use DBLINK to query another DB (DB2), and vice versa, using views and functions. But now i have to add 2 schemes to DB1 (CLIENT1 And CLIENT2) and i want when i ...
3
votes
3answers
372 views

Implementing User Privacy Settings with MySQL Database

I am actually working on a social website. Not big, aimed at a very small group of folks. And I am curious, to how I can best implement Privacy settings for my users in a MySQL driven database. For ...
2
votes
0answers
17 views

How do I quickly tell the structural differences between two databases? [duplicate]

I am upgrading a web application to a newer version and need to migrate the data manually. The newer version uses slightly different database structure. It has added a few tables, but all of the old ...
1
vote
0answers
65 views

Schema for ACL/User/Group/Role management

I'm building an app with some fairly complex permission and ACL rules and want to get my schema right. These are my goals: A user signs up on behalf on an organization. Organization has groups. ...
3
votes
2answers
337 views

Database Schema for Blank Database is large. 20MB

Is it normal for blank databases with just schema to be large? Or is there a way that I can reduce the size of the initial database?
0
votes
1answer
74 views

Copying MySQL schema, some tables not getting recognized!

From the 'data' folder of my colleague I copied the entire 'MyDatabase' folder and pasted that in my own 'data' folder.Now, some tables are getting recognized while others are not.**All the tables are ...