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

Click link for Answers All Correct

1

What is a benefit of using a lookup table?

•          

It resolves weak entities.

•          

There is data modification flexibility.

•          

It transforms an M:N relationship into two 1:M relationships.

•          

It guarantees that there will be no data redundancies due to functional dependencies.

2

Is this dataset in 2NF or not? If not, why not?

 

•          

It is already in 2NF.

•          

No, there are repeating groups.

•          

No, there are no transitive functional dependencies.

•          

No, there are columns that are not dependent on the primary key.

3

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/

What is wrong with the following ERD meant to show the attributes of an entity?

 

 

•          

The attributes are not correctly linked to the entity.

•          

The symbols used are swapped.

•          

There is nothing wrong with the ERD.

•          

The primary key is not indicated correctly.

4

What is a key feature of fifth normal form?

•          

This normal form resolves any multivalued dependencies.

•          

This normal form has the tables broken down into as many tables as possible to avoid redundancy.

•          

Foreign keys are created in this normal form.

•          

A key step in this normal form has every determinant in a table as a candidate key.

5

Review the sample movie ratings ERD after 3NF.

 

What is the relationship between tables Movie and User?

•          

1:1

•          

M:N

•          

1:M

•          

N:1

6

What type of connection trap could be created due to a convergence of two one-to-many relationships on a single table?

•          

Fan trap

•          

Chasm trap

•          

Design trap

•          

System trap

7

What is true about normalization?

•          

It should take into account business rules and data constraints.

•          

It reduces the number of joins.

•          

Each normal form provides faster performance.

•          

It adds layers of data redundancy.

8

What is the purpose of an associative entity?

•          

To combine multiple 1:M relationships into a single M:N relationship

•          

To break down an M:N relationship into multiple 1:M relationships

•          

To ensure that all relationships in the database are 1:1

•          

To eliminate any 1:1 relationships from the database design

9

Is this dataset in 3NF? If not, why not?

 

 

•          

Yes, it is in 3NF.

•          

No, it is not yet in 2NF.

•          

No, there is an issue with the functional dependency.

•          

No, there are repeating groups.

10

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/

What type of cardinality is demonstrated by the following ERD?

 

 

•          

A department has multiple professors. A professor is part of multiple departments.

•          

A department has a professor. A professor is part of a department.

•          

A department has a professor. A professor is part of multiple departments.

•          

A department has multiple professors. A professor is part of a department.

11

Review the sample eCommerce ERD after 3NF.

 

What is the relationship between tables Product and Order?

•          

N:1

•          

1:1

•          

M:N

•          

1:M

12

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/

What is used to indicate a weak entity in an ERD?

•          

Double diamond

•          

Single rectangular box

•          

Single diamond

•          

Double rectangular box

13

What is a reason to denormalize a database?

•          

To decrease redundancy in the database

•          

To remove multivalued dependencies from the database

•          

To reduce the database’s processing needs

•          

To prioritize data anomalies rather than performance

14

What is a criterion of a table being in first normal form?

•          

For every functional dependency where X is functionally dependent on Y, X should be the super key of the table.

•          

No non-prime attributes dependent on the candidate key should be included.

•          

All transitive functional dependencies of a non-prime attribute of a super key should be removed.

•          

Every cell of a table should have a single value.

15

Identify the normal form in which we have no independent multivalued dependencies.

•          

None of the first three normal forms

•          

2NF

•          

3NF

•          

1NF

16

What is a disadvantage associated with a simpler ERD design?

•          

Simpler application code

•          

Slower application development

•          

Simpler queries

•          

More redundancy

17

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/

What is wrong with the following ERD meant to show a relationship between two entities?

 

•          

There is no relationship between the entities.

•          

One of the items is set up as an attribute.

•          

There is nothing wrong with the ERD.

•          

Both of the objects are attributes.

 

 

1

What could be a reason to denormalize a database?

•          

We want to eliminate repeating groups.

•          

We want to reduce redundancy.

•          

We want to remove multivalued dependencies.

•          

We want to store pre-aggregated or derived data.

2

Is this dataset in 1NF? If not, why not?

 

 

•          

This data set is in 1NF already.

•          

There are repeating groups with the actor_names and possibly the genre_names.

•          

There are no foreign keys.

•          

There is no primary key.

3

Review the sample eCommerce ERD after 3NF.

 

What is the relationship between tables Customer and Order?

•          

M:N

•          

N:1

•          

1:1

•          

1:M

4

What is true about normalization?

•          

It adds layers of data redundancy.

•          

It is typically performed between conceptual and logical data modeling.

•          

It increases the chance of data anomalies.

•          

Each normal form provides faster performance.

5

Identify the normal form in which all of the attributes are set up to be dependent on the primary key.

•          

3NF

•          

None of the first three normal forms

•          

2NF

•          

1NF

6

Is this dataset in 3NF? If not, why not?

 

 

•          

No, it is not yet in 2NF.

•          

No, there are repeating groups.

•          

No, there is an issue with the functional dependency.

•          

Yes, it is in 3NF.

7

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/

What type of cardinality is demonstrated by the following ERD?

 

 

•          

A song can belong to multiple playlists. A playlist can contain multiple songs.

•          

A song can belong to a playlist. A playlist can contain multiple songs.

•          

A song can belong to multiple playlists. A playlist can contain a song.

•          

A song can belong to a playlist. A playlist can contain a song.

8

What is NOT another name for an associative entity?

•          

Strong entity

•          

Composite entity

•          

Linking table

•          

Bridge entity

9

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/

What is used to indicate a weak relationship in an ERD in Crow’s Foot notation?

•          

Single rectangular box

•          

Solid line between entities

•          

Dashed line between entities

•          

Double rectangular box

10

Review the sample movie ratings ERD after 3NF.

 

What is the relationship between tables Movie and Genre?

•          

1:M

•          

N:1

•          

M:N

•          

1:1

11

What is a benefit of using a lookup table?

•          

It models pure relationships rather than entities.

•          

It transforms an M:N relationship into two 1:M relationships.

•          

It resolves weak entities.

•          

It centralizes data about the key.

12

What is introduced as a criterion of a table in second normal form?

•          

There should be no repeating groups.

•          

All attributes in a table are dependent on the primary key.

•          

Each cell of a table should have a single value.

•          

There should be repeating groups.

13

What would need to be done to fix an issue with a chasm trap?

•          

Create a foreign key for each primary key in the relationships.

•          

Remove the middle table and connect the tables directly.

•          

Create a direct link between the two tables rather than depend on the middle relationship.

•          

The entire database design needs to be re-evaluated.

14

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/

What is wrong with the following ERD meant to show a relationship between two entities?

 

 

 

•          

One of the items is set up as an attribute.

•          

There is no relationship between the entities.

•          

There is nothing wrong with the ERD.

•          

Both of the objects are attributes.

15

What is an advantage associated with a simpler ERD design?

•          

Increased storage needs

•          

Slower application development

•          

More complex application code

•          

Simpler SQL queries

16

What is a key feature of fourth normal form?

•          

It is focused on eliminating join dependencies.

•          

It should already satisfy the properties of BCNF.

•          

It breaks tables down into as many tables as possible to avoid redundancy.

•          

It creates multivalued dependencies.

17

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/

What is wrong with the following ERD meant to show the attributes of an entity?

 

•          

The primary key is not indicated correctly.

•          

The symbols used are swapped.

•          

The attributes are not correctly linked to the entity.

•          

There is nothing wrong with the ERD.

Why is 5NF less practical than 3NF or 4NF in a real-world setting?

•          

It contains very little redundancy but sacrifices performance.

•          

It eliminates multivalued dependencies.

•          

Each table contains more than one candidate key.

•          

It creates too much data redundancy.

 

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/

What is wrong with the following ERD meant to show a relationship between two entities?

 

 

 

•          

Both of the objects are attributes.

•          

There is no relationship between the entities.

•          

One of the items is set up as an attribute.

•          

There is nothing wrong with the ERD.

Is this dataset in 3NF? If not, why not?

 

 

 

•           No, there are still repeating groups.

•          

No, there are not enough attributes for the entity.

•          

No, it is not yet in 2NF.

•          

Yes, it could be considered to be in 3NF.

 

What could be a reason to denormalize a database?

•          

The database may require us to value performance over storage and redundancy issues.

•          

We want to eliminate repeating groups.

•          

We want to increase performance for inserts, updates, and deletes.

•          

We want to increase the number of joins between tables to optimize performance.

 

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/

What is wrong with the following ERD meant to show the attributes of an entity?

 

•           The symbols used are swapped.

•          

The primary key is not indicated correctly.

•          

There is nothing wrong with the ERD.

•          

The attributes are not correctly linked to the entity.

 

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/

What is wrong with the following ERD meant to show the attributes of an entity?

  

•          

The attributes are not correctly linked to the entity.

•          

The symbols used are swapped.

•          

There is nothing wrong with the ERD.

•          

The primary key is not indicated correctly.

 

 

What is a disadvantage associated with a simpler ERD design?

•          

More complicated queries

•          

Faster application development

•          

Less adaptable if business rules change

•          

Increased storage needs

 

Identify the normal form in which we have all of the key attributes defined.

•          

3NF

•          

2NF

•          

None of the first three normal forms

•          

1NF

 

What is a criterion of a table being in first normal form?

•          

No non-prime attributes dependent on the candidate key should be included.

•          

This normal form guarantees that there will be no data redundancies due to functional dependencies.

•          

No cell should have repeating groups.

•          

All transitive functional dependencies of a non-prime attribute of a super key should be removed.

 

Is this dataset in 2NF or not? If not why not?

 

 

 

•           No, there are no transitive functional dependencies.

•          

No, the dataset is not yet in 1NF.

•          

No, there are still functional dependencies.

•          

It is in 2NF.

 

What is a benefit of using a lookup table?

•          

It resolves weak relationships.

•          

It guarantees that there will be no data redundancies due to functional dependencies.

•          

It provides fast answers to some questions.

•          

It models pure relationships rather than entities.

 

What is true about normalization?

•          

It adds layers of data redundancy.

•          

It increases the chance of data anomalies.

•          

The second nomal form is typically the highest level necessary.

•          

It may decrease performance due to additional joins.

 

n 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/

What type of cardinality is demonstrated by the following ERD?

 

 

•          

A country can have multiple capital cities. A capital city can belong to multiple countries.

•          

A country can have a capital city. A capital city can be part of one country.

•          

A country can have multiple capital cities. A capital city can be part of one country.

•          

A country can have a capital city. A capital city can belong to multiple countries.

 

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/

What is wrong with the following ERD meant to show a relationship between two entities?

•          

One of the items is set up as an attribute.

•          

There is nothing wrong with the ERD.

•          

Both of the objects are attributes.

•          

There is no relationship between the entities.

 

 

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 5----------- 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 1677212200-Milestone 5 Answer.docx preview (2065 words )

1----------- W-----------hat----------- is----------- a -----------ben-----------efi-----------t o-----------f u-----------sin-----------g a----------- lo-----------oku-----------p t-----------abl-----------e? ----------- -----------It -----------res-----------olv-----------es -----------wea-----------k e-----------nti-----------tie-----------s. ----------- -----------The-----------re -----------is -----------dat-----------a m-----------odi-----------fic-----------ati-----------on -----------fle-----------xib-----------ili-----------ty.----------- ----------- It----------- tr-----------ans-----------for-----------ms -----------an -----------M:N----------- re-----------lat-----------ion-----------shi-----------p i-----------nto----------- tw-----------o 1-----------:M -----------rel-----------ati-----------ons-----------hip-----------s. ----------- -----------It -----------gua-----------ran-----------tee-----------s t-----------hat----------- th-----------ere----------- wi-----------ll -----------be -----------no -----------dat-----------a r-----------edu-----------nda-----------nci-----------es -----------due----------- to----------- fu-----------nct-----------ion-----------al -----------dep-----------end-----------enc-----------ies-----------. -----------2 -----------Is -----------thi-----------s d-----------ata-----------set----------- in----------- 2N-----------F o-----------r n-----------ot?----------- If----------- no-----------t, -----------why----------- no-----------t? ----------- ----------- I-----------t i-----------s a-----------lre-----------ady----------- in----------- 2N-----------F. ----------- -----------No,----------- th-----------ere----------- ar-----------e r-----------epe-----------ati-----------ng -----------gro-----------ups-----------. ----------- N-----------o, -----------the-----------re -----------are----------- no----------- tr-----------ans-----------iti-----------ve -----------fun-----------cti-----------ona-----------l d-----------epe-----------nde-----------nci-----------es.-----------

Not Rated(0)

• Buy Answer