1-Which would NOT likely be an entity on a car insurance ERD? a. Customer b. Pol
ID: 3684709 • Letter: 1
Question
1-Which would NOT likely be an entity on a car insurance ERD?
a. Customer
b. Policy
c. Agent
d. Zip code
e. Car
----------------
2- A data flow diagram:
a. Depicts the flow of data through a system
b. Uses rounded rectangles to represent processes
c. Depicts the processing performed by the system
d. All of the above
e. None of the above
--------------------
3-The three major parts of an ERD diagram are:
a. Process, data flow, data store
b. Attribute, modularity, cardinality
c. Relationship, data flow, entity
d. Relationship, attribute, entity
e. Process, entity and relationship
-------------------------------------------
4-When changing the use case into data flow diagram, on the Level 1 data flow diagram each use case step would be the same as a:
a. process
b. data flow
c. data store
d. external entity
e. internal entity
------------------------------------
5-Which of the following diagrams show all the major processes, external entities and major data stores?
a. Context diagram
b. Level-0 diagram
c. Level-1 diagram
d. Level-2 diagram
e. Decision Tree
----------------------
6- A student contacts the librarian to borrow a book. On a data flow diagram, the student would be represented by a:
a. data flow
b. process
c. external entity
d. data store
e. trigger
----------------------
7- Bob has a data flow diagram with an item called ‘Order Food’, the item here would be a:
a. data flow
b. data store
c. process
d. external entity
e. process relationship
---------------------------
8- A logical data model that does not lead to repeating fields and that the data models leads to tables containing fields that are dependent on the whole identifier is in _____ normal form.
a. balanced
b. first
c. primary
d. second
e. third
-------------------
9- The act of going from a single system to several component processes refers to:
a. Structuring
b. Balancing
c. Decomposition
d. Formatting
e. None of the above
----------------------------------
10- Lines on an ERD diagram indicate:
a. Hierarchies between processes
b. Relationships among the data
c. Plurality of data items
d. Uniqueness of data items
e. Primary keys.
-----------------------
11- When normalizing data models, if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from:
a. 0 normal form to 1st normal form (1NF)
b. 1st normal form (1NF) to 2nd normal form (2NF)
c. 2nd normal form (2NF) to 3rd normal form (3NF)
d. Generalized normal form (GNF) to fully normalized form (FNF)
e. Dependent normal form (DNF) to Independent normal form (INF)
----------------------------
12- The primary hardware components of a system consist of:
a. Client Computers
b. Servers
c. Network
d. A and B
e. A, B and C
------------------------
13- Client-based architectures are where the:
a. Client computer is responsible for presentation logic
b. Client computer is responsible for application logic
c. Client computer is responsible for data access logic
d. The server stores the data
e. All of the above
-------------------------------------
14- Which of the following is an advantage of client-server architectures?
a. They are scalable
b. They can support different types of systems
c. It is easy to separate different logic functions
d. Reliabilitye.
e. All of the above
--------------------------
15- An example of a multilingual requirement is:
a. The system will operate in English, French and Spanish
b. Country managers can define custom fields
c. All date fields will be presented in a uniform format
d. Personal information about English customers cannot be sent to Chinese systems
e. Country managers are able to change telephone number formats
Explanation / Answer
1. (d) Zipcode
2. (d) all of the above
3. (d) relationship,attribute, entity
4. (a) process
5. (b) Level-0 diagram
6. (c) External entity
7. (c) process
8. (d) second
9. (c) decomposition
10. (b) relationships among the data
11. (a) 0 normal form to first normal form (1 NF)
12. (d) A and B
13. (c) Client computer is responsible for data access logic
14. (a) They are scalable
15. (a) The system will operate in English, French and Spanish
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.