Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES: # CLIENT ID FIRST NAME LAST NAME ORDER ID STREET ZIP CODE

None of the above, the entity is fully normalised.

Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES: # CLIENT ID FIRST NAME LAST NAME STREET CITY ZIP CODE

None of the above, the entity is fully normalised

If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:

Create an additional entity and relate it to the original entity with a 1:M relationship.

Do nothing, an entity does not have to be in 1st Normal Form

Create an additional entity and relate it to the original entity with a M:M relationship.

Which of the following would best be represented by an arc?

DELIVERY ADDRESS (Home, Office)

STUDENT (Grade A student, Average Student)

Which of the following would be a logical constraint when modeling time for a country entity?

Countries may change their names and/or borders over a period of time

People have births and deaths in their countries that must be tracked by the system

If you are doing a system for France or Germany, you would need security clearance.

You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?

Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity.

Email current prices to all employees whenever a price changes.

Allow them to enter whatever delivery charge they want

Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard

Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?

An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT

End Date must be before the Start Date.

Dates must be stored with Time.

EMPLOYEE periods can overlap causing the database to crash

Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) (Choose all correct answers)

A single column that uniquely identifies each row in a table

A set of columns that uniquely identifies each row in a table

Only one column that cannot be null

A set of columns and keys in a single table that uniquely identifies each row in a single table

Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on:

Both tables A and B get a new column and a Foreign Key.

Nowhere, One-to-One relationships are not transformed.

In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?

You cannot have spaces between words in a table name

The database does not understand all capital letters

Which of the following is a valid reason for considering a Subtype Implementation?

Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes

The common access paths for the supertypes are different.

The resulting table will reside in a single database and be used by just ONE user

Most of the relationships are at the supertype level.

UAS Sistem Basis Data

Authored by imam Asrowardi

Computers

University

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

To resolve a 2nd Normal Form violation, we:

Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity.

Move the attribute that violates 2nd Normal Form to a new ERD.

Do nothing, an entity does not need to be in 2nd Normal Form.

Delete the attribute that was causing the violation.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:

ENTITY: RECEIPT
ATTRIBUTES:
#CUSTOMER ID
#STORE ID
STORE LOCATION
DATE

Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity.

Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.

Do nothing, it is already in 2nd Normal Form.

Delete the attribute STORE ID

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Any Non-UID attribute must be dependent upon the entire UID. True or False?

True

False

MULTIPLE SELECT QUESTION

1 min • 1 pt

A UID can be made up from the following: (Choose Two)

(Choose all correct answers)

Entities

Relationships

Attributes

Synonyms

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?

True

False

MULTIPLE SELECT QUESTION

1 min • 1 pt

Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)
(Choose all correct answers)

Address

Employee ID

Social Security Number

Last Name

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An entity could have more than one attribute that would be a suitable Primary UID. True or False?

True

False

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

University

UAS Sistem Basis Data

To resolve a 2nd Normal Form violation, we:

Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:

ENTITY: RECEIPT
ATTRIBUTES:
#CUSTOMER ID
#STORE ID
STORE LOCATION
DATE

Any Non-UID attribute must be dependent upon the entire UID. True or False?

A UID can be made up from the following: (Choose Two)

(Choose all correct answers)

If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?

Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)
(Choose all correct answers)

An entity could have more than one attribute that would be a suitable Primary UID. True or False?

Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
# CLIENT ID
FIRST NAME
LAST NAME
ORDER ID
STREET
ZIP CODE

As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False?

The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another non-UID attribute. True or False?

Access all questions and much more by creating a free account

Popular Resources on Wayground

Discover more resources for Computers

UAS Sistem Basis Data

To resolve a 2nd Normal Form violation, we:

Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:ENTITY: RECEIPT ATTRIBUTES: #CUSTOMER ID #STORE ID STORE LOCATION DATE

Any Non-UID attribute must be dependent upon the entire UID. True or False?

A UID can be made up from the following: (Choose Two)(Choose all correct answers)

If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?

Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two) (Choose all correct answers)

An entity could have more than one attribute that would be a suitable Primary UID. True or False?

Examine the following Entity and decide which rule of Normal Form is being violated:ENTITY: CLIENT ATTRIBUTES: # CLIENT ID FIRST NAME LAST NAME ORDER ID STREET ZIP CODE

As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False?

The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another non-UID attribute. True or False?

Access all questions and much more by creating a free account

Popular Resources on Wayground

Discover more resources for Computers

Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:

ENTITY: RECEIPT
ATTRIBUTES:
#CUSTOMER ID
#STORE ID
STORE LOCATION
DATE

A UID can be made up from the following: (Choose Two)

(Choose all correct answers)

Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)
(Choose all correct answers)

Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
# CLIENT ID
FIRST NAME
LAST NAME
ORDER ID
STREET
ZIP CODE