Questions tagged [application-design]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2
votes
0answers
40 views

Simple alternative to a crud application?

I have a relational star database consisting of about 9 datasets - 700mb. When I connect it to powerbi / qlikview / tableau, I can slice and dice it until I get to a resulting table of values. Now I ...
0
votes
0answers
44 views

modelling bill split app schema

I've been trying to model an efficient schema for a bill split app, the requirements are as follows: There can be groups in which there can be multiple participants, and conversations consisting of ...
0
votes
0answers
17 views

How can I connect central and decentral databases?

I am working in computational science and we are frequently producing large amounts of highly-structured data that depends on various input parameters. Right now, storing the data is managed via files,...
0
votes
1answer
16 views

How to add an additional table over two one to many relations tables?

I have two tables TableA and TableB which have a relation of one to many Later I am told that there must be an additional table that links the initial tables with additional information. To carry ...
2
votes
1answer
16 views

When should I reference the User record or User Profile record

I know it is a common paradigm to separate tables when building a User profile. For example, having a user table, and another table called user_profile with a foreign key to the user table. My ...
1
vote
2answers
40 views

How to scale with MySQL (when not ready to scale properly)

We are using MySql. My situation I have a large number of tables with millions of rows each. Those tables are updated every second and are used both for adding info and retrieving info. Each table ...
1
vote
0answers
31 views

How to structure SQL data model to maintain data integrity

Background I'm building a Private Chef booking service where you can book a Chef to cook you a custom Menu. I'm having trouble creating a SQL db schema that accurately represents the domain while ...
0
votes
0answers
26 views

How to structure cancelled orders?

I'm working with NoSQL Database "Firebase", and I have a node that contains 6 categories "services" in everyone I put an array of orders well? now when the user logged I get/fetch all orders bassed ...
-1
votes
1answer
75 views

Database design for 'pay at table' product (integrating with restaurant APIs)

I am doing a database project for Uni and am trying to figure out how a 'Pay at Table' app would work for restaurants. I Have found this example company that does this https://readytopay.com/ but i ...
1
vote
0answers
46 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
30 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
53 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
128 views

How to Analyze and Document a SQL Server Stored Procedure

I have been handed a large SQL Server batch process containing <100 stored procedures and functions. There is no documentation, I cannot rely on comments. High level, what are the best practices ...
1
vote
1answer
54 views

Omiting schema names to manage access to SQL Server databases more flexibly [closed]

When applications hardcode a schema name, dbo.TABLE, it reduces the DBA's ability to migrate the data as needed. Is it safe and more flexible for applications to omit schema names? I know you will ...
0
votes
0answers
268 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
79 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
50 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
68 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
1answer
41 views

Common practices to determine what database technology to use [closed]

Supposing I've started a new project that needs a database for persistence purposes. What are common practices to determine which database technology (MSSQL, MySQL, MongoDB, etc...) would best fit ...
2
votes
1answer
49 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
219 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
396 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. ...
2
votes
2answers
679 views

SqlDataAdapter vs SqlDataReader for DBAs

Speaking to developers about the use of SqlDataAdapter vs SqlDataReader and reading this: https://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader Yields little in the way of ...
0
votes
1answer
59 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 (...
0
votes
1answer
36 views

What sort of database setup is used for an App Store or Google Play Store? [closed]

I'm trying to build a desktop App Store, and it's just a small project for demonstration purposes, I'll be using java to create the application. In essence it's just a mock App Store that stores ...
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
23 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
303 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
647 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
180 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 ...
2
votes
2answers
97 views

Optimize architecture for SQL Server projects [closed]

I often find myself hacking together multiple .sql files for a project and calling them one after the other through Task Scheduler. Everything I know about SQL is self-taught, so I don't know anything ...
0
votes
1answer
983 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 ...
2
votes
1answer
150 views

Permission for business logic layer & application

I'm very new into db development and currently working on my first production app. I learned that I would need a business logic layer (BLL) to authenticate and authorize users, for example: John can ...
1
vote
2answers
701 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
106 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
185 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
29 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
3k 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
2answers
87 views

Validate application to access the database

I need some help for my issue I will explain. We have a delphi application named for instance App.exe. We use oracle database with our application. I would like to allow just my App.exe (my valid ...
0
votes
1answer
705 views

Can we use the multiple databases system concept in a single web application?

Am building a simple web based expert application.I have created two databases in the back-end,One database holds user data and the other holds user activity data.Hence it is accessed by a single web ...
1
vote
3answers
185 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
429 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 ...
1
vote
1answer
872 views

Keep files in Mongo as part of the data

I want to create a news app that works in the following way: The site will contain articles, and each article with have multiple versions. Each version is a docx file. The article itself does not ...
2
votes
0answers
463 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
50 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
841 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 ...
4
votes
2answers
624 views

How to prevent duplicates while storing result from different application

For my case multiple application uses data from db based on date, this data is date specific so if for a date data exist application should just read it otherwise it should fetch information from ...
0
votes
1answer
998 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: ...