View the step-by-step solution to:

Computer Publishing Inc. In only a decade, Computer Publishing Inc. {CPI} grew from a small textbook publishing house into a large, international...

One of the challenges that a modern business faces is how to organize the overwhelming amount of data collected by that business into meaningful information. Deciding what information should be provided to the company's employees and to others outside the company is one of the most difficult parts of output design. It is also one of the most important aspects of a modern information system.

Read the "Computer Publishing, Inc." case study at the end of Chapter 9 in the course text.

By Day 4

Individually complete the following task:

Post to the group discussion board your answers to questions 1, 2, and 3 of the case study.



1. Consider the contents of this textbook as a template for CPI's database content. Draw a class diagram that represents the book and its key content elements. Expand your diagram to include related product content, such as a set of PowerPoint slides, an electronic book formatted as a Web site or PDF file, and a Web-based test bank.

2. Develop a list of data types required to store the content of the book, slides, and Web sites. Are the relational DBMS data types listed in figure 9-20 sufficient?

3. Authors and editors are often independent contractors, not publishing company employees. Consider the implications of this fact for controls and security How would you enable authors and editors to interact with database? How would you protect database content from hackers and other unauthorized accesses?


Computer Publishing Inc. In only a decade, Computer Publishing Inc. {CPI} grew from a small textbook publishing house
into a large, international company with significant market share in traditional textbooks,
electronic books, and distance education courseware. CPl's processes for deyeloplng books
and courseware were similar to those used by most other publishers, but those processes had
proyen cumbersome and slow in an era of rapid product cycles and multiple product formats. Text and art were deyeloped in a wide yarlety of electronic formats, and conyerslons among
those fomiats were difficult and error—prone- Many editing steps were perfomied with traditional
paper—and—pencll methods- Consistency errors within books and among books and related
products were common. [leyeloplng or reylslng a book and all its related products typically took
a year or more- CPl's president initiated a strategic project to reenglneer the way that CPI deyeloped books and
related products. CPI fom‘red a strategic partnership with Dayls Systems {US} to deyelop
software that would support the reenglneered processes. US had significant experience
deyeloplng software to support product deyelopment in the chemical and pharmaceutical
industries by using the latest deyelopment tools and techniques, including object—oriented
software and relational databases. CPI expected the new processes and software to reduce
deyelopment time and cost. Both companies expected to license the software to other
publishers within a few years. Ajolnt team specified the workfiows and high—leyel requirements for the software. The team
deyeloped plans for a large database that would hold all book and courseware content through
all stages of production. Authors, editors, and other production staff would interact with the
database in a 1urarlety of ways, including traditional word processing programs and Web—based
interfaces. When required, format conyerslons would be handled seamlessly and without error.
All content creation and modification would be electronic—no text or art would eyer be created
or edited on paper, except as a printed book ready for sale. Software would track and manage content through eyery stage of production. Content common
to multiple products would be stored in the database only once. Dependencies within and
across products would be tracked in the database. Software would ensure that any content
addition or change would be reflected in all dependent content and products, regardless of the
final product form. For example, a sentence in Chapter 2 that refers to a figure in Chapter 1
would be updated automatically if the figure were renumbered. If a new figure were added to a
book, it would be added automatically to the related courseware presentation slides. Related
courseware and study material on the 1Il‘u'eb site would automatically reflect changes, such as a
new answer to an end—of—chapter question.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question