University:
College
Course:
College Systems Analysis
Academic year:

2023
Views:

149

Pages:

14
Author:

Leilani Contreras

True/False 1. Web-based designs are dependent on a specific combination of hardware and software. a. True b. False ANSWER: RATIONALE: False Web-based designs are not tied to any specific combination of hardware and software.. 2. A web-based data design requires users to have powerful workstations. 三 a. True b. False ANSWER: False RATIONALE: Web-based systems do not require powerful workstations, 3. Migrating a traditional database design to the web can require design modification, additional software, and some added expense. a. True b. False ANSWER: RATIONALE: True Migrating a traditional database design to the web can require design modification, additional software, and some added expense. 4. Web-based systems are popular because they offer ease of access, cost-effectiveness, and worldwide connectivity. a. True b. False ANSWER: RATIONALE: True Web-based systems are popular because they offer case of access, cost-effectiveness, and worldwide connectivity. 5. In a table or file, each column represents a record and each row represents a field.. a. True b. False ANSWER: RATIONALE: False In a table or file, each column represents a field, or characteristic of the entity, and each row represents a record, which is an individual instance, or occurrence of the entity, 24. An M:N relationship is different from 1:1 or 1:M relationships because the event or transaction that links the two entities is actually a third entity, called an associative entity, that has its own characteristics. a. True b. False ANSWER: RATIONALE: True An M:N relationship is different from 1:1 or 1:M relationships because the event or transaction that links the two entities is actually a third entity, called an associative entity, that has its own characteristics. 25. Encryption is the process of creating table designs by assigning specific fields or attributes to each table in the database. a. True b. False ANSWER: RATIONALE: False Normalization is the process of creating table designs by assigning specific fields or attributes to each table in the database.26. A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs. a. True b. False ANSWER: RATIONALE: True A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs. 27. A schema is a set of letters or numbers that represents a data item. a. True b. False ANSWER: False RATIONALE: A code is a set of letters or numbers that represents a data item. 28. College course numbers usually are assigned using a block sequence code. a. True b. False ANSWER: True RATIONALE: College course numbers usually are assigned using a block sequence code. 29. Mainframe storage refers to data that a user can view, understand, and access, regardless of how or where that information actually is organized or stored. a. True b. False ANSWER: RATIONALE: False Logical storage refers to data that a user can view, understand, and access, regardless of how or where that information actually is organized or stored. 30. A logical record is a set of field values that describes a single person, place, thing, or event. a. True