You can try to get a more up to date version from the internet from my main page at (http://www.suba.com/~discov/john/john.htm)!

What NOW? - Get Around¯, Create (Tables of Fields)¯, Edit (Correct or Add Information)¯, Format (Select & Sort)¯, Save¯, Print (Labels & Reports)¯, Faster & Fancier¯, Other F&F DataBase Features¯, Now What Was Important?¯, Now What?¯

DATABASE = Rolodex, list of names that we can have the computer select and sort the information for us. A Database is a Base of Data. Simple, right? A Base is one centralized location, and data is information. So a Database is a central location for holding information. So for a huge office instead of everyone having their individual Rolodex with names and addresses, we store those names and addresses in a database. That way if someone calls and changes their address, instead of only one person writing it in their Rolodex it, is changed in the database for all to see and share.

Field: 1 piece of information, address and city, state zip are 4 separate fields.

Record: Information about 1 thing, as in Records about people. One record is about one person. A collection of fields.
Table: a collection of Records.
Database: Related Tables.
Tuple??
A Database main purpose is to make it easy to:

• Selecting Information either:
  • Which info as in Name & Address or Name & Phone #.
  • What info as in Everyone in the file or just people in Wisconsin.
    
• or Sorting Information
  
  • Putting the info in Zip Code, or Alphabetical order.
    

A Relational database still has files for students and classes but adds a third file to relate the two together. One student can take many classes, and a single class can have many students. This is accomplished with a third file to relate the two together.

1 to many (many to 1)
many to many relationships can't be dealt with easily, so we have two different 1 to many relationships.
NAME -< HAS >- CLASS
Reading right to left we can see that 1 name has many classes, or reading left to right we see 1 class has many names.

NOW What was Important? - CREATE = Type (Backspace to correct immediate mistakes). EDIT = DELETE (Selecting and press Delete) or ADD (Type). Select = Hold down Shift and Move to end. FORMAT = Selecting then Choose Menu or Toolbars. SAVE = File Save=Record; File Open = Play; File Save As = Record to a New Tape; File Close = Put Away & Pop out Tape; File Exit = Put away Tool (Typewriter or Tape Recorder) PRINT = File Print.

NOW What? - Next read about Internet . or go Ý Back to Top, = Back to Contents = or = Back to Main =.