Using only DOS-based Oracle SQL and answer for the following questions. Again, you MUST use DOS-based SQL. NOT accept other SQL programs. For each question, copy each screen shot of the DOS-based SQL code run/output screens, and paste them into your Assignment. For example: DOS-Based SQL

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)

FIGURE 10.6 Two data dictionary tables (a) TABLES table Table Table length Name 500 Salesperson Customer 6.400 127,000 Customer Employee 83,000 Product 273,000 Sales Office 600 (b) ATTRIBUTES table. Attribute Attribute Nome Type Salesperson Number Numeric Salesperson Name Alphabetic Commission Percentage Numeric Year of Hire Numeric Customer Number Numeric Customer Name Alphabetic HQ City Alphabetic Number A23 A23 A23 A47 A47 A47 Attribute Length 20 20 15