A publishing company produces scientific books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more publications. A publication covers essentially one of the specialist subjects and can have more than one author. When writing a particular book, authors work with one editor, but may submit other works for publication to be supervised by other editors. To improve their competitiveness, the company tries to employ a variety of authors, more than one author being a specialist in a particular subject.
Resulting tables after combining User Views 1 and 2 are as follows:
Editors(EdNum,EdFirst,EdLast,EdPhone, EdEmail)
Authors (AuthId, AuthFirst, AuthLast, AuthEmail, SubAreaId)
You will now work on User View 3 and later on User View4
User View 3: Authors can publish several publications but all publications are in a single subject area specialty. Authors work with a single editor for each publication but can author several publications at the same time. We need to track the author number along with their publications (id and name of publications) editor assigned to the publication (editor number and name) and subject area name.
Our intitial requirements can be represented as follows in DBDL notation:
AuthorPublications(AuthId, (PubId, PubName, EdNum, EdFirst, EdLast), SubAreaName)
Proceed with all steps in information-level design to add this user view to the existing cumulative design.
Step 1. Is this table in1st NF?___No____ . If Yes skip to Step 2.
If not, write the Table in DBDL notation after applying the methodology we use for converting into 1NF