HPlogo Getting Started with HP IMAGE/SQL: HP 3000 MPE/ iX Computer Systems > Chapter 4 A Database Example

The Example Application

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

Suppose a radio station wants to have a database of classical music recordings for use by the program director and announcers. The station needs this information to plan a schedule of broadcasts, to maintain a log of what is played, and to publish a monthly listener guide. Here is some of the information that will be needed:

  • Album title, price, and duration

  • Recording company and date recorded

  • Medium (CD or cassette)

  • Selection titles and duration

  • Names of orchestra, conductor, singers, accompanists

  • Composer's names and other personal information

  • Miscellaneous comments

  • Date, time, and announcer for selections played

We will call these items attributes. They tend to fall into different categories. Some pertain to albums, some to specific selections, and others relate to when the selection is played. Before the database can be created, the attributes must be organized into logical entities.

Feedback to webmaster