WGU C175 Data Management – Foundations Final Exam Set (Latest 2023/ 2024 Update) Questions and Verified Answers- Already Grade A| 100% Correct

WGU C175 Data Management – Foundations Final Exam Set (Latest 2023/ 2024 Update) Questions and Verified Answers- Already Grade A| 100% Correct Q: What are the three phases of database design for large complex databases? Answer: analysis logical design physical design Q: What are the alternative names used to describe the Analysis phase? Answer: conceptual design entity-relationship modeling and requirements Q: How are requirements of a DBMS represented? Answer: entities, relationships, and attributes Q: What is an entity? Answer: a person place activity or thing Q: What is a relationship? Answer: a link between entities Q: What is an attribute? Answer: a descriptive property of an entity Q: How are entities relationships and attributes typically depicted in the database analysis phase? Answer: ER Diagram Q: Use Entity, Relationship, and Attribute to describe this following ER diagram. Answer: Q: What is the logical design phase? Answer: implements database requirements in a specific database system Q: In a relational database system how are entities relationships and attributes converted in the logical design phase? Answer: tables, keys, and columns Q: What is a key? Answer: a column used to identify individual rows of a table Q: How is the logical design phase depicted? Answer: in a table diagram Q: Explain the requirements of a table diagram. Answer: Rectangles represent tables. Table names appear at the top of rectangles. Text within rectangles and below table names represents columns. Solid bullets (●) indicate key columns. Empty bullets (○) and arrows indicate columns that refer to keys. Q: What is a database schema? Answer: logical design as specified in SQL and depicted in a table diagram Q: What is the physical design phase? Answer: adds indexed and specified how tables are organized on storage media Q: What SQL statement is specified with physical design? (specific to DBMS) Answer: CREATE INDEX Q: in relational databases how does logical and physical design affect queries? Answer: logical design affects the query result, physical design affects query processing speed. never the result Q: What is data independence? Answer: the principle that that physical design never affects query results Q: What is the purpose of data independence? Answer: allows database designers to turn query performance without changes to application programs; when database designers modify indexes or row order applications run faster or slower but always generate the same results Q: Data Independence allows the _____ to be programmed before the _______ is in place. Answer: relational database application, physical design