Dmlis 540 Spring 2004 Information System Project mecca pop and Jazz Music For Family Learning and Enjoyment All Team members participated in the development of the spec Project Manager: Carolyn Karis Information Architect: Emily Wheeler

Data Model 5.1.Relational Data Structure

Download 0.56 Mb.

Page	6/13
Date	17.05.2017
Size	0.56 Mb.
	#18448

1 2 3 4 5 6 7 8 9 ... 13

5.1.3.Data Dictionary

5.Data Model

5.1.Relational Data Structure

5.1.1.Entity Relationship Diagram

5.1.2.Relational Schema (Diagram)

5.1.3.Data Dictionary

Table	Attribute	Type	Key Type	Description
Artist	Artist_ID	Auto#	Primary Key	Unique artist IDs are given to solo performers, groups, or composers.
	Artist_Name	Text		The commonly recognized name of the artist or group.
	Artist_DOB	Date		Artist date of birth for solo artists and composers. Null value for groups.
	Artist_Website	HTML		Official artist website, if applicable.
	Artist_ Ethnicity	Text		The ethnic background of the artist. This is not a controlled vocabulary. If a group or individual artist reflects multiple heritages, these can all be listed or described in a short paragraph. This is not a searchable field.
	Artist_ Biography	File Accession #		This text will be available for full-text searching in our IR system.
	Artist_Group_ Members	Text		Listing of contributing musicians or group member names. The information in this field will not be searchable.
	Image_ID	Number	Foreign Key	Link to the Lookup table for Image.
Album	Album_ID	Auto#	Primary Key	Unique ID generated for each album.
	Album_Name	Text		Full name of the Album.
	Album_ Commentary	File Accession #		This text will be available for full-text searching in our IR system.
	Image_ID	Number	Foreign Key	Link to the Lookup table for Image.
Song	Song_ID	Auto#	Primary Key	Unique ID for each original version of a song.
	Song_Name	Text		Name of the original version of a song.
	Song_Lyrics	File Accession #		This text will be available for full-text searching in our IR system.
Recording	Recording_ID	Auto#	Primary Key	Unique ID for each recording of a song.
	Album_ID	Number	Foreign Key	Link to the Album table.
	Song_ID	Number	Foreign Key	Link to the Song table.
	Artist_ Composer_ID	Number	Foreign Key	Link to the Artist table.
	Artist_ Performer_ID	Number	Foreign Key	Link to the Artist table.
	Recording_ Name	Text		Full name of the recording (may or may not be the same as the original song name).
	Style_Name	Text	Foreign Key	Link to Controlled Vocabulary for musical styles.
	Recording_ Credits	Text		Unique credits for a recording. might include guest performers, producers, etc. This text field could be quite long, depending upon the recording. However, it will not be searchable.
	Recording_ File	Audio File		A link to the actual audio of the recording.
Style	Style_Name	Text	Primary Key	Lookup table of Controlled Vocabulary terms. This is the musical style of the recording. For example, jazz, blues, pop…
	Style_ Description	Text		Paragraph description of the style. This text will not be searchable.
Instrument	Instrument_ID	Auto#	Primary Key	Unique ID for each instrument.
	Musical_ Instrument_ Name	Text	Foreign Key	Link to Controlled Vocabulary for musical instruments.
	Instrument_ Sample	Audio File		An audio sample of the instrument.
	Instrument_ Background	File Accession #		This text will be full-text searchable through our IR system.
	Image_ID	Number	Foreign Key	Link to Artist table, Album table, and Instrument table.
Musical_ Instrument	Musical_ Instrument_ Name	Text	Primary Key	Lookup table of Controlled Vocabulary terms.
Instrument_Recording	Instrument_ID	Number	Foreign Key	Link to Instrument table. Used in conjunction with the Recording_ID to form the Primary Key for this bridge table.
	Recording_ID	Number	Foreign Key	Link to the Recording table. Used in conjunction with Instrument_ID to form the Primary Key for this bridge table.
Image	Image_ID	Auto#	Primary Key	Unique ID for each image.
	Image_File	Image File		Link to the actual image.
	Image_ Description	Text		Description of the image, including whatever information we know about the image, including date, location, photographer… This field will not be searchable.

Directory: portfolio
portfolio -> Relationships Between Eye Size and Intensity In North Atlantic Hurricanes
portfolio -> Guide to James Bond
portfolio -> End of semester report
portfolio -> End of semester report
portfolio -> Varner Elementary School Media Center Policies and Procedures Handbook Spring 2011 Stephanie Warmoth table of contents
portfolio -> Gresham Portland,OR,us columbus Museum of Art Columbus,OH,US
portfolio -> Contact and Email
portfolio -> Computer Science Program Review December 15, 2008 A. Introduction
portfolio -> Executive summary
portfolio -> Happily Ever After…Or not

Download 0.56 Mb.

Share with your friends:

1 2 3 4 5 6 7 8 9 ... 13