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 Mark for Review

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: Mark for Review

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? Mark for Review

DELIVERY ADDRESS (Home, Office)

STUDENT (Grade A student, Average Student)

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

STUDENT ( University, Technical College)

STUDENT (Grade A student, Average Student)

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

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

Daily traffic patterns must be monitored to determine which countries are overcrowded.

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.

Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review

Cites may change their names and/or country association if the borders of a country change.

Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

If you are doing a system for any French City, you would need security clearance.

People are born in the city and people die in the city.

Foreign keys cannot be null when Mark for Review

It contains three or more columns

Column integrity refers to... Mark for Review

Columns always containing values consistent with the defined data format

Columns always containing text data less than 255 characters

Columns always containing positive numbers

The "Arc Implementation" is a synonym for what type of implementation? Mark for Review

Supertype and Subtype Implementation

In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review

Object names must not start with a number. They must begin with a letter.

There is no problem here. You can create a table called 1_TABLE.

The database does not understand all capital letters.

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

You cannot have spaces between words in a table name

The database does not understand all capital letters

Try Out Basis Data TI-A

University

•

50 Qs

Similar activities

Scratch Programming

5th Grade - University

•

50 Qs

IP MIDTERM

University

•

45 Qs

shell programing

University - Professional Development

•

49 Qs

SAINS KOMPUTER TINGKATAN 4 BAB 1

3rd Grade - University

•

50 Qs

Rekayasa Perangkat Lunak

University

•

50 Qs

Lesson 1 Quiz: Spreadsheets using Excel

University

•

45 Qs

Data Communication and Network

11th Grade - University

•

50 Qs

UAS Teknologi Informasi 2

University

•

50 Qs

Try Out Basis Data TI-A

Quiz

•

Computers

•

University

•

Practice Problem

•

Easy

Raja 2207135965

Used 5+ times

FREE Resource

When all non-UID attributes are dependent upon the entire UID

When attributes with repeating or multi-values are present.

When no attritibutes are mutually independent and all are fully dependent on the primary key.

None of the Above.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the rule of Second Normal Form?Mark for Review

No non-UID attributes can be dependent on any part of the UID.

Some non-UID attributes can be dependent on the entire UID.

All non-UID attributes must be dependent upon the entire UID.

None of the above

MULTIPLE CHOICE QUESTION

30 sec • 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
Mark for Review

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

Delete the attribute STORE ID

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.

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?

Similar Resources on Wayground

50 questions

PF201: SCCPF2012223

Quiz

•

University

45 questions

Speech Recognition: Mid Test Preparation

Quiz

•

University

55 questions

3 курс Cybersecurity Compliance Framework & System Administratio

Quiz

•

University

50 questions

Basis Data - Kuis 2

Quiz

•

University

50 questions

Midterm Examination-Advacomt (I-AINS) Asuncion

Quiz

•

University

45 questions

STACK DATA STRUCTURE

Quiz

•

University

50 questions

Ôn tập mos 11

Quiz

•

University

50 questions

Software engineering MCQ Test 1

Quiz

•

University

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

$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

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

University

Try Out Basis Data TI-A

50 questions

an entity can only have one Primary UID. True or False?

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

There is no limit to how many columns can make up an entity's UID. True or False?Mark for Review

A unique identifier can only be made up of one attribute. True or False? Mark for Review

When is an entity in 2nd Normal Form? Mark for Review

What is the rule of Second Normal Form?Mark for Review

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
Mark for Review

When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as....Mark for Review

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
Mark for Review

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?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Try Out Basis Data TI-A

50 questions

an entity can only have one Primary UID. True or False?

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

There is no limit to how many columns can make up an entity's UID. True or False?Mark for Review

A unique identifier can only be made up of one attribute. True or False? Mark for Review

When is an entity in 2nd Normal Form? Mark for Review

What is the rule of Second Normal Form?Mark for Review

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

When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as....Mark for Review

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

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?

Access all questions and much more by creating a free account

Similar Resources on Wayground

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
Mark for Review

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
Mark for Review