Database Section 4-5 Quiz

Primary key constraints should have a suffix of PKEY. (true/false)

false

Constraints should be given meaningful names to make them easier to reference. (true/false)

true

Converting a Relational model to a Logical model is called reverse engineering. (true/false)

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/false)

true

The steps to create a glossary from an existing Logical model are

Right click Logical model, select Create Glossary from Logical Model

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

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

short table name

Primary key constraints are named using the __________________.

table short name

We can apply naming abbreviations using the .csv file containing the abbreviations (true/false)

true

You must first select the Logical model you want to work with to Engineer it to a Relational model. (true/false)

true

When mapping subtypes to tables we can ________

use either one or multiple tables are valid options.

The Oracle SQL Data Modeler enables you to do all of the following except: -Store application data -Create process, logical, relational and physical models -Store metadata information -Capture business rules and information

-Store application data

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

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

Use a .csv file containing table names and abbreviations

Which of the following cannot be modeled using the Oracle SQL Data Modeler? -Entities, attributes, UIDs -Supertype and subtype entities -Recursive Relationships -Arc relationships -All can be modeled.

-All can be modeled.

You can define naming standards in Oracle SQL Developer Data Modeler using _______________. -Glossary -Naming Templates -Design Rule Validations -All of the above can be used to define naming standards in Oracle SQL Data Modeler.

-All of the above can be used to define naming standards in Oracle SQL Data Modeler.

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 -Do all of these steps.

-Do all of these steps.

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

Foreign Key

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

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

column

_______ Engineering is the process of creating a conceptual or logical model by extracting the information from an existing data source.

forward

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

forward

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

glossary

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

logical

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

true

An Entity Relationship model does not highlight the physical and database constraints. It is essential to transform the ER model into a relational model which can serve as the basis for defining the physical implementation of the database. (true/false)

true

In Oracle SQL Developer Data Modeler you can select how you want to map your subtypes. (true/false)

true

The glossary can be used as the naming standard for your Logical Model. (true/false)

true

Top-Down Modeling is the approach taken for designing a new database. (true/false)

true