UNT BCIS 4610 - Ch.8
Conceptual data model - Answer- a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementaion
Entity-relationship data model (E-R model) - Answer- a detailed, logical representation...
UNT BCIS 4610 - Ch.8
Conceptual data model - Answer- a detailed model that captures the overall structure
of organizational data that is independent of any database management system or
other implementaion
Entity-relationship data model (E-R model) - Answer- a detailed, logical
representation of the entities, associations, and data elements for an organization or
business area
Entity-relationship diagram (E-R diagram) - Answer- a graphical representation of an
E-R model
Entity type - Answer- a collection of entities that share common properties or
characteristics
Entity instance - Answer- a single occurrence of an entity type; also known as an
instance
Attribute - Answer- a named property or characteristic of an entity that is of interest
to the organization
Candidate key - Answer- an attribute (or combination of attributes) that uniquely
identifies each instance of an entity type
Identifier - Answer- a candidate key that has been selected as the unique, identifying
characteristic for an entity type
Multivalued attribute - Answer- an attribute that may take on more than one value for
each entity instance
Repeating group - Answer- a set of two or more multivalued attributes that are
logically related
Required attribute - Answer- an attribute that must have a value for every entity
instance
Optional attribute - Answer- an attribute that may not have a value for every entity
Composite attribute - Answer- an attribute that has meaningful component parts
Derived attribute - Answer- an attribute whose value can be computed from related
attribute values
Relationship - Answer- an association between that instance of one or more entity
types that is of interest to the organization
Degree - Answer- the number of entity types that participates in a relationship
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 Freshy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.49. You're not tied to anything after your purchase.
