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

Previous Q& A

  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.

  Identify a few problems related to your nature of business

Identify a few problems related to your nature of business. Next, select the most important problems or failures to analyse further.

  What is the least-cost combination of labour and capital

What is the least-cost combination of labour and capital to employ in producing 80 units of output? Explain

  Drilling in a normally pressured zone

If you are drilling in a normally pressured zone, what pressure would you expect at 12,000 ft. (TVD) (TVD is True Vertical Depth) (round off to the nearest whole number)

  How does it serve general public to have medical provider

How does it serve the general public to have medical provider outcomes data posted publicly, even though the general population may not know how to interpret the data

  Use molecular orbital theory to predict

Use molecular orbital theory to predict whether the bond order in the superoxide ion, O2-, should be higher or lower than the bond order in neutral O2 molecule.Is the bond order of O2- higer or lower than that of O2?

  Using the information in the t-accounts classified balance

The Prepaid Expense account includes a two-year insurance policy purchased on January1, 2015 for $12,000. Claudia has been properly recognizing insurance expense eachmonth (up through August).

Reviews

Write a Review

 

Similar Q& A

  Explain how erp meets the needs of the stakeholders

Explain how ERP meets the needs of the Stakeholders

  Different types of computer systems

Finally, review different types of computer systems. Make recommendations on the types (you do not need to include brands or specifications) of computers that will help the employees and suppliers better use the system

  Discuss how honeypotting and sandboxing can aid

Discuss how honeypotting and sandboxing can aid in the evidence-gathering process. Conclude whether or not you believe these techniques to be feasible for organizations of all sizes. Provide a rationale with your response

  Draw the pipeline execution diagrams

In snippet A, the branch is taken twice and then not taken. In snipped B, first branch is taken once and second branch is also taken once.

  What is the copy constructor for a weighted digraph in c++

What is the copy constructor for a weighted digraph in c++?

  Explain specific challenges of facing designer

Explain specific challenges of facing the designer, specifically with regard to limitations of hardware, software and interface design two paragraph each.

  A static method that takes an array of integers as parameter

Write a static method that takes an array of integers as a parameter and returns back an integer that is the sum of all of the integers in the array.

  Faulty terminations and excessive horizontal wiring spans

What do you consider the single most important reason to pay attention to faulty terminations and excessive horizontal wiring spans?

  What are the phases of an attack

What are the phases of an attack? Based on what you have read, which step is the "most important?" Explain. Why is it important to understand these phases once an attack is detected? How does knowing about these phases help you? In your opinion, is a..

  Create a website consisting of many pages

create a website consisting of many pages organized in groups of pages linked off of the main page. The website hierarchy and key page namesare given

  Calculate the total of the scores by using while loop

Write a program to calculate the average of the class by following steps: 1. Ask user input how students in the class 2. Use random function to generate the score (between 0 and 100) for each student and calculate the total of the scores by using ..

  Computer science programming question

Critique this nightclub website using Jakob Nielsen's web design heuristics. This critique must not exceed 2 pages.

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