1. Using Happy Crusie Lines (30 points). *Attached File

1. Using Happy Crusie Lines (30 points). *Attached File

You have just been named Director of Data Administration of Happy Cruise Lines. Happy Cruise Lines maintains a central IS organization with several operational relational databases on several large server computers at its headquarters. Each of its cruise ships has a medium-scale server on board with its own databases that help manage the running of the ship. Real-time transmissions are made between headquarters and the ships via satellite that keep both the headquarters and shipboard databases constantly up-to-date.

1.1. What is a data dictionary? List some typical uses of the data dictionary. Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for Happy Cruise Lines’ database, shown in Minicase 5.1. Your answer should be based on the format shown in Figure 10.6. Use your judgment as to attribute type values, length values, etc. (You MUST use Oracle and copy/paste the result)

1.2. Create a relationships table for this tables and attributes data, using the format in Figure 10.7. (You MUST use Oracle and copy/paste the result)

2. Describe the DBA’s responsibilities. How can the DBA function be placed within the organization chart? What effect(s) will such placement have on the DBA function? (10 points)

3. What is Business Intelligence (BI)? Give some recent examples of BI usage, using the Internet for assistance. What BI benefits have companies found? (10 points)

Is this the question you were looking for? If so, place your order here to get started!