Post reply

Noobie help! Weird Schema.

  • March 8, 2007 at 2:27 pm

    #92334

    So I have an test an the question is easy.. Here is the link.

    http://i178.photobucket.com/albums/w258/jayson12345a/NewBitmapImage.jpg

    I'm confused cause they make it look like the rows are separate.

    I would think DB is EMPLOYEE, table is EMPLOYEEID and the COLUMNS are FIRSTNAME, LASTNAME and HIREDATE.

    But the way they make it look is EMPLOYEE is the table, EMPLOYEEID is a column and FIRSTNAME, LASTNAME and HIREDATE are rows.

    The question is

    6.Given the schema below write a query that returns the number of employees in the employee table.

    Easy enough, but not if I am confused on the schema!

    Thanks for any help!!!

  • March 8, 2007 at 3:15 pm

    #693950

    The table name is Employee.  EmployeeID, FirstName, LastName, and HireDate are all column names.  They've separated the EmployeeID column so that they could mark it as being the Primary Key.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 8, 2007 at 3:39 pm

    #693955

    Hmm, that makes perfect sense. Thanks!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply