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?