Scribd
Upload
43 views3 pages

Question No 1

The document describes different entity types with their attributes and primary keys. It identifies the Musician, Instrument, Album, and Song entities. The Musician entity has a strong key of SSN. Its attributes are SSN, Name, Phone, and Address. SSN is a unique string that identifies each musician. The Instrument entity has a primary key of ID. Its attributes are ID, a unique string, and Iname, the instrument name. The Album entity has a primary key of A_ID, a unique album ID number. Its attributes include A_ID, A_TITLE, and COPYRIGHT_DATE. The Song entity has a primary key of TITLE. Its attributes are TITLE

Uploaded by

Syed Jarar Ali Bukhari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
43 views3 pages

Question No 1

The document describes different entity types with their attributes and primary keys. It identifies the Musician, Instrument, Album, and Song entities. The Musician entity has a strong key of SSN. Its attributes are SSN, Name, Phone, and Address. SSN is a unique string that identifies each musician. The Instrument entity has a primary key of ID. Its attributes are ID, a unique string, and Iname, the instrument name. The Album entity has a primary key of A_ID, a unique album ID number. Its attributes include A_ID, A_TITLE, and COPYRIGHT_DATE. The Song entity has a primary key of TITLE. Its attributes are TITLE

Uploaded by

Syed Jarar Ali Bukhari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Question No 1.

Look at the Figures and identify the types of attributes and fill
it. Also give reason in 2 lines that why you chose this particular type.

key

Musician– Strong Entity


MUSICIAN
Primary Key: SSN
SSN
Attributes:
NAME
1. ssn: - Social Security Number unique to each person
 String with length of 9 characters; no nulls; unique. PHONE

ADDRESS

2. name : Name of Artist


 string with any value; no nulls; not unique; single-valued

and simple.

3. phone: Phone number


 string with length of 10 chars;
4. Address: street Address
 String of length 40 chars; nulls not allowed; not unique.

Instrument: Entity INSTRUMENT


Primary Key: ID ID

Attributes: M_Key

1.ID: - unique ID to each instruments Iname

 String with length of 8 characters; no nulls; unique.

2.Iname : Name of Instruments


 string with any value; no nulls; not unique.
3. M_Key: Musical keys
 string with length of 10 chars;

Album
Album – Entity :
A_ID
Primary Key: A_ID A_TITLE
Attributes: FORMAT
1.A_ID: - unique Ablum ID Number COPYRIGHT_DATE

 String no nulls; unique.

2.A_TITLE : Name of Album


 string with any value; no nulls; not unique.
3. COPYRIGHT_DATE: Copyright date of Album
 string no null, no unique.

Album – Entity :
Primary Key: TITLE SONG
Attributes: TITLE

1.TITLE : Name of Song AUTHER

 string with any value; no nulls; not unique.


2 auther: Name of auther
 string no null, no unique.

ER-DIAGRAM:

You might also like