Questions tagged as 'modelagem'

Tagged questions
1
answer

ERROR CODE 1215 - You can not add the foreign key

Table 1: Table2: Command: ALTER TABLE extras ADD FOREIGN KEY (login) REFERENCES usuario(login); Response: Error Code: 1215. Cannot add foreign key constraint    Can not find an index in the referenced table where the   ...
asked by 11.12.2017 / 17:51
1
answer

Case Tool Use Case [closed]

How do I create use case diagrams, diagram all the use cases, or make diagrams for each specific scenario. Eg: I have several lines of work within the system, part of stock, financial part, sales part for customers. I create diagrams with all...
asked by 12.08.2017 / 05:13
1
answer

how to calculate the storage volume of a database

This is the following, I'm having concerns about a database being used in a project. The project consists of the development of a software for joining respective data to two solar spectrum sensors, and then storing them in a database along with...
asked by 02.06.2017 / 18:29
1
answer

Data modeling with people of different profiles

I need to create a system where people can play different roles. (eg teachers, students and server). The main information is: Teacher profile: name, address, email, area of expertise, discipline, etc. Student Profile: Name, Address, Email, Re...
asked by 28.03.2017 / 15:03
1
answer

Reports - Consistency of data when prices are changed

I have the following database: Requirements: The values of the kettles and the customers' addresses can be changed as needed. Each week I need to generate a report for this database, which should contain the information according...
asked by 29.09.2016 / 15:16
1
answer

Database table relationship [closed]

I have a registration form where it contains personal, professional, additional, financial and production information, my doubt, as it gives many columns, I believe more than 50 fields. Is it advisable to leave everything on a table? Or separ...
asked by 10.08.2016 / 03:00
1
answer

Modeling for student attendance

I have questions regarding the structure of the database for a frequency system. I thought of two structures and when doing a search I saw that the two exist and are used in different systems. 1 - The first one I have a frequencia table w...
asked by 18.04.2016 / 23:40
1
answer

How is a specialization implemented in a bank? [closed]

In my ER model and in the diagram I created a specialization for an entity called clients, where it relates to the physical and legal entities coming from that specialization. Do I simply create the relationships between these tables as if it we...
asked by 05.03.2016 / 14:08
1
answer

Relationship of products in models and bank

I'll try to be brief in my doubt. How can I model a class scheme that suits me in some things: This is all going to be done in rails 4.1, using ActiveRecord as ORM acting on MySQL. I will have a Person entity that will have a refere...
asked by 02.07.2014 / 04:47
0
answers

Doubt in use cases, digital bank financial system and credit card

Simple use case work. Digital bank and credit card financial system. The idea is to create an online account through an app (mobile app) without having to go to a physical agency. The user enters the data in the App and performs the registr...
asked by 29.11.2018 / 21:40