1 / 3

Riyadh Philanthropic Society For Science Prince Sultan College For Woman

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

aderes
Download Presentation

Riyadh Philanthropic Society For Science Prince Sultan College For Woman

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related