i) manufacturer → model Answer: i) MID — сараcity Answer: iii) model → capacity Answer: iv) MID → Acount Answer: v) AID, MID → Acount

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
icon
Related questions
Question
Models
Airlines
Fleet
MID manufacturer model capacity
AID
AID MID Acount
name
Вoeing
Вoeing
Вoeing
Airbus
1
777
340
1
American Airlines
1
3
15
2
787
260
United Airlines
1
10
3
737
140
3
Delta Air Lines
2
14
4
320
230
4
Southwest Airlines
2
1
8
5
Airbus
380
560
5
Alaska Airlines
3
24
Вoeing
747
420
3
4
5
7
5
3
16
4. Using the above instances of the relational tables Models, Airlines and Fleets, determine whether the
following functional dependencies hold. (Write yes/no)
) manufacturer → model
Answer:
i) MID — сараcity
Answer:
iii) model → capacity
Answer:
iv) MID → Acunt
Answer:
v) AID, MID → Acount
Answer:
9,
Transcribed Image Text:Models Airlines Fleet MID manufacturer model capacity AID AID MID Acount name Вoeing Вoeing Вoeing Airbus 1 777 340 1 American Airlines 1 3 15 2 787 260 United Airlines 1 10 3 737 140 3 Delta Air Lines 2 14 4 320 230 4 Southwest Airlines 2 1 8 5 Airbus 380 560 5 Alaska Airlines 3 24 Вoeing 747 420 3 4 5 7 5 3 16 4. Using the above instances of the relational tables Models, Airlines and Fleets, determine whether the following functional dependencies hold. (Write yes/no) ) manufacturer → model Answer: i) MID — сараcity Answer: iii) model → capacity Answer: iv) MID → Acunt Answer: v) AID, MID → Acount Answer: 9,
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage