Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Mapping

    Uploaded by

    3alam.t
    This document contains the structure of tables for an airline database including tables for aircraft, airlines, employees, routes, transactions, and the relationships between them. It also includes tables for a hospital database containing information about patients, wards, consultants, nurses, drugs and patient-doctor-drug relationships. Additionally it outlines tables for a music database including musicians, instruments, songs, albums and their relationships and also includes tables for a property sales office tracking properties, owners, employees and their relationships. Finally it outlines tables for a school database including students, departments, courses, instructors and student-course relationships.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Mapping

    Uploaded by

    3alam.t
    5 views5 pages
    This document contains the structure of tables for an airline database including tables for aircraft, airlines, employees, routes, transactions, and the relationships between them. It also includes tables for a hospital database containing information about patients, wards, consultants, nurses, drugs and patient-doctor-drug relationships. Additionally it outlines tables for a music database including musicians, instruments, songs, albums and their relationships and also includes tables for a property sales office tracking properties, owners, employees and their relationships. Finally it outlines tables for a school database including students, departments, courses, instructors and student-course relationships.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains the structure of tables for an airline database including tables for aircraft, airlines, employees, routes, transactions, and the relationships between them. It also includes tables for a hospital database containing information about patients, wards, consultants, nurses, drugs and patient-doctor-drug relationships. Additionally it outlines tables for a music database including musicians, instruments, songs, albums and their relationships and also includes tables for a property sales office tracking properties, owners, employees and their relationships. Finally it outlines tables for a school database including students, departments, courses, instructors and student-course relationships.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    5 views5 pages

    Mapping

    Uploaded by

    3alam.t
    This document contains the structure of tables for an airline database including tables for aircraft, airlines, employees, routes, transactions, and the relationships between them. It also includes tables for a hospital database containing information about patients, wards, consultants, nurses, drugs and patient-doctor-drug relationships. Additionally it outlines tables for a music database including musicians, instruments, songs, albums and their relationships and also includes tables for a property sales office tracking properties, owners, employees and their relationships. Finally it outlines tables for a school database including students, departments, courses, instructors and student-course relationships.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    airCraft

    ID Capacity Model Maj_Pilot Assis_Pilot Host1 Host2 airlineID

    airLine

    ID
    ID Name Address contact_person

    airLine_Phones
    ID
    ID Phone

    Transaction
    ID
    ID Date desc amount airlineID

    Employee
    ID Name Address Gender Position Day Year Month airlineID

    Employee_Qali
    ID
    ID qualification

    Route
    ID origin destination distance classificatio

    Route_AirCraft
    RouteID CraftID #passenger Price Dep Arrival Duration
    patient
    ID name DOB Ward_ID Consultant_ID

    ward
    Examin_cons_Pait
    ID
    ID Name NurseNumber
    ID
    PID CID

    consultant
    ID
    ID name

    Nurse
    ID
    Number Name Address Ward_ID

    Drug
    Code dosage

    Drug_Brands
    ID
    Code Brnd

    Nrs_Ptn_Drg
    NNumber PID DCode date time dosage
    musician
    ID Name city street number

    instriment
    ID
    name key

    musician_SONG
    song ID
    ID song_ID
    ID
    ID Phone

    album
    album_song
    ID
    ID title date musicianID ID
    SongTitle albID

    musician_instrumnt
    ID
    ID inst_ID
    salesOfice
    ID
    number locaton Emp_id

    property
    ID address city state code salesNumber

    owner
    ID
    ID name

    employee
    ID
    ID name officeNumber

    owner_prop

    ownerId Prop_ID Percent


    student
    ID FNAme LName age Address Dep_id

    Department
    ID
    ID Name instr_id hiring date

    Courses
    ID
    ID Name Duration Desc topicID

    topic
    ID
    ID name

    instructor
    ID Name Address bonus salary hour-rate depID

    student_course

    studentID CourseID Grade

    Route_AirCraft
    CourseID InstID Evaluation

    You might also like