Most voted "relational-model" questions
Relational model is based on two concepts: Entity and Relationship. Entity that is the one that contains the data and relation that is the way these data are associated.
Learn more…125 questions
Sort by count of
-
2
votes1
answer118
viewsRelational databases and relational object
What are the differences between relational databases and object-relational databases?
-
2
votes1
answer377
viewsRelation N-to-N - How to join two fields in a Postgresql record -
In a N-to-N relationship I have three tables "book", "author" and "author book". The following data and structures: tblLivro: id_livro | nomelivro '1' ; 'O Cortiço' '2' ; 'O mulato' '3' ; 'Quimica…
-
2
votes2
answers254
viewsDifference between relational table and online record
I have a structure of companies and categories organized in 3 tables: empresa -> Registration of all registered companies. categoria -> Registration of all registered categories.…
-
2
votes2
answers5168
viewsRelational database model with SKU
I am creating a system for selling products and I need that these products can have different prices according to their size or color, for this I am using SKU, I am creating the relational model of…
-
2
votes1
answer817
viewsHow do I make the relationship many for many in Ruby on Rails with has and belongs to Many?
I have a table system and a table category, a system has many categories and a category has several systems, I wanted to use the has_and_belongs_to_many option of Rails (for being a simple relation…
-
2
votes0
answers49
viewsMysql Relationships Table
I have a view called 'clients.Blade' where the administrator will choose which clients a particular developer can see, but I don’t know how to save these changes to the database. Model public…
-
2
votes1
answer128
viewsType of relationship between tables (Laravel)
I’m implementing my TCC, about photos and such.. But now I got a question when creating the tables... I’m using Laravel ok? Next, I have the following tables: users - roles - photos - tags works as…
-
2
votes0
answers356
viewsWhat are the advantages of using a Snowflake model, Star, under a relational model for B.I?
Hello, Nowadays, I see many B.I tools on the market advertising that their tools are "plug'n play", connect with relational bases, excels and "instantly generate B.I systems". This gave me some…
-
2
votes0
answers81
viewsWhat is relationship and relational model outside of the database context?
What would be relationship and relational model in the contexts below (removed from here)? Context 1: Double-Dispatch Maniero: I agree and I think [the lack of double-Ispatch support or the view…
-
1
votes1
answer412
viewsLIKE query in related table
I have a query that searches for TECHNICAL CALLS and in this research I do some JOINS to bring related information. I need the LIKE to also work for the CLIENT name (which is in another table) The…
-
1
votes1
answer796
viewsHow to add values from a column in Ruby/Ror
Loveliness? I’m trying to build an application in Rails. In it I have a resource where users inform the running time related to a category. Well, I need to perform adding up the total column time…
-
1
votes1
answer1370
viewsReturn only one item related to the main table
I have two tables, respostas and respostas_log, where I store information of the answers in answers and some others that have to go logging in reply_log. I am needing in my SELECT to bring only the…
-
1
votes0
answers1099
viewsProduct Stock Control Model?
I am creating a system and in it I will create a stock control of products, where I will have to manage entry and exit of products and check the quantity of products in each entry and exit…
relational-modelasked 8 years, 10 months ago FernandoPaiva 1,562 -
1
votes1
answer336
viewsRelationship with the same MER entity
I am developing my tcc and came across the following doubt in my MER(Relationship entity model). I have a client entity that pays another client, but just as I represent it in the ER? Like that’s…
-
1
votes2
answers223
viewsModeling Database
good morning! I have the following problem in user, form and group relationships. In the way that the relationship (CONTEM) was modeled, it will become a table where it will have the user keys, form…
-
1
votes0
answers27
viewsMethod to calculate development time of entity-relationship diagram
Is there any method for calculating the delivery time of the ERI diagram? Objective: to provide the client an estimate of time to complete the DER diagram of a software development project with 114…
-
1
votes1
answer122
viewsUse of STI(Single Table Inheritance) on Rails
Assuming a project in Rails with the models Livestock, Agriculture, Piscicultura e Benfeitoria. These inherit the properties of a model called Activity and are considered types of activity. Models…
-
1
votes0
answers73
viewsVertabelo - Warning: Reference Name seems to be invalid
I’m using the vertabelo because I need to share my program with others, but when I brought my work to it. He appears the following warnings, someone knows what it is? link:…
-
1
votes0
answers53
viewsEDR diagram creating an online shop
I am trying to create a diagram EDR, I believe on the part of customers I have well made connections, but on the side of the administrator who has access to everything, product information, order…
relational-modelasked 6 years, 3 months ago Diana Madeira 485 -
1
votes1
answer416
viewsRelational model for user login
I need to make a simple trademark registration system, but I would like the person who is registering a new brand to be logged in to the system, I have a difficulty where to fit the login table in…
-
1
votes1
answer90
viewsHow to register each new relationship between two entities
Considering a scenario where a member has a account, personal profile, academic profile and may vary between status (between pre-defined status: teacher, student and collaborator) within the system.…
-
1
votes1
answer114
viewsBank related creation
I am doubtful whether or not I am doing the right thing in setting up this bank. They could help if the way is right or wrong. For now I just put id in the tables. Gang Turma | Turmaid A 1 B 2 C 3 D…
-
1
votes1
answer28
viewsReturn three different values between two tables that have no relationship in Mysql
I have a database with 3 tables, where relationships and attributes are distributed this way: Precise Retornar o nome, data de nascimento e número do cartão das pessoas em ordem decrescente pela…
-
1
votes1
answer137
viewsJust create the relationship too much for many in Ruby
I have a very long-standing relationship with Yell and Category entities: model Yell.Rb class Yell < ActiveRecord::Base belongs_to :user, inverse_of: :yells has_and_belongs_to_many :categories…
-
1
votes1
answer1551
viewsLaravel - List with list of tables (state/city=>person)
I have the following tables: contacts => id - name - state - city states => id - status - acronym cities => id - city - id_state And the following models: Php state. <?php namespace App;…
-
1
votes1
answer182
viewsLaravel - Search if there is a relation in the many-to-many table
I need to search users according to some filter attributes. I have the table contacts: id | nome | email 1 | asd | [email protected] 2 |teste | [email protected] The table groups: id | grupo 1 | grupo1 2…
-
1
votes1
answer621
viewsModel E.R - Correct?
Hello, I will be developing a project for my computer technician course and I am having difficulty with a Model E.R. The thing is, this is the description of the project, but will I ignore the…
-
1
votes1
answer214
viewsDifferent Model type objects mapped from a single table
It is possible to map from a single table of the database different objects of type Model with Activerecord in a Ruby on Rails project? Suppose I have in the database a table with the name customers…
-
1
votes0
answers85
viewsEvolution of the code-controlled data model
In a scenario where the application is deployed for production through a pipe line run by an CI server, where the server performs the following tasks: Installs front end and back end dependencies.…
database relational-model automation continuous-integrationasked 8 years, 4 months ago Dimi Antoni Vargas 316 -
1
votes1
answer282
viewsRelationship of tables with the same attributes
My system is for employee control. Where we have the following types of people(or positions): agent, analyst, supervisor, coordinator and manager. Like I did: I created a table for each type of…
-
1
votes1
answer724
viewsExample and illustration about redundant relationships (MER)
Context Consider the sentence below: It is claimed: Relationships that are the result of a combination of other relationships between the same entities are called: redundant relationships Doubt…
-
1
votes3
answers135
viewsWhat is the correct MVC concept to be addressed?
I’m working on an Laravel project with the concept MVC and I had some doubts. Let’s say I have one customer management (CRUD), so I have a View (Screen with customer data, Textbox, Combobox ...) I…
-
1
votes1
answer121
viewsHow to perform a consultation in the bank applying "exceptions" with a relationship?
I need to get all users with "Exceção" those of the function containing the id=2, it is possible? You can fit a Where in that consultation? I have the following consult at the bank Laravel which…
-
1
votes0
answers62
viewsData Modeling (Relay Scale System)
I’m developing a relay scale system. Think of it as a kind of calendar, where one day has multiple shifts, shift has multiple positions, and employee is scaled to the position. Employee may be on…
-
0
votes1
answer1533
viewsHow do I enter into a ternary relationship?
I am creating this model however I do not know if it is correct. I have basic knowledge in database. How do I enter into a ternary relationship that happens in Supplier - Suppliers_has_product -…
-
0
votes1
answer42
viewsStructuring in the bank the paths to the images and videos of my product?
How can I structure in the database the paths to the images and videos of my product? Below the SQL of product table creation: CREATE TABLE products ( id INT AUTO_INCREMENT PRIMARY KEY, name…
-
0
votes2
answers176
viewsAs foreign key reference alternating tables
I have a City, State and Country Database. But I want to add Cities to my table and it doesn’t always contain a state to be referenced. However, every city is located in a country. My question is:…
-
0
votes1
answer93
viewsAssociation in Devexpress XPO models
I have a model for Municipio. This model can be referenced by several other models (Customer, Supplier, Carrier, Seller...). Each of these models has an association N:1 for Municipio, +/- so: public…
-
0
votes1
answer779
viewsGeneralization in a Database
I’m modeling a job, I stumbled into a situation I don’t know how to proceed: In a Medical Clinic, a PERSON may be PHYSICAL or LEGAL. THE PATIENT, MAY ONLY BE A PHYSICAL PERSON Here comes the doubt:…
-
0
votes1
answer220
viewsGetting Data from a Manytomany Relationship with Doctrine2
I have the following relationship N:N between teacher tables and classes, where there is a third teacher table. I want you to list the teachers and bring me all the classes this teacher teaches…
-
0
votes1
answer342
viewsCircular Foreign Key
I often see database modeled so that foreign keys close a circular reference, to exemplify I used a model with cidade,bairro and cliente. Follows the ER model: I understand that in this format,…
database software-architecture relational-model foreign-keyasked 7 years, 5 months ago Rovann Linhalis 14,881 -
0
votes1
answer45
viewsRelation between table A and B returns error because it calls data from table C in Cakephp
I am 3 days banging head with a problem: I have some tables in the system and this error happens on the most unlikely screens. I’ll give you the latest example: 2015-03-13 16:37:51 Error:…
-
0
votes0
answers6522
viewsDatabase, logical and conceptual model
Can help me in these logical and conceptual models, wanted to know if this right or wrong the one I did to deliver, is a car rental.…
-
0
votes1
answer331
viewsDoubt in database relationship of an application using spring boot
I am developed an application that aims to register a supplier, in which this supplier is Generico (can be a cafeteria, store building material, a pharmacy... etc) in which he will provide products…
-
0
votes2
answers46
viewsHow do I complete information that is in a complex JSON type?
I am trying to carry out the filling of a Icollection type that is owned by my Professional model. When performing the request I pass the information via JSON But in VS debug and GET the information…
asp.net-mvc json entity-framework relational-model modelasked 6 years, 4 months ago Fabricio Pereira Cardoso 33 -
0
votes2
answers514
viewsConceptual model of two relationships between two entities
Hello, I’m starting the study on conceptual modeling and relationship entity until I came across a question and so far not found similar examples. To simplify, I have two entities, TIME and START.…
relational-modelasked 6 years ago Heminio Gurgel 1 -
0
votes1
answer56
viewsConvention for attributes that preserve types
A table stores data from teachers. Each teacher has a degree: specialist, master, doctor, post-doctor and others. Another table present in the base is the publications. Each publication may (or may…
-
0
votes2
answers89
viewsCalculate number of sales of a seller
I’m doing academic work on comics, in this case I’m developing a database for a food distributor. I am in doubt as to how I can count the amount of sales that a seller has made in order to calculate…
-
0
votes2
answers59
viewsTable Receives 2 foreign keys - Relational Model
I have a table called QR-Code, this can be sent by an employee, or by a resident, but in the table Qr-code has to have only one code of who sent it, as I can represent it in the relational model??…
-
0
votes1
answer31
viewsChange report in Database
We have several tables that some users will have permissions for changes. I need to have a table of changes made by the user. Let me give you an example. Let’s assume a products table, this product…