Create conceptual and logical model

Assignment Help Operation Management

Reference no: EM13840556

Create a Conceptual and Logical Model using the following requirements.

An information studies student wants to keep track of the following information. A publishers publishes two kinds of publications: books and journals. Any one publisher publishes at least one book and/or at least one journal. Each book can be written by one or more authors and one author can write one or more books. Each book and journal is characterized by one or more indexed keywords, which are represented by a keyword number and keyword. Not every keyword is used by the journals, however. Both books and journals have a unique number (such as ISBN# for a book and ISSN# for a journal), title and a publisher. For books, the student tracks the published year, all author information and their institutions. For journals, the student keeps the starting year first published, the number of issues to be published per year and the category of the journal (such as academic, newsletter, trade). Each publisher has name, address and phone. Each author has an ID number, name, address, phone, author's affiliated institution and the address of the institution. An author may be affiliated with more than one institution. The student would like to keep only authors who are participating in writing at least one book and institutions that have such authors.

Reference no: EM13840556

Questions Cloud

What is the average number of customers in service : Robert Utes needs to decide where to get a haircut. He has narrowed the choice down to two local hair salons – Large Hair Salon (LHS) and Small Hair Cutters (SHC). If Robert walks into LHS during a busy period, how long must he wait in line (in minut..

A potassium permanganate solution is prepared by dissolving : A potassium permanganate solution is prepared by dissolving 4.6802g of KMnO4 in water and diluting to 500.0 ml. How many ml of this solution will react with all the iron in 0.5g of an ore contains 35.62% Fe2O3?

Provide emergency medical consultations : A company has started a phone service that uses overseas doctors to provide emergency medical consultations. The responding doctors are based in a country with low wages but with a highly skilled pool of physicians. Responding to each call takes on a..

Write a balanced chemical equation : Solid NH4NO3 (ammonium nitrate) decomposes on heating to 400°C, forming N2O gas and water vapor, H2O. (a)Write a balanced chemical equation

Create conceptual and logical model : An information studies student wants to keep track of the following information. A publishers publishes two kinds of publications: books and journals. Any one publisher publishes at least one book and/or at least one journal. Each book can be written..

Fow rate and composition in terms of mole fractions : Propane in the feed to the unit and 80% of the pentane fed to the unit. The mole fraction of butane in the distillate is yB ? 0.4 . The bottom stream contains all of the hexane fed to the unit. Calculate the distillate and bottoms streams flow rate a..

Corporate officers may be held liable for criminal acts : They contract with Novelty Now Inc., a company based in Florida, to manufacture and distribute the product. Chris frequently meets with a representative from Novelty Now to design the product and to plan marketing and distribution strategies. Apply c..

Use a holding tank in order to mix the light naphtha : A standard practice in refineries is to use a holding tank in order to mix the light naphtha output of the refinery for quality control. During the first six hours of operation of the refinery, the stream feeding the holding tank at 200 kg/min had 30..

Value manufacturing perspective to defining quality : Discuss the value manufacturing perspective to defining quality?

User Account

All Pages