Review

1
Review 3Chapters 9,10,5

• 1
• A. A table in relational data model containing
  the inserted raw data that is likely to
  correspond to one l physical file in a secondary
  storage.
• B. A subquery in processing the inner query
  depends on data from the outer query.
• C. Data definition language is used to define a
  database including creating, altering and
  dropping tables and establishing constraints.
• D. Data manipulation language is used to maintain
  and query a database, including updating,
  inserting, modifying and querying data.
• E. A relational operation that causes 2 tables to
  be combined into 1 table or view.
• F. A join in which the joining condition is based
  on the equality between values in the common
  columns.
• G. Equi-join with duplicate column eliminated.
• H. A join in which rows do not have matching
  values in common columns are also included in the
  result table.
• I. An integrity constraint specifying that the
  value of an attribute in one relation depends on
  the value of a primary key in the same or
  another.
• J. Manages data as a collection of tables in
  which all data relationships are represented by
  common values in related tables.
• K. contains descriptions of objects created by
  the user, such as base tables, views,
  constraints, etc., as part of the database.
• 5
• Reduce training costs, productivity, application
  portability and longevity, reduced single vendor
  dependence and cross-systems communications.
• 7

2
Review Question Ch10

• 1
• a. Software that provides connectivity using
  Internet and Web technology.
• b. RDBMS module that produces the program
  instructions that define a form, report or menu.
• c. Infrastructure that underlies OLE and handles
  the basic services required to manage objects.
• d. Entity that contains linked or embedded
  objects.
• e. Determines what functions an interface
  provides at the time it is needed during program
  execution.
• f. Nonprocedural programming that detects an
  event when it occurs and generates an appropriate
  response.
• g. A simple language used to format documents,
  link to other Web pages and communicate between
  Web browsers.
• h. Feature that allows Web users to enter
  information into a web page and pass that to
  other pages or to an external program.
• i. A local network that uses HTML technology such
  as HTTP and FTP protocols.
• j. Language-independent binary standard for
  object sharing.
• k. Direct manipulation language that uses a
  graphical approach to query construction.
• l. Programming language that comes with Access97.
• m. Software that provides the GUI used to display
  Web pages and find those pages on request.
• 3
• QBE is easy to simple to use although not a
  standard. Good for end-user database programming.
• 6

3
Review Question Ch5

• 1
• a. Set of objects that have common structure and
  behavior.
• b. Encompasses an objects properties and
  property values.
• c. Represents how an object acts or reacts.
• d. Hide internal implementation details from its
  external view.
• e. Function or service provided by all instances
  of a class.
• f. Operation implementation.
• g. Creates new class instance.
• h. Accesses state of an object but does not alter
  the state.
• i. Alters state of the object.
• j. Class with no direct instances.
• k. Class with direct instances.
• l. Defines form or protocol of the operation but
  not its implementation.
• m. Shows how many objects participates in a given
  relationship.
• n. Class attribute which specifies a value common
  to an entire class rather than a specific value
  for an instance.
• o. Association that has attributes or operations
  of its own or participates in relationships with
  other classes.
• p. Same operation can occur to 2 or more classes
  in different ways.
• q. Replacing a method from a superclass by a more
  specific implementation of that method in a
  subclass.
• r. Object is an instance of more than 1 class.

4
6
EMPLOYEE
STUDENT
COURSE
PART
WAREHOUSE
VENDOR
SUPPLIES
5
9
ACCOUNT
Acct_No Date_Opened Balance
Calc-Balance()
CHECKING
SAVINGS
LOAN
Service_Charge
Interest_Rate
Interest_Rate Payment
Calc_Serv_Charge
Calc_Int_Rate
Calc_Payment