Review Quesition Essay

20362 Words Sep 13th, 2015 82 Pages
DATABASE SOLUTIONS (2nd Edition)

THOMAS M CONNOLLY & CAROLYN E BEGG

SOLUTIONS TO REVIEW QUESTIONS

Chapter 1 Introduction- Review questions

1.1 List four examples of database systems other than those listed in Section 1.1.

Some examples could be: • A system that maintains component part details for a car manufacturer; • An advertising company keeping details of all clients and adverts placed with them; • A training company keeping course information and participants’ details; • An organization maintaining all sales order information.

1.2 Discuss the meaning of each of the following terms:

(a) data

For end users, this constitutes all the different values connected with the various
…show more content…
The structure of the data is now kept separate from the programs that operate on the data. This is held in the system catalog or data dictionary. Programs can now share data, which is no longer fragmented. There is also a reduction in redundancy, and achievement of program-data independence.

1.4 Describe the five components of the DBMS environment and discuss how they relate to each other.

1) Hardware: The computer system(s) that the DBMS and the application programs run on. This can range from a single PC, to a single mainframe, to a network of computers.
2) Software: The DBMS software and the application programs, together with the operating system, including network software if the DBMS is being used over a network.
3) Data: The data acts as a bridge between the hardware and software components and the human components. As we’ve already said, the database contains both the operational data and the meta-data (the ‘data about data’).
4) Procedures: The instructions and rules that govern the design and use of the database. This may include instructions on how to log on to the DBMS, make backup copies of the database, and how to handle hardware or software failures.
5) People: This includes the database designers, database administrators (DBAs), application programmers, and the end-users.

1.5 Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier

Related Documents