Homework answers / question archive / Your Name: INSTRUCTIONS: Answer the question that follow by selecting the letter (a,b,c,d,e, T,F) that best indicates the correct answer to the question

Your Name: INSTRUCTIONS: Answer the question that follow by selecting the letter (a,b,c,d,e, T,F) that best indicates the correct answer to the question

Business

Share With

Your Name: INSTRUCTIONS: Answer the question that follow by selecting the letter (a,b,c,d,e, T,F) that best indicates the correct answer to the question. Record your answers in the yellow shaded spaces provided next to each question; the first question is done for you. You may respond in upper or lower case. 1. T/F: An employee’s last name is an example of an attribute. 2. T/F: The term projecting refers to data manipulation that eliminates columns in a table. 3. T/F: The term selecting refers to data manipulation that eliminates columns in a table. 4. T/F: Both SQL and QBE are used to create database queries. 5. T/F: MS Access has an SQL interface, i.e. you can use SQL in MS Access. 6. T/F: The phrase data governance refers to rules for sharing data among partners in a supply chain. 7. T/F: In general, processing is faster when using an indexed file as opposed to using a sorted file (for example – to print a form letter in sorted order by zip code). 8. The set of values that are valid for a certain field of a data record (e.g. gender) are referred to as the field’s: a. Domain 9. b. Mask d. Schema e. Cardinality The relationship BANNER ID OF is best described as: a. relational 10. c. Caption b. E/R c. one to one d. one to many e. many to many Suppose that, in a video rental store, each DVD has a bar code on it. Further, suppose the bar code on each DVD is different from the bar code on every other DVD. The relationship identified by, as in: DVD identified by BARCODE, is best described as: a. relational 11. b. E/R c. one to one d. one to many e. many to many Suppose that, in a video store, each DVD has a title (e.g. Batman Returns). Further, suppose the title on each DVD is the same as the title on several other DVDs in the store (there are multiple copies of the movie). The relationship is title of, as in: Title is title of DVD, is best described as: a. relational 12. b. E/R c. one to one d. one to many e. many to many The information contained in a database, describing the format and use of every data item in the data base, is called the: a. Physical view b. Logical Construct c. Schema d. Subschema e. Domain 1 13. T/F: One of the benefits that a DBMS offers over a conventional file processing system is reduced redundancy of data items. 14. T/F: One of the benefits that a conventional file processing system has over a DBMS approach is that files can be designed to optimize processing for a particular application, e.g. Inventory. 15. T/F: The person in charge of maintaining and enforcing the data dictionary is the database administrator. 16. T/F: The columns of a relational database table are referred to as records. 17. T/F: The phrase Data Rot refers to the obsolete nature of old data 18. Which of the following is not an aggregate function in Access?: a. Count 19. b. Subtract c. Maximum d. Average e. Sum The information contained in a database, describing the format and use of every data item in the data base, is called the: a. Physical view b. Logical Construct c. Domain d. Schema 20. T/F: The Data Definition Language (DDL) component of a DBMS would be used, for example, to define last name to be of type “text” and 30 characters long. 21. T/F: SQL is one example of a Data Manipulation Language (DML). 22. T/F: Relational databases are an older approach to managing data and are rarely used anymore for business applications. 23. T/F: NoSQL databases are created by a process referred to as extract, transform, and load. 24. T/F: A data warehouse aggregates large amounts of data from a single source. 25. T/F: A data mart is a subset of the data warehouse. 26. T/F: According to your book, data-mining tools are used to look for patterns of information in a data warehouse. 27. T/F: According to your book, managing Big Data has now become possible with the introduction of large relational enterprise database management systems such as Oracle. 28. T/F: According to your book, three importance characteristics of Big Data are Volume, Velocity, and Variety. 29. T/F: An enterprise data hub is also referred to as a data lake. 2 30. Which of the following is the correct sequence for setting up a new database? a. Define Relationships>Define Attributes > Define Entities b. Define Entities>Define Attributes > Define Characteristics c. Define Characteristics > Define Relationships > Define Entities d. Define Entities > Define Relationships > Define Characteristics 31. Which of the following is a process used to ensure the correct design of a database? a. Enforcing referential integrity b. Establishing cardinality bounds c. Adding validation rule d. Normalization 32. T/R: An E/R diagram utilizes 8 Symbols 33. T/R: In an E/R diagram, a diamond shape is used to represent an entity 34. T/R: An E/R diagram is a representation of an organization’s process model 35. T/R: In an E/R diagram, a circle inside of a circle is used to represent Many to Many relationships. 36. T/R: Relational databases are used primarily because they are faster than hierarchical databases. 37. T/R: Relational databases are E/R databases; network databases are not. 38. T/R: A Mask is used to enter default values into a database table. 39. The field, or combination of fields, that uniquely identifies a specific record is called a: a. Schema b. Data dictionary c. Subschema d. Key 3 40. Which of the following would not be considered to be an entity? a. Person b. Foreign Key c. Event d. Place 41. Which of the following is not a source of unstructured data? a. Social media b. E-mail c. Sales Transaction d. Surveillance video 42. The software Hadoop is associated with: a. Database Administration b. The Hierarchical Database Model c. Data Scrubbing d. Big Data 4