Contents


    A First Data Dictionary for MyRestaurent

      Introduction

      This is based on a project carried out by one of my graduate students [ ../seminar/20040223ChiehChouChou.txt ]

      Data Elements

    1. AddDate::element =Date .
    2. AddMoney::element =Money .
    3. Address::element =Varchar .
    4. AddTimes::element =Time .
    5. AddTimes::element =Time .
    6. AvailableStatus::element =Char(1) .
    7. BTime::element =Time .
    8. City::element =Varchar .
    9. CookingSign::element =Enumerated .
    10. Discount::element =PerCent .
    11. Enddate::element =Date .
    12. EndTime::element =Time .
    13. FirstName::element =Varchar .
    14. FoodCategory::element =VarChar .
    15. ItemName::element =Varchar .
    16. ItemNumber::element=Numeric, Identifies an item.
    17. LastName::element =Varchar .
    18. Lengh::element =Numeric, length of Table
    19. OrderNumber::element =Numeric .
    20. Password::element=Varchar, encrypted and salted password of user.
    21. PayWay::element=Enumerated, method of payment.
    22. PhoneNumber::element =Numeric, length 10 digits .
    23. Price::element =Money .
    24. Quantity::element =Numeric .
    25. SeatNumber::element=Numeric, Number of seats at table.
    26. SerialNumber::element=Numeric(2 digits), identifies Order item in Order
    27. State::element =Char( 2) .
    28. Status::element =Enumerated .
    29. TableNumber::element =Numeric (3 digits) .
    30. Total::element =Money .
    31. WaiterNumber::element=Numeric, identifies a unique waiter.
    32. Width::element =Numeric , Width of table.
    33. XCoordinate::element =Numeric, Of corner of table.
    34. YCoordinate::element =Numeric, Of corner of table.
    35. ZipCode::element =Numeric, length 5 digits .

      Data Types

      Char(n)=a sequence of n characters/bytes.
    36. Date::type=system defined dates.
    37. Enumerated::data_type=one of a small number of listed values.
    38. Money::type=Decimal with two digits after the point.
    39. Numeric::=a sequence of digits representing a number.
    40. Numeric(n)::=a sequence of n digits representing a number.
    41. Time::type=system defined time.
    42. Varchar::type=variable length character string.

      Date Records

    43. Table::record=( TableNumber, Width, Length, XCoordinate, YCoordinate, SeatNumber, AvailableStatus, WaiterNumber).
    44. Order::record=( OrderNumber, Total, PayWay, TableNumber, BTime, EndDate, EndTime, WaiterNumber, AddTimes, Discount).
    45. OrderItem::record=( SerialNumber, OrderNumber, ItemNo, Quantity, AddMoney, Status, Addtimes, AddDate, AddDate).
    46. Item::record=( ItemNumber, ItemName, CookingSign, Price, FoodCategory).
    47. Waiter::record=( WaiterNumber, Password, FirstName, LastName, Address, City, ZipCode, State, PhoneNumber).

      Exercises

      1. What information is significant and missing above?
      2. What errors can you find?

    . . . . . . . . . ( end of section A First Data Dictionary for MyRestaurent) <<Contents | End>>

    Abbreviations

  1. TBA::="To Be Announced".
  2. TBD::="To Be Done".

    Links

    Notes -- Analysis [ a1.html ] [ a2.html ] [ a3.html ] [ a4.html ] [ a5.html ] -- Choices [ c1.html ] [ c2.html ] [ c3.html ] -- Data [ d1.html ] [ d2.html ] [ d3.html ] [ d4.html ] -- Rules [ r1.html ] [ r2.html ] [ r3.html ]

    Projects [ project0.html ] [ project1.html ] [ project2.html ] [ project3.html ] [ project4.html ] [ project5.html ] [ projects.html ]

    Field Trips [ F1.html ] [ F2.html ] [ F3.html ]

    [ about.html ] [ index.html ] [ schedule.html ] [ syllabus.html ] [ readings.html ] [ review.html ] [ glossary.html ] [ contact.html ] [ grading/ ]

End