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?

Reviews

Write a Review

Operation Management Questions & Answers

  Manage inventory to meet predictable variability of demand

1. Discuss the approaches a firm can use to manage inventory to meet predictable variability of demand. (max. one and a half pages)2. Discuss key issues to be considered when implementing aggregate planning (one and a half pages)

  Principles of the corporate social justice approach

Discuss in scholarly detail the defining principles and the implementing principles of the corporate social justice approach.

  Social security for retirees is paid through payroll taxes

Social security for retirees is paid through payroll taxes on the current workforce. However, because retirees are living longer and increasing in number, the inflow of payroll tax revenue from workers at some point will be insufficient to fund the o..

  Destinations where uncontrolled tourism growth

Give three examples of destinations where tourism planning has been successful, as well as three destinations where uncontrolled tourism growth has taken place.

  Examples of cross functional decision making

In a paper, review and define the most important operations functions and provide examples of cross functional decision making, operations process, supply chain management, strategies, new product designs, QFD, and modular designs.

  Distinguish between utilization and efficiency

What are the four special considerations for a good capacity decision? Distinguish between utilization and efficiency.

  What is excelsiors annual inventory carrying cost

Excelsior's proiducts average inventory is valued at $500,000. Inventory is ordered 52 times per yearat a reordering cost of $700/per order. THe cost of carrying inventory is 20%. What is Excelsiors annual inventory carrying cost?

  Decrease the probability of a favorable rental market

Philip Musa can build either a large video rental section or a small one in his Birmingham drugstore. He can also gather additional information or simply do nothing. If he gathers additional information, the results could suggest either a favorable o..

  Failure of washington mutual

Closure of Seattle-based saving and loan association Washington Mutual (WaMu) was by far the biggest bank failure in the history of the United States.

  Write a paper on organizational culture

This week you learned about the importance of shaping culture and how it is a critical function of leadership.

  What step-by-step approach would you propose in making a

a local cable company zeron has had a monopoly on cable services in the county. as a result the number of customers has

  Identify five main points you plan to make about the values

Identify five main points you plan to make about the values of having a diverse workforce, and present a detailed sample agenda for your meeting.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd