All Questions

Filter by
Sorted by
Tagged with
1
vote
0answers
38 views

Room bookings database - does it make sense to create two tables instead of one column?

There are two types of entities: user and room. A user can book room select room unbook room unselect room "Selected room" is a state that indicates when a user has decided to book a room and so he/...
0
votes
1answer
29 views

Should you update child states based on the parent?

I have the following table structure Event --* Session --* Membership An event can be cancelled - reflected via a status column A Session can be cancelled - reflected via a status column A user can ...
0
votes
0answers
43 views

Is a Booking System where User and Participant are Different Entities Correct?

Background I am building a event booking system for a youth organisation. The events that can be booked are targeted in general at children under the age of 18 (i.e. which in Europe means that you ...
0
votes
0answers
78 views

Building an Entity-Relationship Diagram for a Language Dictionary

I need advice on how to build entity-relationship diagram (ERD) for Language Dictionary. Since I did not build ERD before, I will try to explain and show the ultimate goal of this project below. ...
1
vote
1answer
33 views

How to handle removing ASP.NET users where their UserID is tied to rows that should be maintained even after a user is deleted?

I have a website that uses ASP.NET membership and so there are multiple aspnet_... tables in our database. We are creating a service for the users that allow them to essentially create laboratory ...
1
vote
0answers
39 views

Foreign keys pointing to “look-up” tables: Should we reference Id or Code values? [closed]

We are rewriting from a huge monolithic application to smaller application using rest. While the old application had one huge tables called REFERENCE tables with applicable values had all these ids ...
0
votes
1answer
65 views

Any way to represent simple AND/OR business logic in a database?

I'm designing an application to provide students access to modules once they have completed certain online courses. I have tables for: Students, Modules, Courses, and StudentCourseResults. Course ...
0
votes
0answers
31 views

Set up table for relationship type with both users in a different visitor table

I am a newbie in database driven application, and I just started working on a web app for my brother and parents clinic to manage patient records. So for their clinic I have one table Visitor that ...
2
votes
1answer
43 views

DB design to avoid versioning inconsistencies between the application layer and the database layer

Usually there is a 1-1 mapping between an object in the application layer and a table in the database layer. This coupling leads to complexities whenever there is a database schema change and the ...
3
votes
2answers
191 views

What is the industry term for superset of “metrics” and “dimensions”? [closed]

If I want to refer to measures/metrics and dimensions with a single term, what would be a good industry-accepted expression? Metrics is used commonly in UIs as well such as Google Analytics or ...
2
votes
2answers
128 views

Insert/update data into relational database tables only after administrator approval - how to approach it?

I'm building a relational database that holds 21 tables, which is connected to my website application through PHP. The website has search functionality which allows users to search this database. ...
0
votes
1answer
54 views

SOA and Oracle cascade data between two pdb

I am Java developer and need help for design and manage database . Please view this picture : I have two service named : 1) Authentication Service (Register new user and login) 2) Customer service (...
2
votes
1answer
41 views

Using Text Fields As Booleans

We are developing a product system and I was curious to what industry standards were for many Boolean statements. In our system we have some, what you could call main, bit fields. E.G. isBackordered, ...
0
votes
1answer
22 views

Help with schema design [duplicate]

I am having trouble designing a schema in which there are two models an employee and projects. I am storing employees details in a table structure as: id | employee | report_to wherein employee ...
1
vote
1answer
74 views

MSAccess: creating a new row in a related table and linking it back to the “master” table

In a hypothetical 'cars' database, assume there's a model table and a make table: models modelID int model varchar make int makes makeID int make varchar Model's make column has a foreign ...
6
votes
1answer
587 views

Entity-relationship diagrams and application program functionalities

It seems that the core functionalities of an application program I'm working on are nothing but associative entities. Hence one-to-many relations sort of produce "metadata" that will only feed (one ...
-1
votes
1answer
105 views

When to create a new table and when to differentiate between table columns?

I am not too experienced in database best practices so I am wondering if anyone has some advice on whether to make a new database table or just differentiate between columns on an existing table. For ...
0
votes
1answer
751 views

Best way to design a database for a bakery store? [closed]

I am building an application that will be used as a Sales Management system for a bakery store. I have built the following tables: Products has a single row per product. This is a Master Data ...
1
vote
2answers
475 views

How to use a foreign key?

I'm creating the following table: CREATE TABLE fund_identifier ( id BIGSERIAL PRIMARY KEY NOT NULL, identifier TEXT NOT NULL ); CREATE UNIQUE INDEX IF NOT EXISTS fund_identifier_pkey ON ...
1
vote
1answer
90 views

Database Designer's Block

Aloha DBA's, I've got major DB Designers-block and I can't wrap my head around the proper way to design the database to meet my web application requirements. This is strictly a DB design question and ...
1
vote
1answer
117 views

Avoiding foreign key repetition on related tables in a relational DB

I have a simple DB schema describing certain objects that belong to a historical time period of a country and (optionally) a subdivision of that country at that period. The contrived UML class diagram ...
1
vote
1answer
25 views

How should I design a re-usable content like table?

So I've got a database that holds articles, recipes, and comments in seperate tables, and I'm wanting to allow users to be able to like each of these content pieces (articles, recipes, comments). I'm ...
3
votes
2answers
2k views

Can I use a single stored procedure to operate on different schemas based on the executing user

I have thousands of schemas with same set of tables, Each user has a default schema. But I dont want to create copies of a single stored procedure in every schema. Can a single stored procedure access ...
1
vote
3answers
135 views

Relational tables with same content, custom solution

So let`s say that I am building an app where I can add comments for FOO. Normally I would have something like this: Table foo and table foo_comments, where foo_comments contains id, foo_id and other ...
0
votes
1answer
311 views

Mongodb database design

I'm planning to implement this schema in Mongodb, I have been doing some readings about schema design, and the notion was whenever you structure your data like a relational database you must be doing ...
2
votes
0answers
290 views

Design university schedule system

I'm not sure if this is the right place to ask for tips and improvements in a database design but I don't know about another one. I want to design a simple University system. Below I'll have included ...
2
votes
0answers
49 views

insert/update from web server or database

I have a data-model on the front-end that I want to insert/update in the database which of the following approaches (or neither!) is considered best practice: # in webserver some_model = {json} ...
5
votes
2answers
578 views

Efficient Database schema for multi-lingual content?

Assume I have a table for blog posts, posts, and schema as id author title content and each post can belonged to some categories id name descrtiption So a blog post can belong to multiple ...
-1
votes
1answer
1k views

Database design for timetable in mysql

I have to make a web application in java. The web application is like a online appointment book. Everyday of the week has 1 column with times from 9.00am to 10.00pm (only full hours). I already ...
0
votes
1answer
802 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 ...
1
vote
0answers
34 views

Storing resource information efficiently

I'm looking for any advice on how to efficiently store some resourcing data for our app. For each project in our system we need to store the resources required and this comes in the following form: ...
1
vote
1answer
45 views

design database with 2 simillar tables

I have a database which has product_sell and product_buy tables, these two tables are different in a few fields and each one has own comment table product_sell >---< product_sell_cmt ...
1
vote
1answer
74 views

Should my application utilize database credentials for user login?

I'm working on an application that has an ASP front end and a SQL Server database. The way credential management is currently performed is there is a custom built User Table in the database that ...
1
vote
1answer
50 views

Is it possible to execute queries in random order?

I have a list of INSERTs, UPDATEs and DELETEs queries. My problem is that I always receive them in the wrong order (random), and I cannot know their original order. Are there techniques to group/...
0
votes
1answer
216 views

when to put a business rule in the business application layer or into a database constraint

I need you wisdom, I am debating with another person when is it recommended to put the code of a business rule into a database constraints or inside of the application business layer? There is a ...
0
votes
1answer
3k views

Database structure for users, events and event lists

I am creating a web service for managing events. The service will have users, who are listed in one database, called Users. It will also have events, which are listed in another database, called ...
0
votes
1answer
133 views

Comma List vs Multiple Records

I am currently building out an application that will contain many users, two roles and two groups. Logically we want users to be able to be administrators of other users within the two groups. User ...
0
votes
1answer
502 views

Division Email Template DB Design [closed]

First question for me on the DBA SA site! This is for an Java email notification app using MySQL for backend. I have a small number of groups in our organization, [Marketing, Commerce, ...
0
votes
0answers
70 views

Tables with same schema in DB for different sources. Bad pattern?

The main purpose of the system being developed is to collect data from different sources, process and standardize it, and then add it to the DB. After information from all sources is collected it ...
0
votes
0answers
170 views

Database & Structure for SaaS reporting software

I'm building a SaaS application to allow users to upload data and perform reporting and analytics on it. The reporting and analytics would be quite simple like grouping and aggregating. This has ...
0
votes
0answers
26 views

How to model mappings at various levels

I'm trying to design the database model for my application and I'm finding it difficult to design the mappings for user access to various entities stored in the database. If access was only ...
0
votes
1answer
28k views

Inserting data into multiple tables

For my system, students are required to create a user account by completing a registration form (personal, contact and course details; also username and password). I need to collect registration data ...
4
votes
2answers
330 views

Database instance and database

I did some research and finally came to this conclusion: Database instance = processes + memory Database = (physical) log files + control files + data files. Is this understanding correct? ...
0
votes
1answer
105 views

Is array serialization always bad idea?

I'm making form-generating app in php. I have Widget table with type_id (html input) field, and I would like to add options field, like width/height, step, range, etc. Different widgets do have ...
2
votes
1answer
451 views

How would I model the Twitter lists functionality?

I'm working on an application which would mimic the Twitter Lists functionality in which someone can follow someone else. Each user can also create objects which can be followed by users. The Twitter ...
0
votes
1answer
2k views

Airport Database Design guidance required

I am trying to make a generic database for airport management and DBMS would be oracle 11g xe. Since, i am amateur and still learning so i have tried to kept the problem statement simple with limited ...
0
votes
0answers
139 views

Efficient way to fetch/update X records in a loop

What I need is a simple process that handles requests. I have setup a simple table as follows: CREATE TABLE Requests ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, request_param VARCHAR(250) ...
0
votes
1answer
297 views

Help With MySQL Computed Columns/Auto Updating Field Based On Average

I am currently building a social network type application on-top of MySQL and have run into a problem I can't wrap my head around. In my web application each user has a field called "weight" and this ...
0
votes
1answer
4k views

Digital content eCommerce schema advice? [closed]

I don't have much experience designing databases, I'm looking for some advice on my design from more seasoned designers/developers. I'm developing a digital content eCommerce store which will be ...
2
votes
1answer
73 views

Denormalize Design Modification

Our DBA is on medical leave, I am just a developer trying to do my part. Initially, the bean counters were going to use quickbooks. However, after seeing how much time they could save with custom ...