Database to maintain information about authors

Assignment Help Business Economics
Reference no: EM131399562

Case Scenario

XYZ Publishing Company produces scientific books on various subjects. They need a database to maintain information about their authors, editors and books. The author information would include the name of the author, their phone# and email address, and the subject area that they specialize in. Each author only specializes in one subject. Those subjects may include Biology, Physics, Geology, etc.  Each author may be working with more than one editor at any given in time.  Each author may have written many books. The editor information would include the name of the editor, their phone# and email address, the books that they are editing, and the authors they are working with. Each editor may be working with more than one author at any given time. Each editor may be editing many books at any given time.

The book information would include the title of the book, ISBN number, and the subject area that the book covers.  Each book has only one author but may have many editors. Some of the goals that XYZ wants to accomplish with their database include the following information:

  • Names of the authors and the names of the editors.
  • Books that have been published for a particular subject area.
  • Editors that have worked on books for a particular subject.

Reference no: EM131399562

Questions Cloud

What is total number of sales representatives : MKT 5215 Sales Account, Management, and Design Plan Course Project. You are to assume the role of Hart's sales executives and provide "The Plan" by making the following decisions: What is your recommendation for total number of sales representatives
Redo bar graph using counts instead of percentage : Would the comparison of frequency of myopia across the categories of lighting be as easy to make using the bar graph with counts? Generalize your conclusion to provide guidance about what should be done in similar situations.
Emerging technological trends : What are three emerging technological trends that could create challenges to Internet security? What are some ways to mitigate the security risks?
Review the juvenile justice system structure and process : Next, use the Internet to research methods that the state where you live uses to deal with juvenile justice issues. Based on your research, discuss one (1) method the juvenile justice system in your home state currently uses to implement the rehab..
Database to maintain information about authors : XYZ Publishing Company produces scientific books on various subjects. They need a database to maintain information about their authors, editors and books. The author information would include the name of the author
Design an algorithm that produces a binary expression tree : Design an algorithm that produces a binary expression tree from a given postfix expression. You can assume that the postfix expression is a string that has only binary operators and one-letter operands.
Design of a dimensional model : Review the key roles involved in the design of a dimensional model such as data modeler, business analyst, business intelligence application developer, data steward, ETL developer, database administrator, security manager, data warehouse administr..
Describe the effects of the statistical information : Describe the effects that the statistical information on a specific race or ethnicity in the areas of health, crime, employment, or education may have in terms of being a predictor of behavior. Provide your opinion on the most likely effects these..
Describe four issues in the teams that affected performance : Identify and describe four issues in the teams that affected performance. For each issue, suggest solutions that are likely to make the teams more effective.

Reviews

Write a Review

Business Economics Questions & Answers

  Let market demand in the trinkets industry

let market demand in the trinkets industry be given by Q(P) = 55−P. There are only two firms in the industry, and the total cost function for each firm be given by C(qi) = 10 + 25q, where i = 1, 2. 1. Find each firm’s Cournot-Nash equilibrium output,..

  Market invents a new method of production

A firm in a perfectly competitive market invents a new method of production which lowers its marginal costs. Illustrate what happens to its output.

  Government undertake any proactive fiscal or monetary policy

Suppose the economy is initially in long-run equilibrium and the U.S. stock market has a prolonged decrease in shareholder value. Use the AD–AS model to predict short-run changes to real GDP and the aggregate price level. Should the government undert..

  Define power as used in management of business

Define power as used in management of business. Define power as used in management of business

  Society is changing constantly-families has different point

Society is changing constantly and families has different point of view of how to live their life or raise their kids. I think what we know so far as a family will change in the near future. There is gab between our life values, action and behavior a..

  What is the supply function of the fringe

The average avoidable cost for a fringe firm is AAC(q) = 20/q + 5q . The marginal cost function for a fringe firm is MC = 10q . There are 10 fringe firms. The marginal cost of the dominant firm is 2 and the demand function is Q = 100 − P. What is the..

  Book value for each year using the deprecation methods

An asset has an initial cost of $25,000, a useful life of 6 years and a salvage values of $1,000. Calculate the annual depreciation and book value for each year using the following deprecation methods:

  Vertical gap between investment curve and depreciation curve

What is the economic meaning of the vertical gap between the investment curve and the depreciation curve in the Solow diagram?

  Describe an efficient market

Describe an efficient market. Give the theory, implications, and empirical evidence about the three forms of the efficient market hypothesis.

  Explain the effects of an increase in rate of depreciation

Graphically illustrate and explain the effects of an increase in the rate of depreciation (δ) on the Solow growth model. In your graph, clearly label all curves and equilibria.

  Write an expression for the firm profit

A firm produces output using two factors of production according to technology f(x1, x2) = X1^1/2*X2^1/4. The price of output is 4. Factors 1 and 2 cost to the firm w1 and w2 per unit, respectively. Write an expression for the firm’s profit.

  Q1 many small boats are made of fiberglass that is derived

q1. many small boats are made of fiberglass that is derived from crude oil. suppose that the price of oil rises.a.

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