Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts Of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

4th Edition

0619064625, 978-0619064624

More Books

Students also viewed these Databases questions