Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AIRCRAFT AC_NUM AC_MODEL 123U MD-80 375G B-737 411H B-737 ASSIGNMENT FLT_NUM FLT_DATE AC_NUM 101 14-Jan-16 3750 101 15-Jan-16 3756 101 16-Jan-16 411H 101 17-Jan-16 375G

image text in transcribed
AIRCRAFT AC_NUM AC_MODEL 123U MD-80 375G B-737 411H B-737 ASSIGNMENT FLT_NUM FLT_DATE AC_NUM 101 14-Jan-16 3750 101 15-Jan-16 3756 101 16-Jan-16 411H 101 17-Jan-16 375G 101 18-Jan-16 123U 102 14-Jan-16 3756 FLIGHT 102 15-Jan-16 375G FLT_NUM FLT_ORIGIN FLT_DESTINATION 102 16-Jan-16 411H 102 17-Jan-16 375G 101 MEM ATL 102 18-Jan-16 1230 102 ATL MEM Q1: For each table, identify the PK and FK 792: Do the tables meet the entity integrity rules in database? Why 7Q3: Do the tables meet referential integrity? Why

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

More Books

Students also viewed these Accounting questions

Question

x-3+1, x23 Let f(x) = -*+3, * Answered: 1 week ago

Answered: 1 week ago