Contents


    Questions on Data Design and Normalization

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

    11. 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 [ project0.html ] [ project1.html ] [ project2.html ] [ project3.html ] [ project4.html ] [ project5.html ] [ projects.html ]

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

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

End