IPT home IPT A Virtual Approach by Peter Whitehouse
Quick Links:
 
 
Access home
Information and Intelligent Systems Social and Ethical Implications Human Computer Interaction Software and Systems Engineering eXercise Files Course Outline and Assessment A-Z of Geeky Acronyms Terrace Work Program 2004 Sillybus FAQ = Frequently Asked Questions Help
 
 

A Case Study

Defining the Music Database

Using the table and relationship definitions that follow, construct your own version of the MUSIC DATABASE in Access.

Table Create window

Table: Albums

  • SerNum text(15)
    • Desc: Unique ID from album pressing cover
    • required: YES
    • index: YES(No Duplicates)
    • Validation Text: You must enter a unique serial number
    • Primary Key.
  • AlbName text(35)
    • Desc: The title of the recording
    • required: no
    • index: YES(Duplicates OK)
  • Artist text(30)
    • Desc: The name of the artist/group that recorded this pressing
    • required: no
    • index: YES(Duplicates OK)
  • Media text(2)
    • Desc: The media of this pressing (CA, CD, LP, EP)
    • required: YES
    • index: YES(Duplicates OK)
    • Validation Text: You MUST KNOW what media you have this on
  • PDate text(4)
    • Desc: The year of publishing for this pressing
    • required: no
    • index: YES(Duplicates OK)
  • RecCo text(10)
    • Desc: The publishing Co. of this pressing
    • required: no
    • index: no

Table: Performers

  • SerNum text(15)
    • Desc: From Albums
    • required: YES
    • index: YES(Duplicates OK)
    • Validation Text: You must enter a unique serial number
    • Primary Key.
  • Artist text(30)
    • Desc: The name of the performer
    • required: YES
    • index: YES(Duplicates OK)
    • Primary Key.
  • Instrument text(25)
    • Desc: The instrument played by them on this pressing
    • required: YES
    • index: YES(Duplicates OK)
    • Primary Key.

     

Table: Tracks

  • SerNum text(15)
    • Desc: From Albums
    • required: YES
    • index: YES(Duplicates OK)
    • Validation Text: You must enter a unique serial number
    • Primary Key.
  • Song text(60)
    • Desc: The song title
    • required: YES
    • index YES(Duplicates OK)
    • Validation Text: The song must have a title or track #
    • Primary Key.

     

 

wonko@wonko.info
©Copyright t 1992..2017+. Edition 25.150117
wonkosite
Creative Commons License
This work is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 2.1 Australia License
.