Informative Quiz On Database Management.
Settings
At the end of the course you should be able to create relational databases, write SQL statements to extract information to satisfy business-reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. Test how much you understood about Database Management by taking the quiz below.
- 1.What is known as a graphical technique for portraying a data base schema?
- A.
Data modeling
- B.
System Analysis
- C.
Entity- relationship diagram
- D.
DBMS
- 2.An ________ is anything about which the organization wants to collect and store information.
- 3.One of the basic type of Entities that have economic value to the organization is called a ?
- A.
Agents
- B.
Event
- C.
Resource
- D.
Diagram Variation
- 4.One of the basic types of Entities represent the people and organiations that participate in events and about whom information is desired for planning, control, and evaluation purposes.
- A.
Events
- B.
Resources
- C.
Agents
- D.
Attribute
- 5._______ are the various business activities about which management wants to collect information for planning or control purposes.
- 6.Every event entity must be linked to at least
- A.
One resource entity, one other event entity , and at least two participating agents
- B.
One event entity and at least two participating agents
- C.
Two event entities and at least one participating agent
- 7.Accounts receivable would appear in an REA diagram as a example of which kind of entity?
- A.
Resource
- B.
Event
- C.
Agent
- D.
None
- 8.Which of the following is not likely to be depicted as an entity in the REA data model?
- A.
Customers
- B.
Invoices
- C.
Sales
- D.
Delivery trucks
- 9.In most cases, the relationship between agent entities and event entities is
- A.
1:1
- B.
1:N
- C.
M:N
- D.
0:N
- 10.Which of the following most accurately models the sales of low cost, mass produced items by a retail store.
- A.
Sales = 0 to many inventory and inventory equals one to many sales
- B.
Sale= 0 to many inventory and inventory equals 0 to many sales
- C.
Sale= 1 to many inventory and inventory equals 0 to many sales
- D.
Sale = o to many inventory and inventory equals 1 to many sales
- 11.Data modeling occurs during which stages of database design?
- A.
System analysis and physical design
- B.
System analysis and conceptual design
- C.
Conceptual design and implementation and conversion
- D.
Phsical design and implementation and conversion
- 12.Which of the following statements about the REA data model is true
- A.
Every event must be linked to at least 2 agents
- B.
Every resource must be linked to at least two agents
- C.
Every agent must be linked to at least two events
Back to top