1 / 6

Functional Data Models

Functional Data Models. Entities Relationships Inheritance Functional Query Languages. Staff() → ENTITY PropertyForRent() → ENTITY staffNo(Staff) → STRING sex(Staff) → CHAR salary(Staff) → REAL Name() → ENTITY Name(Staff) → NAME fName(Name) → STRING lName(Name) → STRING. Entities.

galena-fletcher
Download Presentation

Functional Data Models

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. Functional Data Models • Entities • Relationships • Inheritance • Functional Query Languages

  2. Staff() → ENTITY PropertyForRent() → ENTITY staffNo(Staff) → STRING sex(Staff) → CHAR salary(Staff) → REAL Name() → ENTITY Name(Staff) → NAME fName(Name) → STRING lName(Name) → STRING Entities

  3. Manages(Staff) PropertyForRent ManagedBy(PropertyForRent) → Staff INVERSE OF Manages Views(Client) PropertyForRent ViewedBy(PropertyForRent) Client INVERSE OF Views Relationships

  4. Staff() → ENTITY Supervisor() → ENTITY IS-A-STAFF(Supervisor) → Staff fName(Staff) → fName(Name(Staff)) fName(Supervisor) → fName(IS-A-STAFF(Supervisor)) Inheritence

  5. RETRIVE lName(Name(ViewedBy(Manages(Staff)))) WHERE staffNo(Staff) = 'SG14' RETRIVE Staff.Manages.ViewedBy.Name.lName WHERE Staff.staffNo = 'SG14' Functional Query Languages

  6. SELECT c.lName FROM Staff s, PropertyForRent p, Viewing v, Client c WHERE s.staffNo = p.staffNo AND p.propertyNo = v.propertyNo AND v.clientNo = c.clientNo AND s.staffNo = 'SG14' SQL version

More Related