Reference no: EM1367101
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.
|
Calculate the values of the work interchange
: Determine the values of the constants a and c and state the units and draw the path on a PV diagram also draw Path on the diagram and calculate the heat and work interchanges between the system and surroundings.
|
|
Concepts of elasticities
: Groupon is a popular group purchasing and daily deals website. In a recent advertisement, a local restaurant to sold buffet vouchers at a steep discount on its website.
|
|
Feeling threatened by possible repercussions
: Identify and explain a condition in which you have observed fear in an organization in which you worked. Fear is defined as "feeling threatened by possible repercussions as a result of speaking up regarding work-related concerns".
|
|
Discuss three major cross-cultural differences
: large Businesses and small now compete in a truly global economy. To become successful in another nation it is essential to understand cultural differences that exist.
|
|
Write table in dbdl notation after applying methodology
: Proceed with all steps in information-level design to add this user view to existing cumulative design. Is this table in1st NF?___No____ . If Yes skip. If not, write Table in DBDL notation after applying the methodology we use for converting into 1NF..
|
|
Agent relationship in aging services
: Describe the problems which could exist in the principal and agent relationship in aging services like case manager and an nursing home.
|
|
Country economic and trade summary reports
: Global marketing managers must understand economics and trade rules of countries and regions within which they trade.
|
|
Positive clinical and financial outcomes
: The evolution of health care delivery models has resulted in positive clinical and financial outcomes across the continuum of care. Recognize one health care delivery model.
|
|
Design e-r diagram to review hospital documents
: Design an E-R diagram for the following situations. From discussions with hospital staff, reviewing hospital documents and studying existing information systems, study team developed list of business rules
|