1.Which would NOT likely be an entity on a car insurance ERD? a.Customer b.Polic
ID: 3683557 • 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.Ahmed 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.Reliability
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
Part-II – True or False Questions
[10 Questions – Each question carry 1 mark]
Question
True/False
1
An entity is the basic building block for a data model.
2
Data flows should always begin or end at a process.
3
The three steps in creating an ERD are: (1) identify the entities; (2) identify the processes; (3) identify the relationships.
4
ERD’s are drawn in several levels: Context ERD diagrams; Level 0 ERD diagrams; Level 1 ERD diagrams.
5
Data models can be either logical or physical.
6
Ideally, a data flow diagram should not have more than about twelve processes.
7
In an entity called STUDENT, you might find attributes of Student-ID, Last-Name, First-Name and cell-phone.
8
A Level-0 Diagram is data flow diagram that is the result of nested decompositions of a series of sub processes from a process.
9
The major inputs and major outputs listed on the use case provide a list of the sources and destinations of the inflows and outflows on the processes on a data flow diagram.
10
The decision to make, to buy, or to outsource influences the design tasks that are performed throughout the rest of the design phase.
Part-III – Short & Long Questions
[4 Questions – 25 points]
1.Jeff is an analyst. The human resources department is very unhappy with their payroll package. They want the information systems department to write them a new package as they think they have unique needs that can’t be meet with a packaged solution. What should Jeff do? [5 points]
2.Create an Entity Relationship diagram that captures this information about the UPS system. [5 points]
UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the heart of the UPS product tracking information system. Shipped items can be characterized by item number, weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the UPS system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard UPS transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute.
3.Discuss what should be done to ensure that the entity relationship diagrams balance with the data flow diagrams. What is the consequence of failing to balance these models? [5 points]
4.In parts (a) and (b) of this question you are asked to draw context and level-0 data flow diagrams for the case described below of a withdrawal of cash from an Automatic Teller Machine (ATM). The user starts the operation by inserting a card in the slot and the PIN number. The ATM checks the card by reading its information, expiry date, and then accepts the input of the PIN from user. The card is verified by sending both of the card number and the PIN to the bank, and hence the bank either sends confirmation or refusal. If the card is expired or invalid, or if wrong PIN is entered three times, the card is returned and the transaction is cancelled. When the confirmation is received from the bank for the validity of card and PIN, the user should enter his transaction type "withdrawal of cash", and then enters the amount. The system checks that the entered amount is below or equal to the daily limit of withdrawals of 5000 SR. If the entered transaction amount is valid, the card is returned, the money is dispensed and the withdrawal receipt is printed, otherwise the card is returned and the transaction is cancelled.
a) Draw a context data flow diagram for the ATM cash withdrawal system. [5 points]
b) Draw a level-0 data flow diagram for the ATM cash withdrawal system. [5 points]
Question
True/False
1
An entity is the basic building block for a data model.
2
Data flows should always begin or end at a process.
3
The three steps in creating an ERD are: (1) identify the entities; (2) identify the processes; (3) identify the relationships.
4
ERD’s are drawn in several levels: Context ERD diagrams; Level 0 ERD diagrams; Level 1 ERD diagrams.
5
Data models can be either logical or physical.
6
Ideally, a data flow diagram should not have more than about twelve processes.
7
In an entity called STUDENT, you might find attributes of Student-ID, Last-Name, First-Name and cell-phone.
8
A Level-0 Diagram is data flow diagram that is the result of nested decompositions of a series of sub processes from a process.
9
The major inputs and major outputs listed on the use case provide a list of the sources and destinations of the inflows and outflows on the processes on a data flow diagram.
10
The decision to make, to buy, or to outsource influences the design tasks that are performed throughout the rest of the design phase.
Explanation / Answer
Solutions for part 1
1.d) zipcode Reason:It is an attribute
2.d)All the above
3 d) Entity, Attributes and relationships
4 a) process
5 d) Level-2 diagram reason:More detailed one
6 c) External entity reason:Because he is human and human is in external entity character
7 e) Process relationship reason:Because order food is an activity which is happening here
8)
9) c) Decomposition
10) b) Relationships among the data
11) a) 0 normal form to first normal form (1nf) reason:We must not have repeated values in 1NF
12) d) A and B i.e Client computer and Servers
13) e) All the above
14)
15) Country managers can define custom fields ex:Any languages based on their countries etc
solutions for part 2
1)True
2)False
3)True
4)True
5)True
6)False
7)True
8)False
9)
10)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.