Questions tagged as 'modelo-relacional'

Tagged questions
1
answer

Use of Generalization / Specialization in data modeling

I've read some articles about Generalization / Expertise in data modeling, but some doubts have emerged: Is the primary key of generalization also the primary key of specializations - that is, can specializations contain their own primary keys...
asked by 27.10.2018 / 17:48
1
answer

How to import a .er1 file extension into CA Data Modeling

I need to import an .er1 file from an older version of Erwin into CA Data Modeling (Community Edition). Is this possible? I tried to open it directly and the "Import" options to no avail. Thanks for any help?     
asked by 01.12.2014 / 14:36
0
answers

What is relationship and relational model outside the database context?

What would be relationship and relational template in the contexts below (removed here )? Context 1:    Double-dispatch       Maniero: I agree and think [the lack of double-dispatch support or the view that double-dispatch must be...
asked by 02.03.2018 / 20:46
0
answers

What are the advantages of using a Snowflake, Star model, 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 databases, excels, and "instantly generate B.I systems." This gave me some doubts, as I already had a session in the...
asked by 16.02.2018 / 19:48
1
answer

Type of relationship between tables (Laravel)

I'm implementing my CBT, about photos and such .. But now I got a doubt in the time to create the tables ... I'm using Laravel okay? Next, I have the following tables: users - roles - photos - tags works as follows: There are functions o...
asked by 15.08.2017 / 03:04
0
answers

MySql Relationship Table

I have a view called 'clients.blade' where the administrator will choose which clients a particular developer can see, however, I do not know how to save those changes in the database. Model public function Clientes () { return $this-...
asked by 29.03.2017 / 19:11
1
answer

N-to-N relationship - How to join two fields in a Postgresql record -

In an N-to-N relationship I have three tables "book", "author" and "book_autor". Being the following data and structures: tblBook: id_livro | nomelivro '1' ; 'O Cortiço' '2' ; 'O mulato' '3' ; 'Quimica Geral' tblAutor...
asked by 30.03.2016 / 16:21
1
answer

How do I make many-to-many relationship in Ruby on Rails with has and belongs to many?

I have a system table 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 interface and even to learn how to use this feature). Bu...
asked by 26.09.2016 / 15:58
1
answer

Filling tables with multiple foreign keys [closed]

I have a database with the following tables: Airport Airport Cause_Cancelation (CodeCanceling PK , description) Manufacturer (ManufacturerName PK , manufacturername) Template (Template ID PK , template_name, FK...
asked by 09.08.2015 / 19:25
2
answers

Specialization and generalization in database and application development

I have a Livros table and I know that book specialization / generalization is Livros de Ficção , Livros de Drama and Livros de Suspense , for example. However, in the logical model, I do not know if I create a table...
asked by 08.07.2018 / 22:28