Structural dependence - answer-A change in any file's structure requires the modification of all programs using that file.
Data dependence - answer-A change in any files data characteristics requires changes of all data access programs
Data redundancy - answer-Same information stored in more ...
INSY 3304 UTA EXAM 1 QUESTIONS
AND ANSWERS 2024
Structural dependence - answer-✔A change in any file's structure requires the
modification of all programs using that file.
Data dependence - answer-✔A change in any files data characteristics requires
changes of all data access programs
Data redundancy - answer-✔Same information stored in more than one place
Problems due to uncontrolled data redundancy - answer-✔Data inconsistency (
lack of data integrity)
Modification Anomalies - answer-✔Inconsistent data due to modifications
Insertion anomalies - answer-✔Inconsistent data due to insertions
Deletion anomalies - answer-✔Inconsistent data due to deletions
Entities - answer-✔An entity is a person,place,event or thing to collect data
Attributes - answer-✔Describes characteristics of an entity
Entity set - answer-✔Group of entities of the same type
INSY 3304 MIDTERM EXAM QUIZZES AND ANSWERS
, INSY 3304 MIDTERM EXAM QUIZZES AND ANSWERS
Table - answer-✔Contains group of related entities
Key - answer-✔Consists of one or more attributes that determine other attributes
within an entity
Composite key - answer-✔Key that is composed of more than one attribute
Super key - answer-✔Attribute or comibination of attributes that uniquely identify
each row in a table
Candidate key - answer-✔Minimal super key, doesn't contain subset of attributes
that is itself a super key
Primary key - answer-✔Candidate key selected to identify an entity
Can't have null values
Enforce entity integrity
Super key as well as candidate key
Secondary key - answer-✔Used for data retrieval purpose
Single attribute or combination of attributes
Maintains indexes on secondary keys
Duplicate values
Foreign key - answer-✔Attribute or combination do attributes in one table whose
values ist either match primary key values or be null
INSY 3304 MIDTERM EXAM QUIZZES AND ANSWERS
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 CleanA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
