{"id":22915,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/bis245-week-3-quiz-may-all-correct"},"modified":"2017-08-03T16:11:35","modified_gmt":"2017-08-03T16:11:35","slug":"bis245-week-3-quiz-may-all-correct","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis245-week-3-quiz-may-all-correct\/","title":{"rendered":"bis245 week 3 quiz may all correct"},"content":{"rendered":"
\n

bis245 week 3 quiz may all correct
Question 1.1. (TCO 2) All of the following are questions to ask in the process of identifying entities EXCEPT: (Points : 4)<\/p>\n

Can you envision more than one instance of the entity?<\/p>\n

Is there a variation over time?<\/p>\n

Is the item to be modeled a person, place, thing, or an event?<\/p>\n

Is the item to be modeled an attribute?<\/p>\n

Question 2.2. (TCO 2) Logical design refers to (Points : 4)<\/p>\n

developing a database model that will support company operations.<\/p>\n

developing a thorough understanding of what needs to be done in developing a database.<\/p>\n

translating the conceptual design into the selected model for use in a database system.<\/p>\n

understanding the business and its functional areas or business processes.<\/p>\n

Question 3.3. (TCO 3) All of the following explain index usage EXCEPT (Points : 4)<\/p>\n

a primary field uses an index.<\/p>\n

adding an index to a table might decrease overall database performance slightly.<\/p>\n

an index can reduce the amount of time it takes for Access to run queries and reports.<\/p>\n

indexes are created using the Index property type.<\/p>\n

Question 4.4.<\/p>\n

(TCO 2) Which of the following is NOT a step in the Database Life Cycle?<\/p>\n

(Points : 4)<\/p>\n

Database Design<\/p>\n

Maintenance and Redevelopment<\/p>\n

Performance<\/p>\n

Testing<\/p>\n

Question 5.5. (TCO 2) A one-to-many relationship is (Points : 4)<\/p>\n

a relationship that guarantees that a record is unique.<\/p>\n

an association between a record and its fields.<\/p>\n

used to describe attributes.<\/p>\n

when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.<\/p>\n

Question 6.6. (TCO 2) An associative table is (Points : 4)<\/p>\n

used to identify primary keys between tables.<\/p>\n

a child of two parent tables that are in a many-to-many relationship.<\/p>\n

an integrity element within a table relationship.<\/p>\n

a tool that allows you to locate an excel file.<\/p>\n

Question 7.7. (TCO 3) Which of the following does NOT describe data redundancy? (Points : 4)<\/p>\n

The same data exists in multiple tables.<\/p>\n

The data is always in linked tables.<\/p>\n

Data updating must be done in multiple table locations.<\/p>\n

Data redundancy can result in data anomalies.<\/p>\n

Question 8.8. (TCO 4) Entity attributes are represented as (Points : 4)<\/p>\n

fields.<\/p>\n

files.<\/p>\n

records.<\/p>\n

tables.<\/p>\n

Question 9.9. (TCO 4) You can reserve space for a field using the (Points : 4)<\/p>\n

PNPI regulations.<\/p>\n

Sarbanes-Oxley Act.<\/p>\n

field size property.<\/p>\n

validation rule.<\/p>\n

Question 10.10. (TCO 4) Which statement does NOT describe the one-to-one relationship? (Points : 4)<\/p>\n

Many matching records exist between several tables.<\/p>\n

Two different tables use the same primary key.<\/p>\n

Exactly one record exists in the first table for each record in the second table.<\/p>\n

It may be used for security reasons to protect data availability.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

bis245 week 3 quiz may all correct Question 1.1. (TCO 2) All of the following are questions to ask in the process of identifying entities EXCEPT: (Points : 4) Can you envision more than one instance of the entity? Is Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-22915","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/22915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=22915"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/22915\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=22915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=22915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=22915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}