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

Click link for Answers All Correct

 

 

Unit 5

 

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

• a.)

Both of the objects are attributes.

• b.)

There is no relationship between the entities.

• c.)

There is nothing wrong with the ERD.

• d.)

One of the items is set up as an attribute.

 

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

• a.)

There is nothing wrong with the ERD.

• b.)

There is no relationship between the entities.

• c.)

Both of the objects are attributes.

• d.)

One of the items is set up as an attribute.

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

• a.)

One of the items is set up as an attribute.

• b.)

There is nothing wrong with the ERD.

• c.)

There is no relationship between the entities.

• d.)

Both of the objects are attributes.

 

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

·                  a.)

There is nothing wrong with the ERD.

·                  b.)

The attributes are not correctly linked to the entity.

·                  c.)

The symbols used are swapped.

·                  d.)

The primary key is not indicated correctly.

 

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

• a.)

The symbols used are swapped.

• b.)

The primary key is not indicated correctly.

• c.)

The attributes are not correctly linked to the entity.

• d.)

There is nothing wrong with the ERD.

 

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

• a.)

The attributes are not correctly linked to the entity.

• b.)

All of the items are entities.

• c.)

There is nothing wrong with the ERD.

• d.)

The symbols used are swapped.

 

What type of cardinality is demonstrated by the following ERD? 

• a.)

A customer creates an invoice. An invoice is created by a customer.

• b.)

A customer creates multiple invoices. An invoice is created by a customer.

• c.)

A customer creates multiple invoices. An invoice can be created by multiple customers.

• d.)

A customer creates an invoice. An invoice can be created by multiple customers.

 

What type of cardinality is demonstrated by the following ERD? 

• a.)

A student can belong to a class. A class can have a student.

• b.)

A student can belong to multiple classes. A class can have a student.

• c.)

A student can belong to a class. A class can have multiple students.

• d.)

A student can belong to multiple classes. A class can have multiple students.

 

What type of cardinality is demonstrated by the following ERD? 

• a.)

A division has multiple employees. An employee belongs to multiple divisions.

• b.)

A division has an employee. An employee belongs to multiple divisions.

• c.)

A division has an employee. An employee has a division.

• d.)

A division has multiple employees. An employee belongs to a division.

 

Which of the following criteria would make an entity a weak entity?

·        a.)

If the entity can exist without the entity with which it has a relationship

·        b.)

If the primary key of a related entity contains the primary key of the parent entity

·        c.)

If the entity cannot exist without the entity with which it has a relationship

·        d.)

If the primary key is not derived from the parent entity in the relationship

Which of the following criteria would make an entity a weak entity?

·        a.)

If the entity has a primary key that is partially derived from the parent entity

·        b.)

If the primary key is not derived from the parent entity in the relationship

·        c.)

If the entity can exist without the entity with which it has a relationship

·        d.)

If the primary key of a related entity contains the primary key of the parent entity

Which of the following criteria would make an entity a weak entity?

·        a.)

If the entity can exist without the entity with which it has a relationship

·        b.)

If the primary key is not derived from the parent entity in the relationship

·        c.)

If the entity has a primary key that is totally derived from the parent entity in the relationship

·        d.)

If the primary key of a related entity contains the primary key of the parent entity

What does an associative entity model?

·        a.)

Associative entities model entities that are independent.

·        b.)

Associative entities model pure relationships rather than entities.

·        c.)

Associative entities model the real-world scenarios of ways to look up data.

·        d.)

Associative entities model attributes and how they are linked to entities.

Which is true about the primary key in an associative entity?

·        a.)

An associative entity has its primary key columns being all foreign keys.

·        b.)

An associative entity has a synthetic key.

·        c.)

An associative entity has a natural primary key.

·        d.)

An associative entity has an artificial primary key.

What is the purpose of an associative entity?

·        a.)

To represent a 1:1 relationship

·        b.)

To transform an M:N relationship into two 1:M relationships

·        c.)

To represent a single 1:M relationship

·        d.)

To combine multiple entities into a single entity

What is true about the data in a lookup table?

·        a.)

They resolve weak relationships.

·        b.)

They transform an M:N relationship into two 1:M relationships.

·        c.)

The keys are usually integers or short string codes.

·        d.)

They guarantee that there will be no data redundancies due to functional dependencies.

What is true about the data in a lookup table?

·        a.)

They model pure relationships rather than entities.

·        b.)

They resolve weak entities.

·        c.)

They transform an M:N relationship into two 1:M relationships.

·        d.)

The table holds data in the form of key-value pairs.

 

What is a benefit of using a lookup table?

·        a.)

They resolve weak relationships.

·        b.)

They contribute to storage savings.

·        c.)

They model pure relationships rather than entities.

·        d.)

They build in extra data redundancies.

What would be a reason to normalize a database?

·        a.)

To reduce the storage space of the data

·        b.)

To reduce the joining of tables, as that takes additional input/output operations

·        c.)

To store pre-aggregated or derived data

·        d.)

To have simplified queries with less joins

What would be a reason to normalize a database?

·        a.)

To eliminate unnecessary data redundancies

·        b.)

To reduce the joining of tables, as that takes additional input/output operations

·        c.)

To increase performance for reports

·        d.)

To have simplified queries with fewer joins

What would be a reason to normalize a database?

·        a.)

To prioritize performance rather than data anomalies

·        b.)

To have report data simplified, as the report may not be possible to generate using plain SQL

·        c.)

Our database may not need to have data be inserted, updated, or deleted.

·        d.)

To reduce the chance for data anomalies

Identify the normal form in which we have no partial dependencies.

·        a.)

3NF

·        b.)

1NF

·        c.)

2NF

·        d.)

None of the first three normal forms

Identify the normal form in which we eliminate repeating groups.

·        a.)

1NF

·        b.)

3NF

·        c.)

None of the first three normal forms

Identify the normal form in which we identify the primary key.

·        a.)

1NF

·        b.)

None of the first three normal forms

·        c.)

3NF

·        d.)

2NF

 

What would be introduced as criteria of a table being in first normal form?

·        a.)

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

·        b.)

There should be no repeating groups.

·        c.)

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

·        d.)

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

 

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

• a.)

No, because there are repeating groups and there is no primary key indicated.

• b.)

No, only because there are repeating groups.

• c.)

No, only because there is no primary key indicated.

• d.)

Yes, this dataset is in 1NF.

What would be introduced as criteria of a table being in first normal form?

·        a.)

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

·        b.)

Each cell of a table should have a single value.

·        c.)

There should be no functional dependencies.

·        d.)

The primary key of the table should be composed of one column.

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

·        a.)

All columns are functionally dependent on the primary key.

·        b.)

Each cell of a table should have a single value.

·        c.)

There should be no functional dependencies.

·        d.)

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

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

·        a.)

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

·        b.)

Each of the attributes or columns in a table should have a unique name.

·        c.)

Each cell of a table should have a single value.

·        d.)

Each attribute in a table should be functionally dependent on the primary key.

Which of the following is a key criterion of second normal form?

·        a.)

It must already be in 3NF.

·        b.)

It must already be in 1NF.

·        c.)

It must have repeating groups.

·        d.)

It must contain functional dependencies.

Given the following initial file, which of the following would be the ERD representing 3NF? 

• a.)

• b.)

• c.)

•  

 

What would be introduced as criteria of a table being in third normal form?

·        a.)

There should be no repeating groups.

·        b.)

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

·        c.)

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

·        d.)

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

 

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

·        a.)

There should be no functional dependencies.

·        b.)

Each cell of a table should have a single value.

·        c.)

The primary key of the table should be composed of one column.

·        d.)

Every table should have a functional dependency.

How does 4NF differ from BCNF?

·        a.)

4NF must satisfy all of the properties of 3NF.

·        b.)

BCNF has no multivalued dependencies.

·        c.)

There is no difference between the two.

·        d.)

4NF has no multivalued dependencies.

How does 5NF differ from 4NF?

·        a.)

5NF has no multivalued dependencies.

·        b.)

5NF does not contain any join dependencies.

·        c.)

5NF is more practical in real-world settings.

·        d.)

There is no difference between the two.

What is the key difference between BCNF and 3NF?

·        a.)

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

·        b.)

This normal form has the multivalued dependencies resolved.

·        c.)

This normal form removes repeating groups.

·        d.)

The BCNF has every determinant in a table to be a candidate key.

 

What would be a reason to denormalize our database?

·        a.)

We want to create extra join conditions.

·        b.)

We want to decrease the number of joins between tables.

·        c.)

We want to reduce redundancy.

·        d.)

We want to eliminate all redundancy.

What would be a reason why we may want to denormalize our database?

·        a.)

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

·        b.)

We want to reduce redundancy.

·        c.)

We want to eliminate repeating groups.

·        d.)

We may want to prioritize performance rather than data anomalies.

 

What would be a reason why we may want to denormalize our database?

·        a.)

We may want to reduce the joining of tables, as that takes additional input/output operations.

·        b.)

We want to eliminate repeating groups.

·        c.)

We want to remove multivalued dependencies.

·        d.)

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

What type of connections would exist given a fan trap?

·        a.)

Two one-to-many relationships that follow a parent-child form

·        b.)

One many-to-many relationship that converges on a single table

·        c.)

One many-to-many relationship that follows a parent-child form

·        d.)

Two one-to-many relationships that converge on a single table

What type of trap can occur when you have two one-to-many relationships that converge on a single table that doesn't show a relationship that is meant to exist?

·        a.)

Fan trap

·        b.)

System trap

·        c.)

Design trap

·        d.)

Chasm trap

What type of trap can occur when you have one entity in two 1:M relationships to other entities which can create an association among other entities that is not expressed in the model?

·        a.)

Chasm trap

·        b.)

System trap

·        c.)

Fan trap

·        d.)

Design trap

What is the purpose of having the billingAddressID and shippingAddressID in the Order table?

·        a.)

To avoid a fan trap connection trap issue

·        b.)

To avoid a chasm connection trap issue

·        c.)

For future planning purposes

·        d.)

To add redundancy

If the price is displayed on the Product table, why after 3NF does the unitPrice exist on the OrderLine table?

·        a.)

For future planning purposes

·        b.)

To help avoid connection errors

·        c.)

To add redundancy

·        d.)

The unitPrice captures the price at the time of the order.

In the original sample solution, a customer could only have one address. Review the finalized sample solution for the database design. 

How many addresses can be linked to a customer?

·        a.)

Unlimited

·        b.)

4

·        c.)

1

·        d.)

2

 

What is a benefit of reducing the complexity of data models?

·        a.)

More room for scalability

·        b.)

Adaptable in case business rules change

·        c.)

Decreased redundancy

·        d.)

Faster application development

What is a benefit of reducing the complexity of data models?

·        a.)

Adaptable in case business rules change

·        b.)

Simpler application code

·        c.)

More room for scalability

·        d.)

Increased data validation

Which of these is the most important factor when determining the complexity of an organization's data model?

·        a.)

Its business rules

·        b.)

Its budget

·        c.)

Its reputation

·        d.)

Its history

Review the sample solution for the database design. 

How many ratings can a user submit for a single movie?

·        a.)

2

·        b.)

1

·        c.)

0

·        d.)

Unlimited

With the AverageRating in a Movie table, what is the purpose of having this set?

·        a.)

To reduce redundancy

·        b.)

To simplify reports that use the AverageRating

·        c.)

To prevent a connection trap issue

·        d.)

To add another column to store the average from another database

Adding a ReviewDate to the Ratings table in this ERD serves multiple purposes.

What is NOT a reason for adding it?

·        a.)

To track user activity based on the rating dates

·        b.)

To identify when a rating was submitted

·        c.)

To determine which rating was submitted by which user

·        d.)

To identify a user's most recent rating

 

 

SmartExpert

(118)

Status NEW Posted 24 Feb 2023 03:02 AM My Price 15.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----------- Ch-----------all-----------eng-----------es------------sob-----------tel-----------l.c-----------om ----------- Cl-----------ick----------- li-----------nk -----------for----------- An-----------swe-----------rs -----------All----------- Co-----------rre-----------ct-----------

Attachments

file 1677207765-Unit 5 Challenges Introduction to Relational Database Management Systems.doc preview (3201 words )

A -----------Fbj-----------bj -----------.hh-----------000-----------00D-----------DDD-----------4Dt-----------fhh-----------hhh-----------hL0-----------00s-----------ss0-----------0fs-----------fss-----------V.R-----------GVl-----------R0l-----------/.0-----------.sQ-----------X -----------DCI-----------S 1-----------11 -----------SOP-----------HIA------------ST-----------RAY-----------ER -----------Int-----------rod-----------uct-----------ion----------- to----------- Re-----------lat-----------ion-----------al -----------Dat-----------aba-----------se -----------Man-----------age-----------men-----------t S-----------yst-----------ems----------- Un-----------it -----------5 C-----------hal-----------len-----------ges------------so-----------bte-----------ll.-----------com----------- Cl-----------ick----------- li-----------nk -----------for----------- An-----------swe-----------rs -----------All----------- Co-----------rre-----------ct ----------- U-----------nit----------- 5 ----------- Wh-----------at -----------is -----------wro-----------ng -----------wit-----------h t-----------he -----------fol-----------low-----------ing----------- ER-----------D m-----------ean-----------t t-----------o s-----------how----------- a -----------rel-----------ati-----------ons-----------hip----------- be-----------twe-----------en -----------two----------- en-----------tit-----------ies----------- I-----------NCL-----------UDE-----------PIC-----------TUR-----------E h-----------ttp-----------s//-----------app-----------.so-----------phi-----------a.o-----------rg/-----------dow-----------nlo-----------ad/-----------cke-----------dit-----------or/-----------pic-----------tur-----------es/-----------223-----------281-----------/da-----------ta/-----------con-----------ten-----------t/u-----------5_2-----------a.j-----------pg ----------- ME-----------RGE-----------FOR-----------MAT-----------INE-----------T -----------a.)----------- Bo-----------th -----------of -----------the-----------

Not Rated(0)

• Buy Answer