Database Project

1
Database Project Do one of the following design
a database schema, or implement/simulate a file
organization. 1. Design a database
schema for a real-world problem Gather
requirements / business rules Generate ER
model Specify additional integrity
constraints Normalized relations Potential
Areas UW General Calendar/Registration
Guide Auto Trader Others require approval by
instructor
2

• UW Calendar/Registration Guide
• Must accommodate cross-listed courses, different
  courses having same course number (e.g. History
  29.1010/6), sections, instructors, departments,
  examination, lecture, and lab scheduling,
• Auto Trader
• Use online system or magazines for information
  requirements
• 2. Implementation of the linear hashing
  mechanism.
• A File that contains two areas primary area and
  overflow area.
• The size of a bucket and the capacity of a bucket
  can be changed.
• The program can be used to input any number of
  records, or, random generation of a specified
  number of records.
• Report on average successful and unsuccessful
  search costs.