University:
California State University, Northridge
Course:
COMP 440 | Database Design
Academic year:

2024
Views:

476

Pages:

12
Author:

Samuel K.

Quiz: Data Models A+ Due Sep 13 at 11:59pm Points 15 Questions 15 Time Limit 20 Minutes Attempt History Attempt Time Score LATEST Attempt 1 14 minutes 9.13 out of 15 Some questions not yet graded Correct answers are hidden. Score for this quiz: 9.13 out of 15 Submitted Sep 12 at 9:25pm This attempt took 14 minutes. Incorrect Question 1 0/1 pts Complete the following statement: Business rules must represent many-to-many (M:N) relationships include constraints Incorrect. Business rules must be rendered in writing and made accessible to the designer as well as end-users. be rendered in writing be based only on end user perceptions Question 2 1/1 pts Which type of databases would Sonnie most likely use when more complex objects with different types of data are required, particularly when data management is incorporated into an object-oriented programming language or when disk indexing is needed to provide persistent storage? object/relational entity-relationship extended-relational object-oriented Correct. Designed to address more specific engineering needs rather than general data management needs, object-oriented databases are useful for application data with complex features. such as geographic information systems (GIS) or computer-aided manufacturing (CAD/CAM). Incorrect Question 12 0/1 pts Comel, a student, takes four classes with her group of best friends. She sits in the front row with two friends and the others sit behind them. What type of relationship would Comel's situation be described as? one-to-many one-to-one many-to-many hierarchical Incorrect. Because a student can take many classes, and each class can accommodate many students, this expression describes a many-to-many (M:N) relationship. Question 13 Not yet graded/1 pts Describe the three parts involved in any SQL-based relational database application. Your Answer: The end user interface the interface allows the end user to interact with the data A collection of tables stored in the database the tables "present" the data to the end user in a way that is easy to understand SQL engine the SQL engine executes all queries or data requests Question 14 1/1 pts In an SQL-based relational database, each table is dependent on every other table. True False Correct With the addition of ad-hoc querying capabilities, relational tables yield structurally independent models of individual data structures. Question 15 1/1 pts A company's business response time is reflective of the database storage and processing. of their Big Data variety volume velocity Correct. Velocity refers to the company's need to process data quickly in order to generate insight. analysis