Stack Overflow
Stack Overflow

Questions tagged [referential]

referential is referring to the referential integrity concept of relationel databases.

is referring to the referential integrity concept of relationel databases.

Simply put, referential integrity means that when a field in a table refers to a corresponding field in another table, that corresponding record must exist.

Typically, but not necessarily, referential integrity is a one-to-many relationship. A table hold many records with a field that refers to the same record in another table. The field in the first table is called a foreign key, the field in the second table is called the primary key.

Referential integrity is a relational database concept which states that table relationships must always be consistent. In other words, any foreign key field must exist in the referenced table, and any changes in the referenced table must be applied to all foreign keys, or not at all.

17 questions
2
votes
1 answer

Achieving referential integrity in an Employee, Manager and Department relationship

I found a case in ER where for the life of me I can't figure out how to achieve referential integrity. The classical Employee, Manager, Department relationship can illustrate this problem. With the following constraints: Employee can work in only…
Maksym Bykovskyy
  • 832
  • 1
  • 8
  • 18
1
vote
1 answer

Referential Arrays in Python

I have started learning Data Structures and Algorithms. Please help me with my doubt. Is it ok to say that lists, tuples, and dictionaries are a type of referential array? I was going through the example in the book where it was written that we…
user9855045
  • 33
  • 8
1
vote
3 answers

Haskell: type variables and generic types

When I mention in the type signature of the function isQuestion the types explicitly, GHCi compiles it perfectly: isQuestion :: [Char] -> Maybe Bool isQuestion [] = Nothing isQuestion xs = Just (last xs == '?') However, when I turn to 'generic'…
devio
  • 1,147
  • 5
  • 15
  • 41
1
vote
1 answer

Does Haskell has the concept "construct" like C and ML language?

This wiki page: https://wiki.haskell.org/Referential_transparency talks about "C and ML are languages with constructs that are not referentially transparent." My question is, what is "Constructs"? Is it an abstract concept? Thanks.
Hind Forsum
  • 9,717
  • 13
  • 63
  • 119
1
vote
3 answers

Algorithm 2D Referential traduction

I am trying to build a function grapher, The user enters xmin, xmax, ymin, ymax, function. I got the x, y for all points. Now i want to translate this initial referential to a Canvas starting at 0,0 up to 250,250. Is there a short way or should i…
coulix
  • 3,328
  • 6
  • 55
  • 81
1
vote
1 answer

MySQL delete table with regard to referential integrity rules

I want to delete tableA while removing all rows in tableB that have matching tableA.A_ID = tableB.A_ID Currently I have a foreign key set to CASCADE on delete and update set on TableB for tableB.A_ID.
RiCHiE
  • 278
  • 3
  • 14
0
votes
2 answers

Checking Referential Integrity prior to Delete in APEX 20.1

When a user tries to delete a code/validation record, I would like to check to see if the code in that record has been used prior to the deletion attempt so I can display a message that is more meaningful than an Oracle constraint error. For…
LG-C
  • 47
  • 6
0
votes
1 answer

Check constraint to enforce referential integrity?

Can we use a check constraint to enforce referential constraint? Let's say I have a column that contains a UUID; this UUID can reference either table A or B depending on the value of a 2nd column. ------------------------------------------ |ID …
samg
  • 311
  • 1
  • 8
  • 21
0
votes
1 answer

Acumatica - Rename Referential Grid field

I want to rename a column from its Name in DAC at the place it is reference, the ID field is part of DAC while the Name field is reference by the main DAC using Table__Field in the Grid, How that can be renamed, I tried the Below code but it is not…
Shaj
  • 37
  • 7
0
votes
1 answer

How to Combine Two Referential Lists With Python

I have stupid data coming out of a system, it needs to be flattened. The main csv has these columns: hostname, program_name, version_name However, there is only one row per host, so the last two fields look like this: program_name…
gunslingor
  • 1,358
  • 12
  • 34
0
votes
1 answer

Can Child table from 1-many be a parent to another table thats many to 1

1)GroupParent1 table( Gid, value) (111,Shirt) 2)GroupChild1(Gcid, Gid, value) (1,111, blue)(2,111, cotton) i.e. Stores attributes for products so a group of attributes in this table can have one or more row. ISSUE: Another table called 3)Price…
Hem
  • 130
  • 2
  • 12
0
votes
0 answers

Is Referential integrity between tables mandatory for custom conflict resolver in sql merge replication?

I have a database which have multiple tables but these tables have not any relationship define(Referential integrity) in database. They are related to each other but maintained by trigger and application. I have created custom conflict resolver on…
Deepak Joshi
  • 1,036
  • 7
  • 17
0
votes
1 answer

Option literal vs. Option variable

can anyone explain the behaviour of this snippet: def test = { val xt: Option[String] = Some("1") val xx: String = "2" xt match { case Some(xx) => println("match") case _ => println("no match") } xt match { case Some("2") =>…
Volker
  • 35
  • 4
0
votes
1 answer

Xtion Vertical position usage ( calibration ) with Skeleton

I am currently working on the "Xtion pro live" by using "OpenNI" library. The problem is that the Xtion must be vertically placed (along a wall). The problem is that in this position the user calibration always fails, so it is impossible to get the…
user3730408
  • 1
  • 1
0
votes
1 answer

Are relational integrity and referential integrity the same thing?

I found the same definition for referential and relational integrity. Are they the same? I have researched the two terms separately but cannot find any good definitions.
user3627632
  • 19
  • 1
  • 3
1
2