Analytical skills in analyzing a case scenario

Assignment Help Basic Computer Science
Reference no: EM13849979

The purpose of this assignment is to promote students analytical skills in analyzing a case scenario and utilizing the given information and resources to design an ER diagram and write SQL script.

Case Scenario:

XYZ Pulishing 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 suthor, their phone# and email address, and the subject area that they specialze in. each author only specializes in one subject. Those subjects may include Biology, Physiscs, 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 book 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:

  1. Name of the authors and the name of the editors.
  2. Books that have been published for a particular subject area.
  3. Editor that have worked on books for a particular subject.

Reference no: EM13849979

Questions Cloud

Describe the military events which composed d-day : Outline the factors which resulted in the choice of Normandy as the site of D-Day. What other options did the Allies contemplate, and where these alternatives sites ruled out. Describe the military events which composed D-Day on the beaches of bot..
How will help in re-branding maya : How will help in re-branding Maya? What changes must Maya conduct to attract community the confidence of the community? In your opinion should Maya go on a MBO or offer of sale?
Prepare measures to prevent recurrence : Prepare Measures to Prevent Recurrence - What organisational, systemic, and/or societal changes are needed and consider changes in personnel, organisation structure, policy, law, and technology in your response.
Discussing the history of ireland as well as issues : Discussing the history of Ireland as well as issues that apply to America. , e.g., persecution and prejudice, resilency in the face of all this, the motives for coming to the States, the abuse of religious and political power by those in charge [t..
Analytical skills in analyzing a case scenario : The purpose of this assignment is to promote students analytical skills in analyzing a case scenario and utilizing the given information and resources to design an ER diagram and write SQL script.
Draw bridgettes budget constraint : Draw Bridgettes budget constraint, putting mystery novels on the horizontal axis. At her consumer optimum, she buys 30 CDs and 15 mystery novels.
What strategies are addressed for the project : Identification of the professional accounting, management and/or public relations issues in your workplace - How do you applied knowledge from this degree study in solving your workplace problems, including appropriate analysis and justification
Define what is strategic value and competitive advantage : Define what is strategic value and competitive advantage. Identify the value and competitive advantage of POPstation strategy à creating value to customers, explain how expanding on POPstation delivers value to customers
Identify and treat psychiatric conditions : Analyze controversy within the context of how clinicians ethically identify and treat psychiatric conditions. Be sure to integrate knowledge of any appropriate cultural considerations psychologist must be aware of when diagnosing gender dysphoria.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Evaluate the natural settings of the test environment

Assess the reliability of data gathered via paid Internet users. Describe and assess the evaluation method being used by the testing company, i.e., nonvisual and verbal recording of browser activities and tester's vocal comments.

  An administrator for the contoso corporation

You are an administrator for the Contoso Corporation. You have a large server that is running Windows Server 2012 and that has about 8 TB of disk space that you can allocate to be used by other servers. What can you do so that two other servers runni..

  Determine how to set up the server for the future expansion.

Habibi's has a small network of 20 client workstations and a Windows Server 2008. Seven of those workstations are inside the restaurant and are used by the table servers to place customer orders.

  Describe the social implications of gaming

Within 500 words, describe the social implications of gaming. Besides entertainment, think of other aspect of our society that can be affected by gaming.

  Write method called swappairs accepts string as parameters

Write a method called swapPairs that accepts a String as a parameter

  Multiplexors whose control bit allows

Multiplexors whose control bit allows you to select between one of two modes right shift or left shift. Include logic to perform arithmetic shift left and arithmetic shift right . This means you must include logic to perform sign extension in ..

  Describe the purpose of a risk assessment

Describe the purpose of a risk assessment

  Network connectivity and protocols

Network Connectivity and Protocols-

  Two main functions of user accounts in a network

What are the two main functions of user accounts in a network?

  The built in python string functions

letterCount(letter, myString) This function should take a single letter, and then a string. It should return the number of times letter occurs in myString. So the call letterCount('h', 'hello') should return 1, and the call letterCount('a', 'aa..

  Variables-constants and data types

Document the steps for the logic structure to capture the payment information. This can be done as either a flowchart or pseudocode. Be sure to include inputs, variable declarations and assignments, and outputs.

  Write a program that will continuously prompt the user grade

Write a program that will continuously prompt the user for a grade (in the range of 0 to 100) until a sentinel value of 999 is entered. The program will then display the average of all grades entered, formatted to 1 decimal place. Assume the grades 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