INSY 3304 - Chapter 3 Terms and
Definitions
Entity - Answer-is a person, place, event, or thing for which we intend to collect 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 ...
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
Page 2/5
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 EmillyCharlotte. 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.
