Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started