Primary key’s foreign keys and relationships
Denotes the way that two entities Interconnect
What is a relationship
A programming language that was designed for managing items held in databases
What is SQL
A model that contains table structures, column names, data types, and constraints
what is a physical model
Used to store info and defined with a name and one or more columns.
What is a table
A logical model converted to this after the design of a new database schema is complete
What is a physical model diagram?
This refers to the maximum amount of times an instance in one entity can be associated with instances in another entity.
What is cardinality?
Defined by individual elements of a SQL statement. (SELECT, FROM WHERE,GROUP BY, etc.)
What is a keyword?
Which of the following are problems that result from poor database design? Loss of data integrity, stress, conceptual models, or all the above.
What is loss of data integrity
An object or concept that represents critical data
What is an entity
A relationship becomes this in a physical model
What is a foreign key and constraint?
This is selected by the database designer as a column or set of columns that uniquely identify rows in a table
What is a primary key?
These statements define, structurally change and drop schema objects in the database. Like creating tables for example.
what is DDL
What entities can be derived from the statement: “If a need to buy an item occurs, employees will create a purchase request. One or more purchase orders will be created to serve the purchase request and the purchase order numbers.”
What is purchase request, what is purchase order
Two or more columns that uniquely identify a row
What is a composite key?
This is a datatype that that may require size specification
What is char, graphic, floating point, decimal type, etc?
Consists of two or more columns that when combined uniquely identify a row
What is a compound key?
An element in the SELECT list that will be returned from the query unchanged. For example, “SELECT ‘Fred’ FROM dual;’ would return Fred.
What is a Literal?
An indication of the types of information to be stored and how the information elements interrelate.
What are structural business rules
A meaningful value associated with data stored in a table that cannot be duplicated. It can identify the unique instance using one or more attributes/relationships
What is a UID
A set of legal values that can be assigned to attributes.
What is a domain?
(DAILY DOUBLE!!!) This Indicates how a given relationship can be described from the viewpoint of each end.
What is a perspective?
These specify fixed and floating point numbers
An item that exists in real life while residing in a table column. These are assigned a name and datatype
What is an attribute?
An item that exists in real life while residing in a table column. These are assigned a name and data type
The column data types will be included directly in a UID if it is a _____
What is a physical model diagram?