Database Reference
In-Depth Information
An architect is an experienced and skilled designer responsible for sys-
tem and/or data architecture supporting a broad scope of requirements
over time beyond the scope of a single project.
associative en-
tity
An associative entity is an entity that resolves a many-to-many relation-
ship.
Also known as a “data element,” an attribute is a property of importance
to the business. Its values contribute to identifying, describing, or meas-
uring instances of an entity. The attribute
Claim Number
identifies
each claim. The attribute
Student Last Name
describes the last name of
each student. The attribute
Gross Sales Amount
measures the monetary
value of a transaction.
attribute
BASE is short for Basically Available, Soft-state, Eventual consistency.
Basically Available means there is a response to every query, but that re-
sponse could be a response saying there was a failure in getting the data,
or the response that comes back may be in an inconsistent or changing
state. Soft-state means the NoSQL database plays “catch up,” updating
the database continuously even with changes that occurred from earlier
in the day. Eventual consistency means that the system will eventually
become consistent once it stops receiving input.
BASE
A business analyst is an IT or business professional responsible for un-
derstanding the business processes and the information needs of an or-
ganization, for serving as a liaison between IT and business units, and
acting as a facilitator of organizational and cultural change.
business analyst
A candidate key is one or more attributes that uniquely identify an entity
instance.
candidate key
Cardinality defines the number of instances of each entity that can par-
ticipate in a relationship. It is represented by the symbols that appear on
both ends of a relationship line.
cardinality
