Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this publication. Your input is an important part of the information used for revision. • Did you find any errors? • Is the information clearly presented? • Do you need more information? If so, where? • Are the examples correct? Do you need more examples? • What features did you like most about this manual? If you find any errors or have any other suggestions for improvement, you can send comments by electronic mail to [email protected]. Please indicate the part number, section, and page number (if available)....

The guidelines in this book are intended to help you fully exploit some of Developer/ 2000’s most powerful features. Whether you’ve been using Developer/2000 for years or are brand new to the product, the concepts and suggestions provided in this book should make it easier for you to complete such tasks as deploying an existing Developer/2000 application on the Web, designing an effective graphical user interface, or tracking and managing the disparate modules that make up a single application. How does this book fit in with Developer/2000 online help? While you can always rely on the online help to explain how to accomplish a given task or which...

This guide is for people who administer the operation of an Oracle database sys- tem. These people, referred to as “database administrators” (DBAs), are assumed to be responsible for ensuring the smooth operation of an Oracle database system and for monitoring its use. The responsibilities of database administrators are described in Chapter 1.

The Oracle data server has been designed to meet the requirements of the network computing era. To ensure that the Oracle data server is appropriate for both small, departmental applications and enterprise-wide computing, it is offered in two configurations: + Oracle8 + Oracle8 Enterprise Edition

Two types of information are provided here: explanations of how dates are han- dled in the Developer/2000 products; and some guidance in moving towards Year 2000 compliance in applications created with these products.

The process of identifying and selecting a data access technology is based on careful consideration of several factors, including the capabilities of each data access method. In the two exercises in this activity, you will identify the potential data stores to be used within the Ferguson and Bardell, Inc. system and the factors that need to be considered when choosing the system’s data access technology.

In this activity, you will evaluate a physical design for the Ferguson and Bardell, Inc. case study and then determine areas within the physical design where data integrity requirements and business rules should be implemented with the methods presented in Module 7, “Implementing Data Integrity.

In this activity, you will evaluate a set of data requirements from the Ferguson and Bardell, Inc. case study to determine areas where possible data integrity issues might arise. You will then formulate a set of data integrity requirements that must be followed by the development team for the Ferguson and Bardell, Inc. solution.

This activity requires the use of the optimization techniques discussed in this module. You will consider ways to optimize a physical data design for insertions, updates, and deletions, as well as any nonfunctional requirements specified by the activity’s scenario.

In this activity, you will evaluate the logical design for part of the solution developed for the Ferguson and Bardell, Inc. case study. From this design, you will determine the tables, columns, data types, and keys that are appropriate for the solution

In this exercise, you will evaluate a logical design and then redesign it based on your knowledge of keys and normalization to produce a fully normalized data design.

In this activity, you will identify primary, foreign, and (if necessary) composite keys in the logical data model for Ferguson and Bardell, Inc.

In this activity, you will use the skills learned in this module to define the relationships within a logical data model and produce a sample ER diagram for the Ferguson and Bardell, Inc. case study. In each of the two exercises in this activity, you analyze a single aspect of a logical data design. At the end of each exercise, the class will discuss the design you derived.

The process of identifying entities and attributes is the key to creating a logical data design. This activity provides a real-world example of use case requirements that you will analyze to identify entities and attributes. In each of the two exercises in this activity, you analyze a single aspect of a logical data design. At the end of each exercise, the class will discuss the design you derived.

Identify a project that you have been involved with in the past. If you have never been involved in a software development project, pick any other type of project that involved some activities related to conceptual data design. For example, creating a little-league sports roster, a scoring or organization project, a school charity drive project, or the opening of an Internet Web site that has to service many users simultaneously.

In this activity, you will analyze a set of use cases derived from the Ferguson and Bardell, Inc. case study and determine data requirements, hidden data requirements, and nonfunctional data requirements from those use cases.

In this activity, you will identify service classes for the Ferguson and Bardell, Inc. case study. After these service classes have been identified and classified, you will answer a series of questions relating to services-based design and discuss your answers with the instructor and the rest of the class.

The process of designing a database involves analytical thinking about requirements as they relate to data. You regularly apply analytical thinking at work and in everyday life. This activity provides an opportunity to assess the skills you currently possess as tools that you can apply in this course.

The rules are fairly straightforward. Each team receives a turn to answer a question related to the Ferguson and Bardell, Inc. case study and the topics discussed in the course material. The instructor chooses each question. Team members confer among themselves, and a team representative presents the question’s answer to the instructor. If the team answers the question correctly, that team receives a point. If they fail to answer the question correctly, then the other team gets an opportunity to answer the opposing teams question. The teams will alternate opportunities to answer questions from the instructor....

Data Control Language (DCL) The subset of SQL statements used to control permissions on database objects. DCL is formed with GRANT and REVOKE statements.