Oracle Database Foundations Section 4 and 5

A Relational model is closer to the implementation solution, facilitates discussion and forms the basis for the physical database design.

True

You can define naming standards in Oracle SQL Developer Data Modeler using _______________.

Glossary, Naming Templates, Design Rule Validations

A ___________ model is the blue print to the actual database implementation and can be used as the basis for implementing any type of Database Management System (DBMS).

Relational

In Oracle SQL Developer Data Modeler you can select how you want to map your subtypes.

True

Top-Down Modeling is the approach taken for designing a new database.

True

To use the Oracle SQL Developer Data Modeler to apply naming standards :

Use a .csv file containing table names and abbreviations

Foreign key constraints are named using the ______________ of both tables.

short table name

When creating a database based on extracting metadata from an existing database or using the DDL code obtained from an implementation of an existing database, which data modeling approach would you choose?

Bottom-Up Modeling

When building a model in Oracle SQL Data Modeler you begin in the ________ tab.

Logical

To define naming templates in Oracle SQL Data Modeler:

Right click the name of the design in object browser, Select properties, select template, Edit the template to use abbreviations

The Oracle SQL Data Modeler enables you to do all of the following except:

Store application data

Primary key constraints are named using the __________________.

UID Suffix

A ______________ in Oracle SQL Developer Data Modeler is a set of accepted terms that can be used in the design.

glossary

When mapping subtypes to tables we can ________

Either one or multiple tables are valid options.

Each of the following can be modeled using the Oracle SQL Data Modeler ?

Entities, attributes, UIDs, Supertype and subtype entities, Recursive Relationships, Arc relationships

Primary key constraints should have a suffix of PKEY.

False

A column or combination of columns in one table that refers to a primary key in the same or another table.

Foreign Key

________ Engineering is the process of transforming a Logical Data Model to a Relational Model.

Forward

The steps to convert a Logical model to a Relational model using the Oracle SQL Developer Data Modeler are :

Select the Logical model, Click the Engineer to Relational Model icon, Accept defaults, Click Engineer

The steps to convert a Relational model to a Logical model using the Oracle SQL Developer Data Modeler are :

Select the Relational model, Click the Engineer to Logical Model icon, Accept defaults, Click Engineer

Constraints should be given meaningful names to make them easier to reference.

True

Converting a Relational model to a Logical model is called reverse engineering.

True

In Oracle SQL Data Modeler, the attribute that you assign as primary UID is automatically set to a mandatory attribute and will be engineered to a primary key in the relational model.

True

Each attribute in an entity maps to a _________ in a table.

column