UIDs
This UID is most commonly used to uniquely identify rows in a table.
What is a Primary UID?
The value that determines whether there are one or many relations in a relationship.
What is cardinality?
A series of relationships that reflect entities organized into successive levels.
What is a hierarchical relationship?
The data type of employee address is.
What is the VARCHAR?
This SQL command is used to create a table in the database, it is a DDL statement.
What is create table?
This UID is created expressly for identification purposes. An example would be a driver’s license number.
What is an Artificial UID?
This type of relationship shares a UID or key with the entity it is related to. This is most commonly found with intersection entities.
What is a barred relationship?
This relationship occurs when an entity shares a relationship with itself.
What is a recursive relationship?
This is the prelude to a physical model.
What is the Conceptual and Logical model?
This class of SQL statements is used to manipulate data within the tables.
What is DML?
This UID is used when an entity has a primary key which is also a foreign key.
What is a Composed Attribute UID?
This type of relationship is a relationship that an entity has with itself.
What is a recursive relationship?
This cardinality is hierarchical when viewed from the primary entity.
What is One to Many?
This is what relationships will turn into when the data is turned into a physical model.
What is the Foreign Key column and constraint?
This query is used in both DML and DQL, and is used to specify certain values or columns that are updated or selected
What is the WHERE clause?
When an entity contains more than one candidate UID, any UID’s that are not selected as the primary UID are considered this UID.
What is a Secondary UID?
This type of relationship makes it so the instance that the relationship originates from cannot be moved to a new instance of the relationship it is going to
What is a non-transferable relationship?
In entity relationship diagrams, this is used to represent an exclusive relationship.
What is an arc relationship?
This is the definition of a Candidate UIDs.
What is an attribute or combination that could identify the row of data uniquely?
This type of JOIN statement joins every row of both tables and does not need a condition. It is also known as a cartesian product.
What is a CROSS JOIN?
This UID is used when an entity uses its foreign keys as primary keys from an entity with composed UID attributes.
What is a Composed Cascade Attribute UID?
The required optionality of an arc relationship
What is optional to the main entity and mandatory to the subtype entities?
These are the two rules for creative subtype/supertype relationships.
What is exhaustive and mutually exclusive?
The three different ways subtypes and supertypes are mapped in a physical model.
What are Single tables, Multi tables, and Arcs?
Daily Double!!!!
This statement is a TCL command that is used to help navigate through different operations. If there is a change that we do not want to be committed, we can rollback to one of these we created.
What is a SAVEPOINT command?