15-9 Companies with many overseas locations need a way to inform employees about available job openings in these locations. In this project you’ll use database software to design a database for posting internal job openings and a Web page for displaying this information.

KTP Consulting operates in various locations around the world. KTP specializes in designing, developing, and implementing enterprise systems for medium- to large-size companies. KTP offers its employees opportunities to travel, live, and work in various locations throughout the United States, Europe, and Asia.

The firm’s human resources department has a simple database that enables its staff to track job vacancies.

When an employee is interested in relocating, she or he contacts the human resources department for a list of KTP job vacancies. KTP also posts its employment opportunities on the company Web site.

What type of data should be included in the KTP job vacancies database? What information should not be included in this database? Based on your answers to these questions, build a job vacancies database for KTP. Populate the database with at least 20 records. You should also build a simple Web page that incorporates job vacancy data from your newly created database. Submit a copy of the KTP database and Web page to your professor.