DB_Proj1_Entities_Att-2

DB_Proj1_Entities_Att-2 - Jenna Sicard Marshall Brown Ted...

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

View Full Document Right Arrow Icon
Jenna Sicard Marshall Brown Ted Voyles September 5, 2011 IT 3233 – Database Design and Implementation Project 1 – Entities and Attributes Entity: Artist Description: The person/persons whose voice/work is available to be downloaded. Attribute Table: Attribute Name Description Null SQL Data Type artistId Number that uniquely identifies an artist No char(10) artistName Artist’s Name No char(30) artistOrginalName Artist’s Birth Name and/or Members Names No char(100) artistsOrigins Origins of the Artist No char(30) artistsGenre Artist’s Genre(s) No char(50) artistLabel Artist’s Label No char(20) artistNumOfAlbums Artist’s Number of Albums No char(15) artistYearsActive Artist’s years active No char(15) Entity: Album Description: A collection of related or music tracks from an Artist. Attribute Table: Attribute Name Description Null SQL Data Type albumID Number that uniquely identifies a album No char(10) albumName Album’s Name No char(30) artistName Album’s Artist’s name
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.

Page1 / 2

DB_Proj1_Entities_Att-2 - Jenna Sicard Marshall Brown Ted...

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