About SmartExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Accounting,Business & Finance See all

Accounting,Business & Finance,Economics,English,HR Management,Math Hide all

Teaching Since:	Apr 2017
Last Sign in:	3 Weeks Ago, 6 Days Ago
Questions Answered:	7559
Tutorials Posted:	7341

Education

BS,MBA, PHD
Adelphi University/Devry
Apr-2000 - Mar-2005

Experience

HOD ,Professor
Adelphi University
Sep-2007 - Apr-2017

Category > Programming Posted 24 Feb 2023 My Price 25.00

Introduction to Relational Database Management Systems Unit 4 Milestone

CIS 111 SOPHIA-STRAYER Introduction to Relational Database Management Systems Unit 4 Milestone-sobtell.com

Click link for Answers All Correct

In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment.

https://postgres.sophia.org/

Which of the following users architects the database?

•

Database administrator

•

System programmer

•

Database designer

•

System administrator

Which of the following would help protect data security during database migrations?

•

Converting schemas

•

Normalizing data

•

Testing for data loss

•

Removing personally identifiable information

https://postgres.sophia.org/

What is the best example of a scenario in which a new database should be created to support the business?

•

An organization would like to create an application to help manage appointments for pet-related services. The mobile application should allow pet owners to schedule services by viewing the availability of pet groomers within the app.

•

A local pet shop would like to offer pet services. They have six pet groomers on staff and use MS Outlook to help with tracking their appointments. The pet owner receives calls from customers and then schedules them on the company computer through Outlook.

•

An organization would like to add pet services as an option to their existing pet store sales database. Services and products should be able to be paid for at the same time.

•

An organization has found an application that can be used to manage pet services for pet owners and pet groomers. Both have to log into the existing site to set up appointments.

Which of these databases is limited in terms of database size?

•

PostgreSQL

•

Oracle

•

Teradata

•

MySQL

Consider the following command:

UPDATE customer

SET customer_id = customer_id --1;

What happens if we run this command in MySQL?

•

The customer table has every customer_id set to the same value as it previously had.

•

An error is thrown due to the --.

•

The customer_id in the customer table for all records is incremented by 1.

•

The customer_id in the customer table for all records is decremented by 1.

Which of the following criteria was a key milestone for the object-relational model created in the mid-1980s?

•

The use of this data model on IBM mainframe systems

•

The creation of a single structure that contained both data and its relationships

•

The existence of support for unstructured data

•

Identification of all of the data to be stored in a collection of tables with each table being independent and each of the rows in a table being related by common values

Which data model(s) introduced the use of a data manipulation language?

•

Network

•

Hierarchical

•

Both hierarchical and network

•

Neither

Which of the following is a key feature of a data warehouse?

•

This type of database has processing that is immediate to when the user makes a request.

•

This type of database is often denormalized with a focus on performance.

•

This type of database focuses on reducing data redundancy.

•

This type of database uses insert, update, and delete statements quickly.

What are the emerging major data models created between the early 2000s to the current day?

•

File system

•

XML Hybrid

•

Key-value store and wide-column store

•

Relational

What is the term related to a specific implementation of ANSI SQL by a vendor?

•

Implementation

•

Version

•

Dialect

•

T-SQL

Which of the following is a key part of conceptual design in an entity relationship model?

•

This model does not depend on the database management software or the hardware used to implement the model.

•

This model converts attributes into columns.

•

This model adds all of the attributes for each entity.

•

This model resolves the many-to-many relationships to multiple one-to-many relationships.

Which of the following is a key part of logical design in an entity relationship model?

•

In this model, no attributes are specified.

•

This model avoids any database model-specific details.

•

This model converts entities into tables.

•

This model has normalization that occurs.

Which of the following is a key feature of a relational database?

•

It has a broad umbrella of a variety of approaches with data storage and manipulation.

•

It is designed for highly available systems that should provide a consistent, high-quality experience for all users globally.

•

It has flexible data models that make it easy to store and combine data of any structure and allow dynamic changes to the schema.

•

It ensures strong consistency such that applications should be able to read what has been written to the database immediately.

Which of the following ALTER TABLE features is available in SQLite?

•

ADD CONSTRAINT

•

DROP COLUMN

•

ADD COLUMN

•

ALTER COLUMN

https://postgres.sophia.org/

As compared to databases, flat files have __________.

•

more consistency

•

less flexibility

•

more security

•

less redundancy

Which of the following creates one of the most common types of bottlenecks?

•

Transactions competing to access different tables

•

Transactions competing for different data rows in the same table

•

Transactions competing for the same data rows

•

Transactions running in sequence with one another

Which of the following is not a reason to identify and document business rules?

•

It can create a database that will work in any situation.

•

It can help standardize the company's view of the data.

•

It can allow developers to create an accurate data model.

•

It can allow the designer to create appropriate relationships.

Which of the following is a key part of physical design in an entity relationship model?

•

In this model, the characteristics such as location, path, and format are described.

•

This model uses column names instead of attributes.

•

This model resolves the many-to-many relationships to multiple one-to-many relationships.

•

In this model, no primary keys are specified in the entities.

https://postgres.sophia.org/

In the context of a database, what do we get when we process data?

•

Information

•

Raw facts

•

Constraints

•

Knowledge

What notation and relationship does this refer to?

•

Crow's Foot notation showing a 1:1 relationship

•

Chen notation showing an M:N relationship

•

Chen notation showing a 1:M relationship

•

Crow's Foot notation showing a 1:M relationship

Which of the following is not a common commercial database option?

•

SQLite

•

PostgreSQL

•

MariaDB

•

ANSI SQL

Which of the following criteria was a key milestone for the relational model created in the mid-1970s?

•

The identification of all of the data to be stored in a collection of tables with each table being independent and each of the rows in a table being related by common values

•

The creation of a single structure that contained both data and its relationships

•

The existence of support for unstructured data

•

The use of this data model on IBM mainframe systems

Which of the following creates one of the most common types of bottlenecks?

•

Sequential transactions

•

Data cache

•

Shared buffers and locks

•

Unused memory resources

Which of the following criteria was a key milestone for the object-relational model created in the mid-1980s?

•

A focus on high performance and fault tolerance

•

The use of inheritance to have a structure inherit attributes and methods of classes above it

•

The ability to have very large storage in petabytes

•

The creation of a relation or a table as a two-dimensional structure composed of rows and columns

Which of the following is not a reason to identify and document business rules?

•

It can allow the designer to understand business processes.

•

It can allow the designer to create appropriate relationships.

•

It can allow the designer to create appropriate constraints.

•

It can solve issues that are enforced by the application software.

Which of the following is a key feature of a relational database?

•

It is designed for highly available systems that should provide a consistent, high-quality experience for all users globally.

•

It uses primary keys and foreign keys as a means to provide efficient access to data and is supported directly in the database rather than maintained in the application code.

•

It has flexible data models that make it easy to store and combine data of any structure and allow dynamic changes to the schema.

•

It has high scalability and performance that can enable almost unlimited growth.

https://postgres.sophia.org/

Which term is the part of the database system that is the collection of stored facts?

•

Hardware

•

Software

•

Procedures

•

Data

https://postgres.sophia.org/

As compared to databases, flat files have worse __________. This means they have issues with data correctness, reliability, and accuracy.

•

redundancy

•

security

•

flexibility

•

integrity

What is a data type that is implemented differently by database vendors quite frequently?

•

Int

•

Date and time

•

String

•

Char

Which of the following is a key feature of a data warehouse?

•

This type of database uses insert, update and delete statements quickly.

•

This type of database is optimized for a large number of concurrent users making changes or querying the database.

•

This type of database is used to process day-to-day operations in real time.

•

This type of database generally only has data loads with extremely rare updates or deletes to the data.

Which data model(s) introduced the use of a data definition language?

•

Network

•

Hierarchical

•

Both hierarchical and network

•

Neither

Which of the following types of outer joins is implemented in SQLite?

•

LEFT OUTER JOIN

•

RIGHT OUTER JOIN

•

FULL OUTER JOIN

•

All of the above

What is true about table sizes with databases?

•

Databases may have limitations based on the number of table rows or specific storage size, while others are unlimited.

•

There is no maximum size regardless of the database.

•

There is a constant set maximum size due to compliance with ANSI SQL.

•

The maximum size in many cases can be unlimited depending on the amount of disk space allocated for the database.

Which of the following is a key part of conceptual design in an entity relationship model?

•

In this model, all table structures including column names, data types, column constraints, primary keys, foreign keys, and relationships are included.

•

In this model, entities are specified.

•

This model converts entities into tables.

•

This model has normalization that occurs.

Consider the following command:

UPDATE product

SET sale_price = price --5;

What happens if we run this command in MySQL?

•

The sale_price in the product table for all records is decremented by 5 from the price.

•

The sale_price in the product table for all records is incremented by 5 from the price.

•

The product table has every sale_price set to the same value as the price.

•

An error is thrown due to the --.

https://postgres.sophia.org/

In the context of a database, what is knowledge?

•

Raw facts of interest to the end user

•

A process that focuses on data collection, storage, and retrieval

•

A computer structure that holds a collection of related data

•

A body of information and facts about a specific topic

What notation and relationship does this refer to?

•

Crow's Foot notation showing a 1:1 relationship

•

UML notation showing a 1:1 relationship

•

Chen notation showing a 1:1 relationship

•

UML notation showing a 1:M relationship

https://postgres.sophia.org/

What is the best example of a scenario in which a new database should be created to support the business?

•

An organization would like to display the results of an external book review database in real time on their website.

•

An organization would like to add a review system to its existing book purchase database.

•

An organization would like to create a book review application allowing users to identify what books they have purchased, what they have read, and how much they liked a book.

•

An organization would like to pull the current reviews of books from different sites to display on their own website.

Which of the following is not a common commercial database option?

•

SQL Express

•

SQL Server

•

MariaDB

•

MS Access

Which of the following would help protect data security during database migrations?

•

Normalizing data

•

Converting schemas

•

Encrypting the data

•

Testing for data loss

Which of the following is a key part of logical design in an entity relationship model?

•

This model does not depend on the database management software or the hardware used to implement the model.

•

This model converts attributes into columns.

•

This data model includes all table structures including column names, data types, column constraints, primary keys, foreign keys, and relationships.

•

This model resolves the many-to-many relationships to multiple one-to-many relationships.

Which of the following criteria was a key milestone for the relational model created in the mid-1970s?

•

The ability to have very large storage in petabytes

•

The use of inheritance to have a structure inherit attributes and methods of classes above it

•

The creation of a relation or a table as a two-dimensional structure composed of rows and columns

•

A focus on high performance and fault tolerance

What was the fifth generation of major data models created during the mid-1990s?

•

XML Hybrid

•

Object-oriented

•

Relational

•

Key-value store and wide-column store

Which of the following is a key part of physical design in an entity relationship model?

•

This model does not depend on the database management software or the hardware used to implement the model.

•

This model avoids any database model-specific details.

•

This model resolves the many-to-many relationships to multiple one-to-many relationships.

•

This model converts attributes into columns.

Which of the following ALTER TABLE features is NOT available in SQLite?

•

RENAME COLUMN

•

RENAME TABLE

•

ADD CONSTRAINT

•

ADD COLUMN

Which of the following creates one of the most common types of bottlenecks?

•

Data cache

•

Unused memory resources

•

Sequential transactions

•

Shared buffers and locks

Which of the following is not a common commercial database option?

•

MySQL

•

Teradata

•

SQLite

•

Oracle

https://postgres.sophia.org/

What is the best example of a scenario in which a new database should be created to support the business?

•

An organization would like to build a support ticketing system for its custom ticketing application. None of the existing ticketing applications fit the workflow of the organization.

•

An organization would like to create a support ticketing tracking tool that anyone can access and change. There does not need to be any versioning or tracking of who changed items as long as they are being addressed.

•

An organization would like to build a support ticketing system. An open-source solution has the majority of the features that the organization needs. There are some improvements that still need to be made.

•

An organization has found a support ticketing tool that they could use. It is missing some features that they require in which the third party can build and add on.

https://postgres.sophia.org/

__________ is/are the instructions and rules that determine the design and use of the database.

•

Procedures

•

People

•

Hardware

•

Software

Consider the following command:

UPDATE product

SET sale_price = price --5;

What happens if we run this command in MySQL?

•

The product table has every sale_price set to the same value as the price.

•

The sale_price in the product table for all records is decremented by 5 from the price.

•

The sale_price in the product table for all records is incremented by 5 from the price.

•

An error is thrown due to the --.

Which of the following criteria was a key milestone for the relational model created in the mid-1970s?

•

The creation of a single structure that contained both data and its relationships

•

The use of this data model on IBM mainframe systems

•

The identification of all of the data to be stored in a collection of tables with each table being independent and each of the rows in a table being related by common values

•

The existence of support for unstructured data

Which of the following is a key part of logical design in an entity relationship model?

•

This model converts entities into tables.

•

This model has normalization that occurs.

•

This model avoids any database model-specific details.

•

In this model, no attributes are specified.

Which of the following is a key part of conceptual design in an entity relationship model?

•

This model has normalization that occurs.

•

This model converts entities into tables.

•

In this model, entities are specified.

•

In this model, all table structures including column names, data types, column constraints, primary keys, foreign keys, and relationships are included.

https://postgres.sophia.org/

As compared to databases, flat files have __________.

•

less flexibility

•

more consistency

•

less redundancy

•

more security

https://postgres.sophia.org/

In the context of a database, how is data different from information?

•

Data is the total body of knowledge.

•

Data consists of metadata.

•

Data is processed information that has meaning.

•

Data consists of raw facts and has no meaning.

Which of the following is not a reason to identify and document business rules?

•

It can allow developers to create an accurate data model.

•

It can allow the designer to understand business processes.

•

It can be used as a communication tool between users and designers.

•

It can ensure that the rules are based on the interpretation of senior management.

Which of the following is a key part of physical design in an entity relationship model?

•

This model avoids any database model-specific details.

•

This model does not depend on the database management software or the hardware used to implement the model.

•

This model resolves the many-to-many relationships to multiple one-to-many relationships.

•

This model converts attributes into columns.

Which data model(s) introduced the use of a data definition language?

•

Network

•

Hierarchical

•

Both hierarchical and network

•

Neither

What notation and relationship does this refer to?

•

Crow's Foot notation showing a 1:M relationship

•

UML notation showing a 1:M relationship

•

Crow's Foot notation showing a 1:1 relationship

•

Chen notation showing a 1:1 relationship

Which of these databases can be unlimited in terms of database size?

•

Oracle

•

SQL Server

•

PostgreSQL

•

SQLite

Which of the following would help protect data security during database migrations?

•

Testing for data loss

•

Normalizing data

•

Converting schemas

•

Encrypting the data

Which of the following is a key feature of a data warehouse?

•

This type of database is often denormalized with a focus on performance.

•

This type of database uses insert, update, and delete statements quickly.

•

This type of database focuses on reducing data redundancy.

•

This type of database has processing that is immediate to when the user makes a request.

What is the term related to a specific implementation of ANSI SQL by a vendor?

•

T-SQL

•

Dialect

•

Implementation

•

Version

What are the emerging major data models created between the early 2000s to the current day?

•

XML Hybrid

•

Relational

•

Key-value store and wide-column store

•

File system

Which of the following criteria was a key milestone for the object relational model created in the mid-1980s?

•

The existence of support for unstructured data

•

The ability to have very large storage in petabytes

•

The ability to hide the complexities of the model from the user through the use of the database management system

•

The collection of similar structures that consisted of shared attributes and behaviors

Which of the following is a key feature of a relational database?

•

They have a broad umbrella of a variety of approaches with data storage and manipulation.

•

They make sorting, filtering, and computing various calculations with expressive query languages easy.

•

They are designed to be highly available systems that provide a consistent high-quality experience for all users globally.

•

They offer high scalability and performance that can enable almost unlimited growth.

Which of the following is a key feature of a data warehouse?

•

This type of database is used to process day-to-day operations in real time.

•

This type of database focuses on reducing data redundancy.

•

This type of database is optimized to execute a small number of complex queries.

•

This type of database is optimized for a large number of concurrent users making changes or querying the database.

Which of the following is a key part of logical design in an entity relationship model?

•

This model uses column names instead of attributes.

•

In this model, the characteristics such as location, path, and format are described.

•

Different database management systems may have different options for this type of model.

•

In this model, no primary keys are specified in the entities.

Which of the following represents a security issue related to database migrations?

•

Having data be read from a third party during the transfer

•

Having databases in different departments

•

Having the physical drives get damaged during migration

•

Having databases in different geographies

Which of the following is a key part of physical design in an entity relationship model?

•

In this model, no attributes are specified.

•

This model adds all of the attributes for each entity.

•

This model has normalization that occurs.

•

This model converts entities into tables.

https://postgres.sophia.org/

As compared to databases, file sizes in flat files can be much larger due to __________.

•

flexibility

•

security

•

redundancy

•

data integrity

Which data model do databases like Oracle, MS SQL Server, Postgres, and MySQL fall under?

•

Object-oriented

•

XML Hybrid

•

Hierarchical and network

•

Relational

Which statement is true of the network data model, but not true of the hierarchical data model?

•

It introduced the use of data commands like SELECT and INSERT.

•

It depicts a set of one-to-many relationships.

•

In this data model, each parent can have multiple children, but a child can only have one parent.

•

It was the first of the widely used data models in the 1970s.

Answers

SmartExpert

(118)

Status NEW Posted 24 Feb 2023 04:02 AM My Price 25.00

CIS----------- 11-----------1 S-----------OPH-----------IA------------STR-----------AYE-----------R I-----------ntr-----------odu-----------cti-----------on -----------to -----------Rel-----------ati-----------ona-----------l D-----------ata-----------bas-----------e M-----------ana-----------gem-----------ent----------- Sy-----------ste-----------ms -----------Uni-----------t 4----------- Mi-----------les-----------ton-----------e-s-----------obt-----------ell-----------.co-----------m -----------Cli-----------ck -----------lin-----------k f-----------or -----------Ans-----------wer-----------s A-----------ll -----------Cor-----------rec-----------t-----------

Attachments

file 1677211822-Unit 4 Milestone Introduction to Relational Database Management Systems.doc preview (6104 words )

A -----------xbj-----------bj -----------.hh-----------pf -----------f ----------- 8-----------D L----------- ((-----------((9-----------Lt -----------((V-----------VV(-----------(VV-----------V0B-----------(40-----------wHb-----------0HB-----------BV,-----------V@f----------- X ----------- DC-----------IS -----------111----------- SO-----------PHI-----------A-S-----------TRA-----------YER----------- In-----------tro-----------duc-----------tio-----------n t-----------o R-----------ela-----------tio-----------nal----------- Da-----------tab-----------ase----------- Ma-----------nag-----------eme-----------nt -----------Sys-----------tem-----------s U-----------nit----------- 3 -----------Mil-----------est-----------one------------so-----------bte-----------ll.-----------com----------- Cl-----------ick----------- li-----------nk -----------for----------- An-----------swe-----------rs -----------All----------- Co-----------rre-----------ct ----------- 1 -----------In -----------eac-----------h m-----------ile-----------sto-----------ne,----------- yo-----------u m-----------ay -----------wan-----------t o-----------r n-----------eed----------- to----------- us-----------e t-----------he -----------dat-----------aba-----------se -----------and----------- qu-----------ery----------- to-----------ol -----------to -----------ans-----------wer----------- so-----------me -----------of -----------the----------- qu-----------est-----------ion-----------s. -----------We -----------sug-----------ges-----------t y-----------ou -----------ope-----------n t-----------he -----------too-----------l i-----------n a-----------not-----------her----------- br-----------ows-----------er -----------tab----------- wh-----------ile----------- yo-----------u a-----------re -----------wor-----------kin-----------g o-----------n t-----------his----------- as-----------ses-----------sme-----------nt.----------- HY-----------PER-----------LIN-----------K h-----------ttp-----------s//-----------pos-----------tgr-----------es.-----------sop-----------hia-----------.or-----------g/h-----------ttp-----------s//-----------pos-----------tgr-----------es.-----------sop-----------hia-----------.or-----------g/

Not Rated(0)

Buy Answer

Hire Dedicated Virtual Team / Business Solution for SMEs.

SmartExpert

(118)

About SmartExpert

Education

Experience

Introduction to Relational Database Management Systems Unit 4 Milestone

Answers

Attachments

Are You a Business Owner?