I need solution for Problem no. 12

Part I . The Content of Database Management Problems and Exercises For each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-to many or a many-to-many relationship. Then, using the STORE shorthand notation introduced in the textdraw a diagram for each of the relationships STUDENT and COURSE (students register for courses) b. BOOK and BOOK COPY (books have copi G COURSE and SECTION (courses have sections) CUSTOMER SECTION and ROOM (sections are scheduled in rooms) e, INSTRUCTOR and COURSE 2. Reread the definitions for data and database in this chip terDatabase management systems only recently began to FIGURE 1-21 Data model for Problem and Exercise a include the capability to store and retrieve more than nu meric and textual data, what special data storageretrieval, a what is the relationship between Pet and Store (one to and maintenance capabilities do images, sound, video, and onemany-to-many, or any? other advanced data types require that are not required or b. What is the relationship between Customer and Pet? are simpler with numeric and textual data C. Do you think there should be a relationship between 3. Table 11 shows example metadata for a set of data items. Customer and Stone? Identify three other columns for these data (ie, three other 9. Consider Figure 1-12, which depicts a hypothetical three metadata characteristics for the listed attributes) and com tiered database architecture. Identify potential duplication plete the entries of the table in Table 1-1 for these three ad of data across all the databases listed on this figure. We ditional columns. problems might arise because of this duplication? Does this 4. In the section "Disadvantages of File Processing Systems, duplication violate the principles of the database approact the statement is made that the disadvantages of file process outlined in this chapterWhy or why not? ing systems can also be limitations of databases, depending 10. What is your reaction to the representation of the system on how an organization manages its databases. Firstwhy development life cycle included in this chapter? Expl do organizations create multiple databases, not just one all any problems you have with it. inclusive database supporting all data processing needs? 1 List three additional entities that might appear in an era Second, what organizational and personal factors are at terprise data model for Pine Valley Furniture Company work that might lead an organization to have multiple, in (Figure 13a). dependently managed databases (and, hence, not completely 12. Consider your business school or other academic unit follow the database approach) business enterprise. 5, Consider a student club or organization in which you are a a Define several major data entity types and draw a member what are the data entities of this enterprise List iminary enterprise data model similar in notation and define each entity. Then, develop an enterprise data Figure 1a. model (such as Figure 1-3a) showing these entities and in b. Would your business school or academic unit benefit portant relationships between them. from a multitiered architecture for data? Why or wt 6. A driver's license bureau maintains a database of licensed 13. Contrast the top-dow in nature of database development drivers State whether each of the following during conceptual data modeling with the bottom or metadata. If it represents data, state whether it is strue nature of database development during logical database tured or unstructured data. If it represents metadata, state design. What major differences exist in the type of informed whether it is a fact describing a property of data or a fact tion considered in each of these two database develop describing the content of data a Driver's name, address, and birth date 14. The objective of the prototyping systems development b. The fact that the driver's name is a 30-character field methodology is to rapidly build and rebuild an informer A photo image of the driver tion system as the user and systems analyst learn from 9. An image of the driver's fingerprint use of the prototype what features should be included The make and serial number of the scanning device that in the evolving information system. Because the final was used to scan the fingerprint prototype does not have to become the working system The resolution (in megapixels) of the camera that was where do you think would be an ideal location to develop used to photograph the driver prototype on a computerdepartment serve 8. The fact that the driver's birth date must precede today's or enterprise server? Does your answer depend on any date by at least 16 years assumptions 7. Great Lakes Insurance would like to implement a relational 15. Explain the differences between an enterprise data model database for both its in-house and outside agents. The out and a conceptual data modelHow many databases does side agents will use notebook computers to keep track of each represent what scope of the organization does eact customers and policy information. Based on what you have address what are other client differences? learned in this chapter, what type for types) of databases) 16. Is it possible that during the physical database design and would you recommend for this application? creation step of database development you might want to 8. Figure 1-21 shows an enterprise data model for a pet store. retum to the logical database design activity? Why or