Riyadh Philanthropic Society For Science Prince Sultan College For Woman - PowerPoint PPT Presentation

aderes
slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Riyadh Philanthropic Society For Science Prince Sultan College For Woman PowerPoint Presentation
Download Presentation
Riyadh Philanthropic Society For Science Prince Sultan College For Woman

Loading in 2 Seconds...

play fullscreen
1 / 3
Download Presentation
Riyadh Philanthropic Society For Science Prince Sultan College For Woman
95 Views
Download Presentation

Riyadh Philanthropic Society For Science Prince Sultan College For Woman

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Riyadh Philanthropic Society For Science Prince Sultan College For Woman Dept. of Computer & Information Sciences CS 340 Introduction to Database Systems (Chapter 7 Tutorial)

  2. Exercise 1 • Map the AIRPORT EER schema of Exercise 4.21 (shown in Figure 4.12) into a relational schema. Specify all primary keys and foreign keys. Chapter 7 Practice Exercise 1

  3. WORKS_ON Solution ESSN PTModel PLANE_TYPE EMPLOYEE SSN Salary Shift Model Capacity Weight FLIES PSSN PTypeModel PILOT AIRPLANE SSN Lic_Num Restr Reg# PlaneModel HangerNumber PERSON OWNS SSN Address Phone Name OwnerID OwnerID AReg# PDate CORPORATION HANGER Name Address Phone OwnerID Number Capacity Location OWNER OwnerID SERVICE Date Workcode AirplaneReg# Hours MAINTAIN EmpSSN Date WorkCode Reg# Chapter 7 Practice Exercise 2