Results 1 to 2 of 2
  1. #1
    mahi is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2009
    Posts
    1

    Unhappy need help

    Can someone do this exercise for me:???
    Instructions:

    Given the following table layouts for STUDENTS, TRANSCRIPT, and COURSES with Primary Keys and Foreign Keys

    STUDENTS
    TRANSCRIPT
    COURSES
    StudentID (Primary)
    TranscriptID (Primary)


    CourseID (Primary)
    FirstName
    StudentID (Foreign)
    CourseName
    LastName
    CourseID (Foreign)
    Credits
    Major
    Semester


    Grade


    Write the following queries in SQL:

    1. List the names of all the English majors.
    2. List the names of the students in US History.
    3. List all the courses all students have taken including the grade, when taken and the course name. List the students alphabetically.
    4. List all students and the total number of credits earned (for each student.)

    NOT NESSERY FOR FREE!!!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Isn't this why you were taking the course in the first place?

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums