• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 5 pages
Other

Is 410 Test 1 Verified Study Guide

Document preview thumbnail
Preview 2 out of 5 pages

IS 410 TEST 1 VERIFIED STUDY GUIDE

Content preview

IS 410 TEST 1 VERIFIED STUDY GUIDE

Database - Answers - organized collection of logically related data

Data - Answers - stored representations of meaningful objects and events
Structured: numbers, text, dates
Unstructured: images, video, documents

Information - Answers - data processed to increase knowledge in the person using the
data

Metadata - Answers - Data that describes the properties (name, type, length,
description, source) and context of user data. Stored in structured or unstructured data.
For example, Class Roster: Name (Type/Length/Min/Max/Description/Source), ID
(Type/Length/Min/Max/Description/Source), Major
(Type/Length/Min/Max/Description/Source), GPA.

Entities (E-R)/Relationships/Relational Databases - Answers - Entities: Noun form
describing a person, place, object, event, or concept (Ex. UMBC: Student, courses,
teachers, classes). Composed of attributes.
Should be an object that has many instances and multiple attributes.
Relationships: Between entities; Usually one-to-many (1:M) or many-to-many (M:N)
Relational Databases: Database technology involving tables (relations) representing
entities and primary/foreign keys representing relationships.

*Data Driven vs. Process Driven Design - Answers - Data Driven is much more flexible,
adaptable and less expensive to maintain.

Business Rules - Answers - Are statements that define or constrain some aspect of the
business
Are derived from policies, procedures, events, functions
Assert business structure
Control/influence business behavior
Are expressed in terms familiar to end users
Are automated through DBMS software

A Good Business Rule is: - Answers - Declarative-what, not how
Precise-clear, agreed-upon meaning
Atomic-one statement
Consistent-internally and externally
Expressible-structured, natural language
Distinct-non-redundant
Business-oriented-understood by business people

A Good Data Name is - Answers - Related to business, not technical, characteristics

, Meaningful and self-documenting
Unique
Readable
Composed of words from an approved list
Repeatable
Written in standard syntax

E-R Model Constructs - Answers - Entities:
Entity instance-person, place, object, event, concept (often corresponds to a row in a
table)
Entity Type-collection of entities (often corresponds to a table)
SHOULD BE:
An object that has many instances, and multiple attributes.

SHOULD NO1T BE:
A user of the database system
An output of the database system (e.g., a report)
Relationships:
Relationship instance-link between entities (corresponds to primary key-foreign key
equivalencies in related tables)
Relationship type-category of relationship...link between entity types
Attribute-property or characteristic of an entity or relationship type (often corresponds to
a field in a table)

Attributes - Answers - Attribute-property or characteristic of an entity or relationship type
Classifications of attributes:
*Required* versus Optional
Simple versus (Composite) Attribute
Single-Valued versus {Multivalued Attribute}
Stored versus [Derived] Attributes
Identifier Attributes

Identifiers (Keys): - Answers - Identifier (Key)-an attribute (or combination of attributes)
that uniquely identifies individual instances of an entity type
Simple versus Composite Identifier
Candidate Identifier-an attribute that could be a key...satisfies the requirements for
being an identifier
Choose Identifiers that
Will not change in value
Will not be null
Avoid intelligent identifiers (e.g., containing locations or people that might change)
Substitute new, simple keys for long, composite keys

Relationships can have attributes - Answers - These describe features pertaining to the
association between the entities in the relationship

Document information

Uploaded on
September 3, 2026
Number of pages
5
Written in
2026/2027
Type
Other
Person
Unknown
$12.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
GEEKA
3.8
(379)
Sold
2239
Followers
1451
Items
63760
Last sold
3 days ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions