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