A table for a publishing company database, with schema PUBS( authorid, name, ins

Question

A table for a publishing company database, with schema

PUBS( authorid, name, institution, title, journal, volume, num-pages, editorid)

giving us the author of a publication, the author's name and institution, the title of the publication, the journal and volume where it appeared, the number of pages and the id of the editor. The following FDs hold:

authorid -> name institution

title -> journal volume num-pages

journal -> editor

a) What are the keys of relation PUBS?

b) In what normal form is PUBS?

c) If you believe that PUBS is not in 3NF, decompose it so that all resulting relations are in 3NF and the decomposition is loseless.

Explanation / Answer

a) Key of relation PUBS: authorid, title

b) relation is in 2NF

c) Decompose it into {authorid, name, institution}, {title, journal, volume, num-pages}, {journal, editor}

All the resulting relations are in 3NF and decomposition is loseless.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.