Database in an information system

Syllabus outcomes:

P5.1 Selects and ethically uses computer based and non-computer based resources and tools to process information.

P6.2Generates ideas, considers alternatives and develops solutions for a defined need.

P7.1 Recognises and applies management and communicates techniques to project work.

Instructions

A school library needs a system to classify videos. They decide to use the Dewey Decimal system to identify items because it is familiar to their users. The information they have to begin a database is shown below.

  1. Design a data dictionary dor this data.
  1. Enter the data into a database table and save the file.
  1. Sort the data into order using ascending and descending sorts o find the following information:
  1. the first item that will be in the library video collection
  2. the last item that will b in the library video collection
  3. the first item that will appear in an alphabetical listing by title
  4. the last item that will appear in an alphabetical listing by series.
  5. the video with the longest viewing time
  6. the video with the shortest viewing time.
  1. In form view of the database, add a graphic or drawing to the records.
  2. Save the file.
  3. Write a report for the library on the effectiveness of using a database for this purpose (about ½ page in length).

306 ABL / Aboriginal Studies / Who Killed Malcolm Smith? / 60 min / Aboriginal Studies
306 ABL / Aboriginal Studies / Return to Box Ridge / 45 min / Aboriginal Studies
306 ABL / Aboriginal Australia / Mabo and its impact / 12 min / Aboriginal Studies
306 ABL / Aboriginal Australia / Mangugi woman / 10 min / Aboriginal Studies
306 ABL / Aboriginal Australia / Aboriginal enterprise / 12 min / Aboriginal Studies
750 ART / Art Work / Design Process / 60 min / Art
751 DUR / Albrecht Durer / Using Watercolour Pencils / 30 min / Art
751 LEA / The Master Video / Learn to Paint Oils / 88 min / Art
371.4 JOB / School leavers / Job Interviews / 20 min / Careers
420 PRE / Resumes / Preparing a Resume / 21 min / Careers
338 COM / Commerce / Buy now, pay later / 30 min / Commerce
338 COM / Commerce / Law / 20 min / Commerce
381.3 CON / Consumer Power / Budgeting / 15 min / Commerce
658.8 COM / Commerce / Retail selling / 30 min / Commerce
004.16 BIT / Bits and Bytes / Basics / 30 min / Computing
004.16 BIT / Bits and Bytes / Numbers / 30 min / Computing
420 YOU / You can write anything / Getting ideas / 15 min / English
808 WRI / Writing a Formal Essay / Writing a Formal Essay / 30 min / English
808.5 DEB / Debating Techniques / Debating Techniques / 40 min / English
808.51 FIN / The Finding Out Series / Oral Presentation / 17 min / English