This Course has been replaced by CSE557

Contents


    Questions on Data Design and Normalization

    1. The teacher brings some sample data.... and we normalize it.
    2. Bring any data sample to class -- we will normalize it (Stump the Chump).
    3. Terminology: Can you define these terms from [ d3.html ] ? Table, Row, Tuple, Field, Attribute, Key. (some terms refer to the same idea).
    4. Define: table, key, row, normalize, 0NF, 1NF, 2NF, 3NF.
    5. What is normalized data good for?
    6. What is normalized data bad for?
    7. Print out any myCoyote screen -- normalize it.
    8. Find any tally roll or printout that you have (and don't mind sharing) -- normalize it.
    9. Do you have any sample data from a field trip? -- Normalize it.
    10. You can apply normalization to software development artifacts. Do you have any source code to normalize? How about a data dictionary?
    11. In a template for normalizing data to Third Normal Form: what are the four sections? What mnemonic might you add to the section heads?

    12. Draw a simple UML class diagram (ERD) for a student registration data base that has the following tables (using the notation in this course (Prime key = **, Foreign key=*, ...)).
      1. Student(**SID, StudentName, ...)
      2. Class(**ClassID, *department, class#, classname, timeslot, room, *teacher)
      3. Enrolment(**ClassId, **SID)
      4. Schedules(**ClassId, **department)
      5. Department(**department, deptName, ...)
      6. Teacher(**TID, teachername, ...)
      7. Teaches(**TID, **ClassId)
      8. WorksFor(**TID, *department)

    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 [ 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