MartinACC 305

Databases – Lecture notes:

  1. In a file-oriented processing system an organization would likely need to enter a customer’s address change in more than one data file.

  1. True
  2. False

2.In a well-structured data-oriented processing system an organization would likely need to enter a customer’s address change in more than one data file.

  1. True
  2. False

3.There is no data duplication in a relational database environment.

  1. True
  2. False

4.There is no data duplication in a file-oriented processing environment.

  1. True
  2. False

5.A database management system (DBMS) is the resource available to define and manage data structures in an information system.

  1. True
  2. False

6.Hierarchical structures overcome many of the limitations of the network structure; for example the hierarchical structure eliminates the distinction between parent and child records that is prevalent in the network structure.

A. True

B. False

7.In a hierarchical structure, the parent records are subordinate to the child records.

  1. TrueFalse

8. Rows in a relational database table are also called attributes or domains.

  1. TrueFalse

9. A record layout details the record structure, including each field’s name, width, and data type.

  1. TrueFalse

10. The method of designing the interface between program instructions and data which creates a 1-to-1 relationship between an application program and a data file is called

  1. data-oriented processing
  2. file-oriented processing
  3. secondary processing
  4. batch processing
  5. events-based processing

11. Redundancies in data and programs are both inefficient and problematic because

  1. they increase internal control over data entry functions
  2. they enable the creation of a large volume of program code

C.they create data inconsistencies as data across applications are changed or updated

D.they decrease the risk of business and information processing risk

E.both A and D above

12. In a file-oriented processing environment, a program application that produces information about merchandise shipped to customers would

  1. access a shipment file that was created just for use with that application and contains all of the fields (e.g. shipment number, date, customer number, customer name, customer address, inventory items shipped, etc.) necessary for that application.
  2. access the customer, shipment, and inventory tables in a database
  3. access three different files – one called shipment, one called customer, and one called inventory
  4. have both the program and the data encapsulated together into objects
  5. not be able to access data about customer addresses because that data would not be available within the shipment file.

13. Database management software packages (DBMS) use a variety of architectures to organize and access data, including

  1. hierarchical
  2. network
  3. relational
  4. object-oriented
  5. all of the above

14. The database structure that includes parent records and child records such that child records are owned by the parent records and access to a child record comes only through its parent record is the ______logical structure.

  1. hierarchical
  2. network

C.relational

D.object-oriented

15. The hierarchical logical structure can be described by all EXCEPT which of the following?

  1. a parent record can be associated with multiple child records
  2. a child record can be associated with multiple parent records
  3. child records are subordinate to parent records
  4. the hierarchical logical structure is a tree-like structure
  5. all of the above describe the hierarchical logical structure

16. Relational structures can model which of the following maximum cardinalities?

  1. 1:1 and 1:*
  2. 1:1, 1:*, and *:1
  3. 1:1,1:*,*:1, and *:*
  4. *:1 and *:1
  5. *:*, *:1, and 1:*

17. Relationships among tables in the relational structure are

A. always one to many

B. haphazard and unorganized

C. represented by common data values in different tables

D. not part of the relational model

E.organized as logical trees

18. Data definition commands are used in DBMS packages to

  1. add, delete, and update data in the structures
  2. help users ask questions about the data
  3. design the format and look of desired screens and forms
  4. set up the data structures and define user views of the data
  5. define the format and look of desired output

19. Data manipulation commands are used in DBMS packages to

  1. add, delete, and update data in the structures
  2. help users ask questions about the data
  3. design the format and look of desired screens and forms
  4. set up the data structures and define user views of the data
  5. define the format and look of desired output

20. Data query commands are used in DBMS packages to

  1. add, delete, and update data in the structures
  2. help users ask questions about the data
  3. design the format and look of desired screens and forms
  4. set up the data structures and define user views of the data
  5. define the format and look of desired output

21. Forms generators are used in DBMS packages to

  1. add, delete, and update data in the structures
  2. help users ask questions about the data
  3. design the format and look of desired screens and forms
  4. set up the data structures and define user views of the data
  5. define the format and look of desired output

22. When an organization uses database technology to develop a system

A.you can assume that an efficient, non-duplicate data-oriented environment is created

B.some still store and process data in tables or files that mirror those that existed in file-oriented manual systems

C.it is guaranteed that all its data will be integrated and its business processes will be effectively re-e ngineered

D.you know that all relevant data about business events, financial and non-financial, will be integrated into a common information storehouse such that it may be retrieved according to various user views

E.A, C, and D above

Answers:

1. a

2. b

3. b

4. b

5. a

6. b

7. b

8. b

9. a

10. b

11. c

12. a

13. e

14. a

15. b

16. c

17. c

18. d

19. a

20. b

21. c

22. b