WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA
EXAM -with 100% verified solutions-2023-2024
VERSION A
What does modality refer to? How does it appear on ER diagram? - ANSWERRefers to the MINIMUM number of times an instance in one entity can be
associated with instance of another entity (minima)
Appears as a 0 or 1 on the relationship line, next to cardinality
Define: Referential Integrity - ANSWER- Requires that ALL foreign key values
must either be fully NULL or match some primary key value
4 Ways Referential Integrity can be violated: - ANSWER- 1. Primary key is
updated
2. Foreign key is updated
3. Row containing primary key is DELETED
4. Row containing foreign key is INSERTED
4 Actions to Correct Referential Integrity Violation: - ANSWER- 1. RESTRICT -
rejects an insert, update, or delete
2. SET NULL - sets invalid foreign keys to null
3. SET DEFAULT - sets invalid foreign keys to a default primary value
4. CASCADE - propagates primary key changes to foreign keys
What is an important aspect to referential integrity? - ANSWER- reference to data
in one relation is based on values in another relation
What are data? - ANSWER- Facts that are collected and stored in a database
What is a determining characteristic of unstructured data? - ANSWER- It does not
follow a data model
What is true about flat files? - ANSWER- - They contain no internal hierarchical
organization
How were data retrieved before database management systems? - ANSWERSequentially from simple files
What is an attribute or group of attributes that uniquely i
Download alle 94 pagina's voor € 25,62
Document in winkelwagenHi, I'm a doctor by profession and my documents are 100% guaranteed to help you Ace in your studies, my goal is to empower and help you in your career. I represent more professional nursing specialties and other courses, that can be of great help for every student. Above all, I'm a friendly person, so don't hesitate to contact me via Knoowy chat. Good luck and success in your studies!!
acct 526 advanced pathophysiology aha pals aorn periop 101 apea 3p ati capstone fundamentals ati comprehensive predictor ati fundamentals proctored ati rn community health proctored ati rn med surg proctored ati rn nutrition proctored az post biology healthcare hesi exit hesi health assessment hesi pn exit hesi rn exit ihuman case study med surg nclex ngn nclex rn nursing urinalysis and body fluids west coast emt block 2
Knoowy is zeker aan te raden. Goedkoop en je krijgt meteen je document!
Uitgebreid aanbod en zeer gebruiksvriendelijk! Al meerdere malen gebruik gemaakt en zoals steeds tevreden.
Prima website waar veel kennis te vinden is. De website heb ik gevonden door te zoeken naar samenvattingen.
Een echte aanrader! Je vindt er heel wat nuttige samenvattingen!
Een goede site voor samenvattingen en leren. Ik kan iedereen aanraden om deze site te gebruiken.
Gemakkelijke website voor samenvattingen te vinden aan een klein prijsje.
Het is de moeite om hier samenvattingen te kopen als je zelf onvoldoende tijd hebt ervoor.
De samenvattingen zijn goed om te gebruiken als je te laat bent met leren of slecht bent in samenvatten.