Question: Identify the integrity rules below. Column-integrity rule [Choose ] [Choose Data-integrity rule A primary key must be unique and no part of the primary key

 Identify the integrity rules below. Column-integrity rule [Choose ] [Choose Data-integrity

rule A primary key must be unique and no part of the

primary key can be null A column must contain only values consistent

Identify the integrity rules below. Column-integrity rule [Choose ] [Choose Data-integrity rule A primary key must be unique and no part of the primary key can be null A column must contain only values consistent with the defined data format of the column Define the relationally correct state for a database; they ensure that users can perform only those operations that leave the database in a correct, consistent state Referential integrity ry A foreign key must match an existing primary key value (or else be null) Entity integrity rule [ Choose Given the list of data below, which Data Type would best for column highlighted in Blue. Name Hired On Salary $40,000 Shawn Creviston 10/14/2009 Jon Cooley 4-17-2002 $70,000 Eric Wakwitz June, 13 2012 $100,000 Date O VarChar(10) Time Decimal(8,2) Question 32 1 pts Given the list of data below, which Data Type would be best for the column highlighted in Blue. Name Hired On Shawn Creviston 10/14/2009 Salary $40,000 $70,000 Jon Cooley 4-17-2002 Eric Wakwitz June, 13 2012 $100,000 O VarChar(6) O Decimal(8,2) O Decimal(2,8) Integer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!