CIS 505 Week 1|Complete Questions with 100% Correct Answers

CIS 505 Week 1|Complete Questions with 100% Correct Answers OLTP Online Transaction Processing OLAP online analytical processing transactional database A database designed to keep track of the day-to-day transactions of an organization. Analytical Data Store Stores historical transactional and summary data relational database Most common structure for database. *Distinguished by multiple tables with interrelated fields. *When queried, data can be pulled form any # of relations that may be contained in multiple databases. *Provides lots of flexibility. Analytical Data Store Purpose Extract, Transform, Load Analytical Database Use What Paradigm Dimensional Paradigm Database organized collection of logically related data Database Management System (DBMS) The collection of programs that manages the database structure and controls access to the data stored in the database. Three-Level Architecture standard database structure consisting of physical database, conceptual, external Database Design Layers Conceptual - study and model data in a tech independent manner (create ER diagram) L Conceptional Data Model Study and model the data in a tech independent manner Logical Database Design To translate the conceptual representation to the logical structure of the database, which includes designing the relations (relational databases schema) Physical Data Model Map logical design to actual DBMS ERD Entity Relationship Diagram entity A unique identifiable thing (person, order) Relationship Describe how two entities relate to one another (makes) attribute A characteristic of an entity or relationship ( first name, order number) Primary Key A field (or group of fields) that uniquely identifies a given entity in a table Attribute - Simple Cannot be broken into smaller parts Attribute - Composite Broken into smaller parts (name, address) Attribute - Single Value Only one value, birthday, gender attribute- multivalued More than one possible value (phone number, cars, siblings) type of relationship database One to one 1:1, one to many 1:N, many to many M:N Cardinality expresses the specific number of instances in an entity