Exam (elaborations) INF2603 INF2603 - Full 2021 Exam pack
10 views 0 purchase
Course
INF2603
Institution
Arizona State University - Tempe
INF2603 - Full 2021 Exam pack03 – Semester 1 – 2014 – Glossary of terms used in exam papers from 2012 to 2013
Attribute
A characteristic of an entity or object.
Column Constraint
In this type the constraint is checked when the value of the column changed.
Composite key
A multiple-attrib...
exam elaborations inf2603 inf2603 full 2021 exam pack
Written for
Arizona State University - Tempe
INF2603
All documents for this subject (1)
Seller
Follow
GRADUATEnurse
Reviews received
Content preview
INF2603 – Semester 1 – 2014 – Glossary of terms used in exam papers from 2012 to 2013
Attribute
A characteristic of an entity or object.
Column Constraint
In this type the constraint is checked when the value of the column changed.
Composite key
A multiple-attribute key.
Database
A shared, integrated computer structure that houses a collection of related data.
Data Definition Language (DDL)
The language that allows a database administrator to define the database structure,
schema, and
subschema.
Data dictionary
A DBMS component that stores metadata—data about data.
Data Manipulation Language (DML)
m
er as
The set of commands that allows an end user to manipulate the data in the database. The
co
commands include SELECT, INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK.
eH w
Derived attribute
o.
An attribute that does not physically exist within the entity and is derived via an algorithm.
rs e
ou urc
Entity subtype
In a generalization/specialization hierarchy, a subset of an entity supertype.
o
Entity supertype
aC s
In a generalization/specialization hierarchy, a generic entity type that contains the common
v i y re
characteristics of entity subtypes.
Existence-dependent
A property of an entity whose existence depends on one or more other entities.
ed d
Existence-independent
ar stu
A property of an entity that can exist apart from one or more related entities.
External model
sh is
The application programmer's view of the data environment.
Th
Fan trap
A design trap that occurs when one entity is in two 1:M relationships with other entities,
thus
producing an association among the other entities that is not expressed in the model.
First Normal Form (1NF)
The first stage in the normalization process. It describes a relation depicted in tabular
format, with no repeating groups and a primary key identified. All nonkey attributes in the
relation are dependent on the primary key.
Functional dependence
Within a relation R, an attribute B is functionally dependent on an attribute A if and only if a
given
value of attribute A determines exactly one value of attribute B. The relationship “B is
dependent
This study source was downloaded by 100000828872084 from CourseHero.com on 09-02-2021 11:47:36 GMT -05:00
Page 1 of 4
https://www.coursehero.com/file/9840337/INF2603-Terms-Summary-from-Past-Exam-Papers/
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 GRADUATEnurse. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $3.87. You're not tied to anything after your purchase.
