Group8Project2Dictionary

Group8Project2Dictionary - Group 8 Jenna Sicard, Marshall...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Group 8 –Jenna Sicard, Marshall Brown, Ted Voygles Project 2 - ER-Diagram Thurs. September 15, 2011 Data Dictionary Entity: Customer Description: A person who buys songs from myTunes Attribute Table: Attribute Name Description Null SQL Data Type custId Number that uniquely identifies a customer No char(5) custFirstName Customers first name No char(15) custLastName Customers last name No char(15) custEmail Customers email address No char(50) custUsername Customer's website login username No char(15) custPassword Customer's website login password No char(15) Entity: Songs Description: A track from a album by a Artist Attribute Table: Attribute Name Description Null SQL Data Type songName The name of the Song No Char(20) songArtist The Artist of the Song No Char(20) songGenre The Genre the Song is in No Char(20) songAlbumNa me The Name of the Album No Char(20) songPrice The Price of the Song No Number(4,2) Entity: Date Description: The Date a Customer Purchased a Song Attribute Table: Attribute
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/13/2012 for the course IT 3233 taught by Professor Aashiem during the Fall '11 term at Georgia Southern University .

Page1 / 2

Group8Project2Dictionary - Group 8 Jenna Sicard, Marshall...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online