Questions tagged as 'modelo-relacional'

Tagged questions
3
answers

What is the correct MVC concept to be addressed?

I'm working on a Laravel project with the MVC concept and I had some questions. Let's say that I have a Client Management (CRUD), so I have a View (Screen with Client Data, TextBox, Combobox ...) a Controller , where I pass the screen...
asked by 31.01.2018 / 00:28
1
answer

Is it possible to state that the scheme is normalized in 3FN?

Explaining the Context In the internet I found an example of a scheme described in this way:    account (num-account, descr-account, post (num-lanc, tipolanc, data-lanc, Notice that the way this scheme is, it is not normalized....
asked by 11.11.2017 / 17:37
1
answer

Structure the paths to the images and videos of my product in the bank?

How can I structure the paths to my product images and videos in the database? Below is the SQL for creating the product table: CREATE TABLE products ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, quantity INT NOT NU...
asked by 14.07.2015 / 18:50
1
answer

Inserting a Foreign Key Id into a Relational Database

Good morning. I am a beginner in Database and programming and I have a question, what is the query to retrieve the id to insert into a foreign key table? I'm using the MYSQL database. Example, I have the "post" table, the post table has...
asked by 10.12.2018 / 13:25
1
answer

Doubts the database relationship of an application using spring boot

I am developing an application that aims to register a supplier, in which this supplier is generic (it can be a snack shop, building material store, a pharmacy ... etc) in which it will provide products on the web platform. However, for the fina...
asked by 05.06.2018 / 17:15
1
answer

Convention for attributes that preserve types

A table stores teachers data. Each teacher has a degree: specialist, master, doctor, postdoctor and others. Another table present in the database is posts . Each publication can (or does not) have a certain type: book, periodical, event, t...
asked by 21.07.2015 / 22:38
1
answer

Foreign Key Circular

I often see database modeled so that foreign keys close a circular reference, for example I used a template with cidade , bairro , and cliente . Here's the ER model: I understand that in this format, the data may be in...
asked by 18.08.2017 / 18:41
1
answer

PHP / MySQL - Print values relative to tables

In a system I need to print ink cans and each one has its own colors. I did it in a way that works, but it repeats the requests in the database several times. I made two tables (Example): latas ______________ id | nome 1 | uso geral 2 | t...
asked by 13.09.2016 / 16:43
2
answers

Many-to-many relationship between multiple tables

I know that between two tables in a many-to-many relationship 'we need' (not mandatory but facilitates) a third table pivot which is what conventionally relates the ids of one to the ids of another. So far so good. So for example to make a gen...
asked by 18.06.2016 / 12:56
1
answer

Doubts database / batch control system

I'm working on a project where I came across a problem where I do not know what would be the most efficient way to do it. My project has a product registration in which I want to control by batch, for example: Product - Rubber Lot 1 - I...
asked by 19.10.2015 / 17:41