Top "Relational" questions

Relational Algebra - Cartesian Product vs Natural Join?

I am studying for exams and am failing to find a solid criteria by which I can determine if the …

sql database-design relational relation relational-algebra
What is the difference between an entity relationship model and a relational model?

I was only able to find the following two differences: The relationships in an E-R model are explicitly defined, while …

database entity-relationship relational junction-table entity-relationship-model
How can I access the last inserted row ID within a SQL script?

I'm using SQLite, and I have a table for properties, and a table for sub-properties. Each sub-property points to its …

sqlite relational
Employee Department Relationship in Database

I'm designing a relational database for SCM (as part of designing information system for the enterprise). But when it came …

database-design relational
Database - Designing an "Events" Table

After reading the tips from this great Nettuts+ article I've come up with a table schema that would separate highly …

mysql database database-design relational partitioning
Easy way to store and retrieve objects in Java without using a relational DB?

Do you know of an "easy" way to store and retrieve objects in Java without using a relational DB / ORM …

java persistence relational
Relational attribute in Yii2 form

I am trying to get to figure out the proper way of handling a form receiving relational data in Yii2. …

php forms activerecord yii2 relational
How do you store a trie in a relational database?

I have a prefix trie. What is the recommended schema for representing this structure in a relational database? I need …

database-design schema relational trie
mySQL - Insert into three tables

I recently asked this question. I have a relational database with three tables. The first containts id's that relate to …

mysql database join insert relational
How to represent "not exists" in relational algebra?

How do I represent the SQL "not exists" clause in relational algebra?

sql relational-algebra relational