CIS 505 Week 1 2024 Update Comprehensive Questions with Correct Answers Accuracy 100%
CIS 505 Week 1 2024 Update Comprehensive Questions with Correct Answers Accuracy 100% Analytical Data Store - Answer Stores historical transactional and summary data Analytical Data Store Purpose - Answer Extract, Transform, Load Analytical Database Use What Paradigm - Answer Dimensional Paradigm attribute - Answer A characteristic of an entity or relationship ( first name, order number) Attribute - Composite - Answer Broken into smaller parts (name, address) Attribute - Simple - Answer Cannot be broken into smaller parts Attribute - Single Value - Answer Only one value, birthday, gender attribute- multivalued - Answer More than one possible value (phone number, cars, siblings) Cardinality - Answer expresses the specific number of instances in an entity Conceptional Data Model - Answer Study and model the data in a tech independent manner Database - Answer A collection of interrelated data items that are managed as a single unit. Database - Answer organized collection of logically related data Database Design Layers - Answer Conceptual - study and model data in a tech independent manner (create ER diagram)
Document information
- Uploaded on
- July 31, 2024
- Number of pages
- 13
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers