Posts by Jonathas B. C. • 883 points
34 posts
-
1
votes1
answer225
viewsQ: What is so-called functional and non-functional (quality) requirement?
Contextualizing the question While studying software engineering some time ago, in the classroom a request was made formal and informal explanation regarding what would be a non-functional…
-
1
votes0
answers111
viewsQ: Is requirement traceability matrix the same as bi-directional traceability between test cases and requirements?
Contextualizing When studying for certification CTFL - Certified Tester Foundation Level came across the following study. Below Basic Activities in the Test Execution Process Plan and control…
-
2
votes1
answer98
viewsQ: Should failed completed transactions persist in the database?
When I came across this statement I was confused, could anyone clarify? Question: One of the known properties in relational databases as ACID is the durability, according to which, in a successfully…
-
1
votes1
answer232
viewsQ: Does Contact Page work on Github Pages?
When designing a simple contact page prototype, I remembered that there is a possibility that the project will be hosted by Github servers. Example But I also remembered that hosting with Github…
-
2
votes1
answer208
viewsQ: HTML5 Semantic Structuring, How to Use?
Context I was making a template prototype for a website, and I came across a question regarding the tag <aside>. Below is an example to explain the semantic division. Explaining the tags Tag…
-
0
votes1
answer1241
viewsA: Github Pages failing to load resources with error 404
Apparently the problem was solved with the withdrawal of the underline in the name of each folder, I had not noticed before because the loading of the pages was slow to load and I had to remove this…
-
1
votes1
answer1241
viewsQ: Github Pages failing to load resources with error 404
I tried to move up a project I had done some time ago, and using the Github pages to play online, I find it difficult to render. The files he can’t load are all in repository, I don’t understand the…
-
2
votes2
answers1061
viewsQ: What are real and practical examples in the use of Stored Procedures?
When participating in an interview for the position of developer, I come across a question related to Stored Procedure (SP) and at first I have theoretical knowledge on the subject, but I have never…
-
1
votes2
answers97
viewsQ: How to use pseudo names with CONCAT and Mysql?
A question about Mysql asks the result to exit in this answer format. When finishing my solution through a consultation made on Mysql, find the following problem. Below is a first example solution…
-
7
votes3
answers3104
viewsQ: Why does GROUP BY not work with Mysql in this case?
I am using the Mysql language and am trying to group a table of professions with the GROUP BY through the consultation below. SELECT name, occupation FROM OCCUPATIONS GROUP BY occupation; But I get…
-
0
votes1
answer413
viewsQ: How to use pseudonyms in queries using Aliases along with Mysql?
I would like to be able to use the Alias 'AS' along with mysql without having to do query alignment, that is, I want the secondary queries to be named to use them in the main query, it is possible?…
-
0
votes1
answer48
viewsQ: Consulting cities without repetition and with different "WHERE"
When trying to resolve a platform bank issue hackerrank I could not understand the answer after having found in the discussion wing. The question says: Query a list of CITY Names from STATION with…
-
4
votes1
answer630
viewsQ: Why does the decrease of the subnet mask fold the size of the original network?
Reading about IP protocol and network addressing, I don’t understand why the "diminishing" the size of the subnet mask in 1 bit, generates a "augmentation" network size. I understood the reason for…
-
3
votes1
answer215
viewsQ: Sprint in Scrum methodology can’t have the scope negotiated?
Regarding the scrum methodology, would like to know. It is correct to state whether during the Sprint: The scope can be clarified and renegotiated between the Product Owner and the Development Team.…
-
2
votes1
answer150
viewsQ: Are there classification metrics for the elaboration of SQL queries?
Doubt Have some method to sort in difficulty levels, an SQL query in easy, medium or difficult? This question may be a little subjective, but speculating may be a good option. Context I was…
-
1
votes1
answer1955
viewsQ: Roll-Up or Drill-Down, which has the most Detail in Data Warehouse?
Context Studying on data Warehouse(DW) I came across the content regarding the types of OLAP servers and the types of operations that can be done, within this context I was confused regarding the…
databaseasked Jonathas B. C. 883 -
1
votes1
answer237
viewsA: Bottom Up Approach in Data Warehouse
On the Internet I was able to find this justification: The author of the book states: Kimball’s proposed Botton Up architecture, called "Bottom Up", begins with the extraction, transformation, and…
databaseanswered Jonathas B. C. 883 -
2
votes1
answer237
viewsQ: Bottom Up Approach in Data Warehouse
Within the context of Data Warehouse(DW), I would like to know: Why is it correct to state that this approach (Bottom Up) does not guarantee standardization of metadata, and may create data…
databaseasked Jonathas B. C. 883 -
0
votes1
answer68
viewsQ: Is it possible to say that the scheme is normalized in 3FN?
Explaining the Context In the internet found an example of a scheme described in this way: account(num-conta, descr-conta, launching(num-lanc, tipolanc, data-lanc, valor-lanc)). Notice that the way…
-
1
votes0
answers64
viewsQ: What is the meaning of using robots on Github pages?
According to this Response of the Stack Overflow it is possible to use robots.txt for avoid that search engines index the pages that the webmaster does not wish. How is that possible? through a…
-
2
votes3
answers178
viewsA: How to take width of div when minimize screen - Bootstrap
Try to use the bootstrap grid system see here, using it you don’t have to worry about the width and height of the components you are using, not to mention that your website is responsive. If you use…
-
1
votes1
answer70
viewsQ: Is Data Warehouse Transaction Oriented or Query Oriented?
Context of the Problem Reading on the subject Data Warehouse, I have drawn some distinct conclusions about what the text book says. Note what the author explains regarding transaction-oriented DW: I…
databaseasked Jonathas B. C. 883 -
3
votes1
answer115
viewsQ: Why does bitmap indexing work well for low cardinality domains?
I have just read chapter 29 of the book Overview of Data Warehousing and OLAP On page 725 the author talks about indexing techniques to support high performance access, this technique is called…
-
2
votes2
answers66
viewsQ: Is indexing sites by half possible?
When browsing the internet reading articles and more articles, I came across some that are only displayed in half, or just the beginning, here’s an example. In this case, only those who are…
-
1
votes0
answers820
viewsQ: What is the significance of Overhead in physical database design?
I just read about physical design and database adjustment and could not understand the concept of overhead, and consequently could not understand what the author of the book wanted to explain. I…
-
1
votes3
answers472
viewsA: MER - Temporal confusion of cardinality
I believe the problem is possibly divided or can be interpreted in 2 ways or parts. First part Books generally do not put the minimum cardinality, only the maximum which can leave the example a…
-
4
votes0
answers210
viewsQ: Example of Scheme respecting the 3FN?
When studying about 3FN I came across 2 interesting examples and I wondered if when making a small change, the examples would continue to meet 3FN. Explanation about the concept of 3FN Explaining…
-
4
votes1
answer201
viewsQ: Why do normalized schematics up to 3FN not have N:N relationships?
Explanation of the concept I believe that by definition a database schema is found in 3FN, when it is in 1FN,2FN and nay has transitive dependency. Transitive dependence is when an attribute NONKEY,…
-
2
votes3
answers951
viewsA: Table normalization for 2nd Normal Form
Based on the book conversion examples, below is an example of 1FN to 2FN and 2FN to 3FN. Based on the drawing of the book, I made a drawing to try to help in your question. As your question was…
-
1
votes1
answer724
viewsQ: Example 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…
-
4
votes1
answer681
viewsQ: Mutually exclusive relationship (MER)
I know there are several ways to implement this conceptual model, but I would like to know the best way (if there is one that stands out) Caption PK : Primary Key (primary key); FK : Foreign Key…
-
2
votes1
answer4985
viewsA: Model Entity Relationship: Ternary vs Aggregation?
There is a slight difference in the MER and UML approaches, I believe that by your question these concepts are a little confused. Notation MER x UML In the Entity Relationship (MER) modeling there…
-
1
votes1
answer336
viewsA: Relationship with the same MER entity
The book claims to be a recursive relationship. I believe it is possible to make a comparison with the example of the book I drew a drawing in the draw to represent the answer. In this way it is…
-
8
votes2
answers430
viewsQ: Deadlock at Conceptual Design Level, Entity-Relationship Modeling (MER)
At conceptual design level we can use the approach (relationship entity modeling (MER)) to describe the behavior of future tables that will appear in the logical project. Within that context a doubt…