Exam (elaborations)
UTA INSY 3304 EXAM 1 WITH VERIFIED DETAILED SOLUTIONS LATEST UPDATE
- Course
- Institution
UTA INSY 3304 EXAM 1 WITH VERIFIED DETAILED SOLUTIONS LATEST UPDATE...
[Show more]
Content preview
UTA INSY 3304 EXAM 1 WITH VERIFIED DETAILEDSOLUTIONS LATEST UPDATE
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 anomaly - ANSWER Data inconsistency due to insertion
Deletion anomaly - ANSWER Data inconsistency due to deletion of data
Entities - ANSWER Entity is anything like person, place, event or things for which data is
collected
Attributes - ANSWER Defines characteristics of an entity
Entity set - ANSWER Set of entities of similar type
, Table - ANSWER Stores group of related entities
Key - ANSWER Consists of one or more attributes that determine other attributes in 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 retrieval purpose
Single attribute or set of attributes
Maintains indexing on secondary keys
Values duplicated
Foreign key - ANSWER Attribute or set of attributes in one table whose values is either
match primary key values or be null
Logically link one table with another
Referential integrity can be implemented
Data dictionary - ANSWER Is a repository of information about the data in the database.
Metadata
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 Stetson. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
62890 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now