Cascade delete - Study guides, Class notes & Summaries

WEST GOVERNORS UNIVERSITY: D426/C175 DATA MANAGEMENT FOUNDATIONS OA EXAM 2024/ 2 LATEST UPDATE EXAMS(VERSION A&B) 400 QUESTIONS AND CORRECT DETAILED ANSWERS WITH RATIONALES /TOP PRIORITY EXAMS GRADED A+ WITH PASS ASSURANCE VERSION A. What does modality refer to? How does it appear on ER diagram? - ANSWER- Refers 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...

Associative Entity - An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - An attribute is a property or characteristic of an entity. Binary relationship - A binary relationship is a relationship between two entity types. Candidate Key - Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Cardinality represents the maximum number of entities that can be i...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary - correct answer Many-to-many Which two examples are attributes? Choose 2 answers A person attending a meeting An employee number A sales meeting A meeting code - correct answer An employee number A meeting code Which delete rule sets column values in a ...

Flat Files a file having no internal hierarchy Hashed Files A file that has been encrypted for security purposes. Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:01 / 0:15 Full screen Heap File An unsorted set of records. Information The transformation of raw data into useful facts. Punch Card A card that is perforated and can hold commands or data. Structured Data Information with a high degree of ...

WGU C175 OBJECTIVE ASSESSMENT PRACTICE TEST ANSWER 1. The Entity-Relationship (E-R) model is _____. a. a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) b. an alternative to indexing and hashing as a means for providing direct access in files c. a diagramming technique that describes entities, their attributes, and the relationships between them d. an alternative to file design in which attributes are used instead of fields e. a diagram...

Data Management Applications Questions and Answers Already Passed A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary Many-to-many Which two examples are attributes? Choose 2 answers A person attending a meeting An employee number A sales meeting A meeting code An employee number A meeting code Which del...

Associative Entity - An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - An attribute is a property or characteristic of an entity. Binary relationship - A binary relationship is a relationship between two entity types. Candidate Key - Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Cardinality represents the maximum number of entities that can be i...

Associative Entity - Answer An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - Answer An attribute is a property or characteristic of an entity. Binary relationship - Answer A binary relationship is a relationship between two entity types. Candidate Key - Answer Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Answer Cardinality repr...

Associative Entity - An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - An attribute is a property or characteristic of an entity. Binary relationship - A binary relationship is a relationship between two entity types. Candidate Key - Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Cardinality represents the maximum number of entities that can be i...

WGU C175 Study Notecards Exam Questions And Answers Flat Files - ANS a file having no internal hierarchy Hashed Files - ANS A file that has been encrypted for security purposes. Heap File - ANS An unsorted set of records. Information - ANS The transformation of raw data into useful facts. Punch Card - ANS A card that is perforated and can hold commands or data. Structured Data - ANS Information with a high degree of organization. Unstructured Data - ANS I...