Introduction to Relational Databases CS1011 (SOPH-0047) Sophia Milestone 1 UNIT 1 Sophia-Introduction to Relational Database (Western Governors University)

What happens if we run the following command in MySQL? UPDATE product SET sale_price = price --5; The product table has all of the sale_price set to the same value as the price. The sale_price in the product table fo ...

What happens if we run the following command in MySQL? UPDATE product SET sale_price = price --5; The product table has all of the sale_price set to the same value as the price. The sale_price in the product table for all records are decremented by 5 from the price. An error is thrown due to the --. The sale_price in the product table for all records are incremented by 5 from the price. CONCEPT Using MySQL and MariaDB 2 Which of the following is a key feature of a relational database? It has high scalability and performance that can enable almost unlimited growth. It's integrated well into an application infrastructure within a database stack. It's designed for highly available systems that should provide a consistent, high-quality experience for all users globally. It has a broad umbrella of a variety of approaches with data storage and manipulation. CONCEPT Non-relational Databases 3 What notation and relationship does this refer to? UML's notation showing a 1:1 relationship UML's notation showing a 1:M relationship Chen's notation showing a 1:1 relationship Crow's notation showing a 1:1 relationship CONCEPT Entity Relationship Model 4 Identify the component that that is unrelated to hardware that could create query processing bottlenecks and affect database performance. Hard disk Application code RAM CPU CONCEPT Query Processing Bottlenecks 5 What is the term related to a specific implementation of ANSI SQL by a vendor? Version Implementation T-SQL Dialect CONCEPT Using ANSI SQL 6 Which of the following is a key part of logical design in an entity relationship model? This model does not depend on the database management software or the hardware used to implement the model. This model converts attributes into columns. This data model includes all table structures including column names, data types, column constraints, primary keys, foreign keys, and relationships. This model resolves the many-to-many relationships to multiple one-to-many relationships. CONCEPT Logical Design 7 Which of the following criteria was a key milestone for the object relational model created in the mid- 1980s? Being able to hide the complexities of the model from the user through the use of the database management system. Having very large storage in petabytes. The collection of similar structures that consisted of shared attributes and behaviors. Having support for unstructured data. CONCEPT Object and Relational Models 8 Which of these databases is limited in terms of database size? PostgreSQL Teradata Oracle MySQL CONCEPT Storage Limitations 9 Which data model(s) introduced the use of a data definition language? Network Hierarchical Both hierarchical and network Neither CONCEPT Hierarchical and Network Data Models 10 Which of the following is a key part of conceptual design in an entity relationship model? In this model, no attributes are specified. This model converts entities into tables. In this model, all table structures including column names, data types, column constraints, primary keys, foreign keys, and relationships are included. This model has normalization that occurs. CONCEPT Conceptual Design 11 Which of the following types of outer joins are implemented in SQLite? LEFT OUTER JOIN RIGHT OUTER JOIN 1/1/22, 3:33 AM Sophia :: Welcome FULL OUTER JOIN All the above CONCEPT Using SQLite 12 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ In the context of a database, what is knowledge? A body of information and facts about a specific topic A computer structure that holds a collection of related data Raw facts of interest to the end user CONCEPT Database Purpose 13 Which of the following is not a reason to identify and document business rules? 1/1/22, 3:33 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141876 8/13 It can be used as a communication tool between users and designers. It can allow the designer to understand business processes. It can allow developers to create an accurate data model. It can ensure that the rules are based on the interpretation of senior management. CONCEPT Considering Business Rules 14 Which of the following is a key feature of a data warehouse? This type of database is optimized to execute a small number of complex queries. This type of database focuses on reducing data redundancy. This type of database is used to process day-to-day operations in real-time. This type of database is optimized for a large number of concurrent users making changes or querying the database. CONCEPT Data Warehouse vs. Transactional Databases 15 Which of the following is a key part of physical design in an entity relationship model? This model converts attributes into columns. This model does not depend on the database management software or the hardware used to implement the model. This model resolves the many-to-many relationships to multiple one-to-many relationships. This model avoids any database model-specific details. CONCEPT Physical Design 16 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ __________ is/are the instructions and rules that determine the design and use of the database. Procedures Software People Hardware CONCEPT Parts of a Database System 17 Which of the following represents a security issue related to database migrations? Having databases in different departments Having the physical drives get damaged during migration Having data be read from a third party during the transfer Having databases in different geographies CONCEPT Migrating Databases in an Organization 18 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ What is the best example of a scenario in which a new database should be created to support the business? An organization would like to add pet services as an option to their existing pet store sales database. Services and products should be able to be paid for at the same time. A local pet shop would like to offer pet services. They have six pet groomers on staff and use MS Outlook to help with tracking their appointments. The pet owner takes in calls from customers and then schedules them on the company computer through Outlook. An organization has found an application that can be used to manage pet services for pet owners and pet groomers. Both have to log into the existing site to set up appointments. An organization would like to create an application to help manage appointments for pet-related services. The mobile application should allow pet owners to schedule services by viewing the availability of pet groomers within the app. CONCEPT Databases in the Real World 19 Which of the following is not a common commercial database option? SQLite Teradata Oracle MySQL CONCEPT Commercial Databases 20 Which of the following criteria was a key milestone for the relational model created in the mid-1970s? The collection of similar structures that consisted of shared attributes and behaviors. Having very large storage in petabytes. Having support for unstructured data. Being able to hide the complexities of the model from the user through the use of the database management system. CONCEPT Relational Models 21 Which data model do databases like Oracle, MS SQL Server, Postgres, and MySQL fall under? Hierarchical and network Object-oriented 1/1/22, 3:33 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141876 13/13 Relational XML Hybrid CONCEPT Data Model Innovations 22 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ As compared to databases, file sizes in flat files can be much larger due to __________. redundancy security flexibility data integrity CONCEPT Databases vs. Flat Files