Exam (elaborations)
INSY 3304 - Chapter 3 Terms
- Course
- Institution
INSY 3304 - Chapter 3 Terms...
[Show more]
Content preview
Entity - ANSWER is a person, place, event, or thing for which we intend tocollect data
Attribute - ANSWER describes a characteristic of an entity
Entity Set - ANSWER a group of entities of the same type
Table - ANSWER (relation) contains a group of related entities
Predicate Logic - ANSWER used extensively in mathematics to provide a
framework in which an assertion (statement of fact) can be verified as either
true or false
Set Theory - ANSWER a part of mathematical science that deals with sets, or
groups of things, and is used as the basis for data manipulation in the relational
model
Tuple - ANSWER in the relational model, a table row
Attribute Domain - ANSWER in data modelling, the construct used to organize
and describe an attribute's set of possible value
Atomic - ANSWER each row/column intersection represents a single data value
Cardinality - ANSWER the number of tuples in a table
Degree - ANSWER the number of columns
Primary Key (PK) - ANSWER an identifier composed of one or more attributes
that uniquely identifies a row
Key - ANSWER is a attribute that determines the values of other attributes
within an entity
Functional Dependence - ANSWER that the value of one or more attributes
determines the value of one or ore other attributes (A->B)
, Determinations - ANSWER is the state in which knowing the value of one
attribute make it possible to determine the value of another (B:A ->B)
Determinant - ANSWER (key) a attribute whose value is determines another
Dependent - ANSWER the attribute whose value is determined by the other
attribute
Full Functional Dependence - ANSWER is used to refer to functional
dependencies in which the entire collection of attributes in the determinant is
necessary for e relationship
Composite Key - ANSWER a multiple attribute key, key that composed of
more than one attribute
Key Attribute - ANSWER an attribute that is part of a key
Superkey - ANSWER is a key that can uniquely identify any row in the table
Candidate Key - ANSWER a key that does not contain a subset of attributes that
is itself a superkey
Entity Integrity - ANSWER guarantees that each entity is uniquely identified by
non-null primary key value
Null - ANSWER the absence of an attribute value. Note that null is not a blank
Foreign Key (FK) - ANSWER a attribute or attributes in one table whose value
must match the primary key in another tables or whose value must be null
Referential Integrity - ANSWER the condition in which every reference to an
entity instance by another entity instance is valid. A dependence table's foreign
key must have either a null entry or match entry in the related table.
Secondary Key - ANSWER as a key that is used strictly for data retrieval
purpose
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Boostertips. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now