Rdbms Questions

I'm about to enter the 1st phases of designing a commodities trading application. a major function of this application is the capture and

I have this following code which prints the department number and department name from dept table whose department number is less than 40.

I used to write pl/sql procedures in oracle dbms. few times i would end up in situations like infinite loop and the query continuously running i

I'm just trying to get a general idea of what views are used for in rdbmses. that is to say, i know what a view is and how to make one. i also

I have a table called rev. it has only two columns. id and revnumber. here is my mysql fiddle

I am a coding beginner and i need help deciding on the way i will store data for the website i am building. i have a section on my website where i

I am building an ios app that is using cloud firestore (not firebase realtime database) as a backend/database. google is trying to push

Title is the question. when should a relationship in an er diagram be given its own table in a rdbms? for instance, one mail courier(with

Select pd.products_name, group_concat(pag.customers_group_id separator ',') group_id, pa.`options_values_price` retail,

I am not so into database and i have the following problem. i have a query like this: select

I have these two tables: product - id - name favorites - id - product_id - user_id so, a user can add product

I'm using sequelize-cli and have some trouble with using it. note that it's my first time using sequelize, might be i lost some concepts,

Here i have two columns like below example column1 & column2 in sql table and i want to get unique value row on the basis of

I have 2 tables with details as follows table 1 name | city | employee_id ----------------- raj | ca | a2345 diya | il

I know this might sound a bit ridiculous, but i got a doubt that if we can represent relationship between two tables, how the two table's data is

I am pretty new in sql and i have the following problem trying to implement the following query on a mysql database. so i

In this introductory tutorial on jdbc and relational

I'm using this loop to parse xml. for elementdetails in (select

What is the best, dbms-independent way of generating an id number that will be used immediately in an insert statement, keeping the ids roughly in

When a sql is translated to c by parser such as yacc or bison, does that piece of translated c code contains the the sorting algorithm

I've been searching on the net for the types of database indexes, but i haven't found a real answer. most of the pages say that there are two

How can i monitor an sql server database for changes to a table without using triggers or modifying the structure of the database in any way? my

I am creating an application where large number of data will be stored in the server. for example a to-do list. a user comes, writes down

I am facing a problem when i tried to create a database... i guess i am doing something wrong during the creation of db in android. i also

According to the picture: 1. why is mongodb,...(cp) 2. why is couchdb,..(ap) 3. why is rdbms (ca) note: why does partition tolerance not

Till today i was relying on laravel relationships, but since i opened mysql logs i was very disappointed. when i execute code